Professional Web Applications Themes

Alternate db location - PostgreSQL / PGSQL

Hi all, I am installing 8.0.1 on FC3. The initial installatin went well. I am now trying to change and use a different directory /pg_data. I have established and exportede PGDATA and it is /pg_data. I have mkdir /pg_data and changed the owner to postgres and run chmod with 700 on the directory. Whenever it log in as user postgres and run initdb I get the output of the attached file. Does anyone have any ideas? AFAIK I have follwed the docs. Thanks, Bob Hartung ---------------------------(end of broadcast)--------------------------- TIP 8: explain yze is your friend...

  1. #1

    Default Alternate db location

    Hi all,
    I am installing 8.0.1 on FC3. The initial installatin went well. I am now
    trying to change and use a different directory /pg_data. I have established and
    exportede PGDATA and it is /pg_data. I have mkdir /pg_data and changed the
    owner to postgres and run chmod with 700 on the directory. Whenever it log in as
    user postgres and run initdb I get the output of the attached file.
    Does anyone have any ideas? AFAIK I have follwed the docs.

    Thanks,

    Bob Hartung



    ---------------------------(end of broadcast)---------------------------
    TIP 8: explain yze is your friend

    rwhart@mchsi.com Guest

  2. #2

    Default Re: Alternate db location

    On Tue, 2005-02-15 at 09:16, com wrote: 

    Looks pretty normal, is it just hanging there, or does it finish
    eventually?

    ---------------------------(end of broadcast)---------------------------
    TIP 3: if posting/reading through Usenet, please send an appropriate
    subscribe-nomail command to org so that your
    message can get through to the mailing list cleanly

    Scott Guest

  3. #3

    Default Re: Alternate db location

    com writes: 

    Hmm, the "default max_connections" and "default shared_buffers" values
    are pretty fishy: those are the minimums that initdb will select if
    the postgres bootstrap process failed to start with anything larger.
    I interpret the above as saying that postgres boot won't start at all.
    What do you see if you start it by hand, ie

    postgres -boot -x0 template1

    regards, tom lane

    ---------------------------(end of broadcast)---------------------------
    TIP 8: explain yze is your friend

    Tom Guest

  4. #4

    Default Re: Alternate db location

    On Tue, 15 Feb 2005 com wrote:
     

    Are you running SElinux with the targeted policy, in enforced mode?
    I think this is FC3 default. Check /var/log/messages for audit errors.

    You need to modify your policy if you want PostgreSQL (or any other
    daemons affected by the targeted policy, that is most of them) to be able
    to access data in non standard directories. I've been through it, it's not
    that hard. Alternatively, you may run SElinux in permissive mode or
    disable it entirely. See /etc/sysconfig/selinux (there's also a GUI tool
    to set SElinux behaviour but I always forget its name). Please note
    that disabling SElinux affects the security of _all_ daemons.

    As a quick test, you may run:

    # setenforce 0

    and then launch the initdb. Watch for audit errors in messages.


    BTE, has anyone tried with:

    setsebool postgresql_disable_trans=0 ?

    Unluckily, I don't have a test host at hand at the moment. Maybe
    in the targeted policy that's enough to disable controls on PostgreSQL,
    while leaving other daemons confined. I'm not sure, tho, I'm just getting
    started with SElinux.

    ..TM.
    --
    ____/ ____/ /
    / / / Marco Colombo
    ___/ ___ / / Technical Manager
    / / / ESI s.r.l.
    _____/ _____/ _/ it

    ---------------------------(end of broadcast)---------------------------
    TIP 7: don't forget to increase your free space map settings

    Marco Guest

Similar Threads

  1. Error: That location is controlled by another site.Please choose another location
    By zelen2 in forum Macromedia Contribute Connection Administrtion
    Replies: 0
    Last Post: February 24th, 03:36 PM
  2. Alternate location for php.ini
    By Artco News in forum PHP Development
    Replies: 15
    Last Post: November 5th, 04:46 AM
  3. Using alternate web servers
    By Nida Farid in forum ASP.NET Web Services
    Replies: 1
    Last Post: August 23rd, 12:05 AM
  4. alternate SQL in asp page
    By Raphael Gluck in forum ASP
    Replies: 10
    Last Post: August 10th, 07:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139