Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6

Hi,

I realized what's going, but still don't know what to do.
What's happening is that there is no pg_user table in my
new postgres, which is the problem I was going to attack
via psql. So this seems like a catch 22.

What can I do?

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: Sun 2/22/2009 12:45 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6

Hi everybody,

I just finished installing postgres 8.3.6 and was
able to start it. The log file reads:

[2009-02-22 00:27:01.824 PST] < 11543 2009-02-22 00:27:01 PST >LOG: database system was interrupted; last known up at 2009-02-22 00:25:04 PST
[2009-02-22 00:27:01.825 PST] < 11543 2009-02-22 00:27:01 PST >LOG: database system was not properly shut down; automatic recovery in progress
[2009-02-22 00:27:01.827 PST] < 11543 2009-02-22 00:27:01 PST >LOG: record with zero length at 13D/F78D2378
[2009-02-22 00:27:01.827 PST] < 11543 2009-02-22 00:27:01 PST >LOG: redo is not required
[2009-02-22 00:27:01.880 PST] < 11546 2009-02-22 00:27:01 PST >LOG: autovacuum launcher started
[2009-02-22 00:27:01.881 PST] < 11542 2009-02-22 00:27:01 PST >LOG: database system is ready to accept connections

While in postgres's home directory, I issued a command:
./bin/psql -f PastLogs/dumpall.out postgres
which is almost verbatim from the man page. When I had
.pgpass file, it told me:
psql: FATAL: password authentication failed for user "postgres"
When I got rid of it, it asked me for one. Whatever I gave was
no avail. The password it is asking is not login password?

Can somebody please help?

Thank you.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu