Re: 8.3.0 postinstallation trouble

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(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org on behalf of Tena Sakai
Sent: Sat 2/23/2008 6:57 PM
To: pgsql-admin(at)postgresql(dot)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(at)gallo(dot)ucsf(dot)edu