Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 31B84634DF9 for ; Sun, 22 Feb 2009 14:24:00 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 33634-02 for ; Sun, 22 Feb 2009 14:23:54 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id 5287263590A for ; Sun, 22 Feb 2009 14:23:48 -0400 (AST) Received: (qmail invoked by alias); 22 Feb 2009 18:23:45 -0000 Received: from dslc-082-082-161-170.pools.arcor-ip.net (EHLO [192.168.123.148]) [82.82.161.170] by mail.gmx.net (mp031) with SMTP; 22 Feb 2009 19:23:45 +0100 X-Authenticated: #955937 X-Provags-ID: V01U2FsdGVkX1/1ySZRhL71MbjJ4ZgWKHVMsvqRdKTNyWGAWYtgiW KIiulDKzj5mjQU Message-ID: <49A1982E.2070602@gmx.de> Date: Sun, 22 Feb 2009 19:23:42 +0100 From: Jan-Peter Seifert User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Tena Sakai CC: pgsql-admin@postgresql.org Subject: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6 References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-FuHaFi: 0.57 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/186 X-Sequence-Number: 31407 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