On Sun, Sep 18, 2011 at 01:15:15PM +0200, Martin Pitt wrote: > tag 640451 moreinfo > thanks > > Hello John, > > John Darrah [2011-09-04 16:32 -0700]: > > In order to be able edit pg_hba.conf and postgresql.conf > > from PgadminIII you need to make several changes to the > > default install. > > > > First make the following symlinks: > > > > ln -s /etc/postgresql/9.0/main/pg_hba.conf /var/lib/postgresql/9.0/main/ > > ln -s /etc/postgresql/9.0/main/postgresql.conf /var/lib/postgresql/9.0/main/ > > > > Then edit /etc/postgresql/9.0/main/postgresql.conf and change: > > > > hba_file = '/etc/postgresql/9.0/main/pg_hba.conf' > > > > To: > > > > hba_file = '/var/lib/postgresql/9.0/main/pg_hba.conf' > > Why is this necessary? What is the actual error message that you get?
The error that pgadmin elicits is something saying: ERROR: absolute path not allowed > Can't you specify /etc/postgresql/9.0/main/ as the cluster directory, No... if you read the the postgresql forums, you will see that writing to files -outside- the '/var/lib/postgresql/9.0/main/' directory is prohibited by policy. This means that postgres would have to be compiled without this policy restriction. (I find this policy strange since you can link to a file outside the aforementioned directory.) Read the following thread: http://archives.postgresql.org/pgadmin-support/2009-10/msg00000.php I did find the actual c code that is responsible for this policy, but at this point I can't find it again. (Sorry for the late response... I inadvertently deleted this mail and only noticed your response on the bugs web site today.) -- john -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
