If I run the admin tool from my postgres account, that works fine since postgres is the owner.
> Cc: pgsql-general@postgresql.org > Subject: Re: Fwd: [GENERAL] Restore problem from 8.4 backup to 9.0 > >> Thanks for the fast reply. I must have still been connected to the older >> database somehow. I cleaned up my installation and restored the database. >> No error messages this time. I need to change the pg_hba.conf file. I read >> the documentation and its supposed to be in the data directory (which is >> locked), but it doesn't seem to be there. Is there an easy way to create >> the file in the data directory (without overriding access privileges) at >> this point? > > That's where it would normally be, but try "show hba_file;" if you think > the packager of your distribution put it somewhere else. > > regards, tom lane > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general