Default user after upgrade to 7.3?
I just upgraded a system from RedHat 8.0 to RedHat 9.0,
which also upgrades the version of PostgreSQL.
However, I cannot run pgsql to restore the databases
because I don't know a 'default' user with permission
to run pgsql:
postmaster successfully started
LOG: database system was shut down at 2003-11-06 10:27:18 MST
LOG: checkpoint record is at 0/80193C
LOG: redo record is at 0/80193C; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 480; next oid: 16976
LOG: database system is ready
FATAL: IDENT authentication failed for user "root"
FATAL: IDENT authentication failed for user "postgres"
FATAL: IDENT authentication failed for user "swampler"
Am I missing something obvious? I couldn't find any
mention of needing to add a default user (I thought user
postgres was the default...) in the installation docs.
(And how do I do so, given that I can't run createuser
as anyone...?)
Thanks!
-Steev
--
Steve Wampler -- swampler@noao.edu
Quantum materiae materietur marmota monax si marmota
monax materiam possit materiari?
I think you should look at your pg_hba.com file:
/var/lib/pgsql/pg_hba.conf
That is the file of "what users can logon from where and how"
Perhaps it got clobbered or something.
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
terry@greatgulfhomes.com
Fax: (416) 441-9085
Show quoted text
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Steve Wampler
Sent: Thursday, November 06, 2003 12:41 PM
To: Postgres-General
Subject: [GENERAL] Default user after upgrade to 7.3?I just upgraded a system from RedHat 8.0 to RedHat 9.0,
which also upgrades the version of PostgreSQL.However, I cannot run pgsql to restore the databases
because I don't know a 'default' user with permission
to run pgsql:postmaster successfully started
LOG: database system was shut down at 2003-11-06 10:27:18 MST
LOG: checkpoint record is at 0/80193C
LOG: redo record is at 0/80193C; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 480; next oid: 16976
LOG: database system is ready
FATAL: IDENT authentication failed for user "root"
FATAL: IDENT authentication failed for user "postgres"
FATAL: IDENT authentication failed for user "swampler"Am I missing something obvious? I couldn't find any
mention of needing to add a default user (I thought user
postgres was the default...) in the installation docs.
(And how do I do so, given that I can't run createuser
as anyone...?)Thanks!
-Steev
--
Steve Wampler -- swampler@noao.edu
Quantum materiae materietur marmota monax si marmota
monax materiam possit materiari?---------------------------(end of
broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index
scan if your
joining column's datatypes do not match
On Thu, 2003-11-06 at 10:59, terry@greatgulfhomes.com wrote:
I think you should look at your pg_hba.com file:
/var/lib/pgsql/pg_hba.confThat is the file of "what users can logon from where and how"
Perhaps it got clobbered or something.
Thanks! I had rebuilt it from the old one, which didn't
use 'ident' authority. It's working now.
Thanks again!!
--
Steve Wampler -- swampler@noao.edu
Quantum materiae materietur marmota monax si marmota
monax materiam possit materiari?
Steve Wampler writes:
FATAL: IDENT authentication failed for user "root"
FATAL: IDENT authentication failed for user "postgres"
FATAL: IDENT authentication failed for user "swampler"
Check the file pg_hba.conf (somewhere under /var/lib/pgsql probably) to
see what kind of authentication it requires from you. If you don't know
how to work with the authentication that has been set up by the package,
change everything that reads "ident" to "trust" and restart the database
server. That is not safe, but it will allow you to get in.
--
Peter Eisentraut peter_e@gmx.net