From: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6
Date: Sun, 22 Feb 2009 19:23:42 +0100
Message-ID: <49A1982E.2070602@gmx.de> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C0378F77F@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C0378F77E@egcrc-ex01.egcrc.org>
<FE44E0D7EAD2ED4BB2165071DB8E328C0378F77F@egcrc-ex01.egcrc.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Jan-Peter.Seifert@gmx.de, tsakai@gallo.ucsf.edu
Subject: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6
In-Reply-To: <49A1982E.2070602@gmx.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox