Skip site navigation (1) Skip section navigation (2)

8.3.0 postinstallation trouble

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: 8.3.0 postinstallation trouble
Date: 2008-02-24 02:57:01
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C0378F0AF@egcrc-ex01.egcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Everybody,

I have gotten my postgres upgraded to 8.3.0 (from 8.2.4)
or almost.  I followed the steps in the manual, section
15.4.

I was able to start 8.3.0 by:

  /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data

via step 7.  Now I am ready to restore from the saved file
and typed:

  /usr/local/pgsql/bin/psql -d <dbname> -f saved_file

and it asks me a password.  I have been doing this all as
user postgres and that password is rejected:
  password authentication failed for user "postgres"

The pg_hba.conf, as well as postgresql.conf, is restored
from 8.2.4.

Can somebody please tell me what's going on and how to go
about getting out of the trouble I am in?

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

Responses

pgsql-admin by date

Next:From: Peter KoczanDate: 2008-02-24 03:17:08
Subject: Re: PL/pgSQL memory consumption?
Previous:From: rose .....Date: 2008-02-23 18:22:10
Subject: postsql on vista

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group