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 som
oblem from 8.4 backup to 9.0
>
> Adam Wizon writes:
>> 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.
(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?
Begin forwarded message:
> From: Tom Lane
> Date: September 28, 2010 9:58:10 PM EDT
> To: Adam Wizon
>
I installed v9.0 on my Mac Pro. Dumped the 8.4 database using 'pg_dump -Fc -d
dbname --username=xyz > backup_file_name' using the pg_dump from the 8.4
installation. I restored the database using 'pg_restore -d dbname
backup_file_name' using the 9.0 restore and after creating a new database
u
