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 [email protected] -----Original Message----- From: [email protected] on behalf of Tena Sakai Sent: Sun 2/22/2009 12:45 AM To: [email protected] 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 [email protected]
