Hi Peter, Thanks for your reply and idea. I was up way past my bed time and my mind was not with my finger tips. As I followed suggestions from Scott, I was able to get it to work fast. More often than not, I push the door, when it is written on the door: "PULL" :)
Regards, Tena Sakai -----Original Message----- From: Jan-Peter Seifert [mailto:[email protected]] Sent: Sun 2/22/2009 10:23 AM To: Tena Sakai Cc: [email protected] Subject: Re: [ADMIN] trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6 Hello, Tena Sakai wrote: > 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 If you haven't installed the PostgreSQL server as a service, then you have to manually shut down (pg_ctl etc.) the server before shutting down the system of course. > 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? Try setting the authentification method for local (127.0.0.1) to trust in the pg_hba.conf file (it's in the cluster directory together with postgresql.conf. Then set a new password for postgres via SQL, pgAdmin III etc. ... After that don't forget to set the authentification method back to the old setting. Good luck, Peter
