From: | "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6 |
Date: | 2009-02-22 08:45:40 |
Message-ID: | FE44E0D7EAD2ED4BB2165071DB8E328C0378F77E@egcrc-ex01.egcrc.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tena Sakai | 2009-02-22 09:03:02 | Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6 |
Previous Message | Scott Marlowe | 2009-02-22 02:43:11 | Re: 8.3.5 broken after power fail SOLVED |