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 old
Where would I type 'show hba_file'? I'm on Mac. Also I downloaded the
distribution from postgresql.org. If I run an initdb and I already restored a
database, will it put the pg_hba.conf file in the 'data' folder?
> Subject: Re: Fwd: [GENERAL] Restore pr
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. I read
> the documentation and its supposed to be
Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Restore problem from 8.4 backup to 9.0
>
> Adam Wizon writes:
>> 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
Adam Wizon writes:
> 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 afte
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