Hi,
I am able to revert back to 8.3.3 system. Maybe
I can use 8.3.3 psql to read the dumpall output.
How can I direct the output to data directory of
8.3.6 postgres?
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
-----Original Message-----
From: Tena Sakai
Sent: Sun 2/22/2009 1:03 AM
To: Tena Sakai; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] 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@gallo.ucsf.edu
-----Original Message-----
From: pgsql-admin-owner@postgresql.org on behalf of Tena Sakai
Sent: Sun 2/22/2009 12:45 AM
To: pgsql-admin@postgresql.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@gallo.ucsf.edu