Postgres Pro
Downloads
Home   >   mailing lists

Thread: Default user after upgrade to 7.3?

Default user after upgrade to 7.3?

From
Steve Wampler
Date:
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?

Re: Default user after upgrade to 7.3?

From
Steve Wampler
Date:
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.conf
>
> That 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?

Re: Default user after upgrade to 7.3?

From
Peter Eisentraut
Date:
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

Re: Default user after upgrade to 7.3?

From
Date:
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


> -----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
>