Hi Everybody,
I found a solution for my problem.
What I did was to edit the pg_hba.conf and replaced
'md5' for user postgres with 'trust' which lets me
execute:
/usr/local/pgsql/bin/psql -d <dbname> -f saved_file
It ran fine and then I put 'md5' back in place of
'trust.' Now all seems fine. I will spend a bit more
time verifying that all tables are intact, but so far
I have a good feelings.
Many thanks.
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
-----Original Message-----
From: pgsql-admin-owner@postgresql.org on behalf of Tena Sakai
Sent: Sat 2/23/2008 6:57 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] 8.3.0 postinstallation trouble
Hi Everybody,
I have gotten my postgres upgraded to 8.3.0 (from 8.2.4)
or almost. I followed the steps in the manual, section
15.4.
I was able to start 8.3.0 by:
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
via step 7. Now I am ready to restore from the saved file
and typed:
/usr/local/pgsql/bin/psql -d <dbname> -f saved_file
and it asks me a password. I have been doing this all as
user postgres and that password is rejected:
password authentication failed for user "postgres"
The pg_hba.conf, as well as postgresql.conf, is restored
from 8.2.4.
Can somebody please tell me what's going on and how to go
about getting out of the trouble I am in?
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu