Re: Default user after upgrade to 7.3?

From: <terry(at)greatgulfhomes(dot)com>
To: <swampler(at)noao(dot)edu>, "'Postgres-General'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Default user after upgrade to 7.3?
Date: 2003-11-06 17:59:19
Message-ID: 003201c3a48f$b38c49a0$2766f30a@development.greatgulfhomes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)greatgulfhomes(dot)com
Fax: (416) 441-9085

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)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(at)noao(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wampler 2003-11-06 18:08:31 Re: Default user after upgrade to 7.3?
Previous Message Carlos 2003-11-06 17:52:58 Install files for version 7.4