pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problem with PostgreSQL 8.1.4 Install (using RPMs)
3+ messages / 3 participants
[nested] [flat]

* Problem with PostgreSQL 8.1.4 Install (using RPMs)
@ 2006-08-25 18:26  Lane Van Ingen <lvaningen@esncc.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Lane Van Ingen @ 2006-08-25 18:26 UTC (permalink / raw)
  To: pgsql-admin

The basic install of Red Hat (RHEL ES 4.0) for PostgreSQL version 8.1.4
appears to have gone well (database is up and running) except for one thing:
I can't login as postgres.

Assume the login would be 'postgres' or 'postgresql', but can't get in via
psql or pgAdmin3 to set up new users and database. I have looked through the
documentation, but don't see anywhere that tells what password I must use to
get in as the DBA.

Does anyone know what the initial user/password should be? Thanks.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Problem with PostgreSQL 8.1.4 Install (using RPMs)
@ 2006-08-25 18:27  Peter Eisentraut <peter_e@gmx.net>
  parent: Lane Van Ingen <lvaningen@esncc.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Eisentraut @ 2006-08-25 18:27 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Lane Van Ingen <lvaningen@esncc.com>

Lane Van Ingen wrote:
> Does anyone know what the initial user/password should be? Thanks.

Probably postgres without a password but with ident authentication, 
which means you must log in as the postgres user on your OS.  (That one 
probably doesn't have a password either, so go through root.)

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Problem with PostgreSQL 8.1.4 Install (using RPMs)
@ 2006-08-25 18:34  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2006-08-25 18:34 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin@postgresql.org, "Lane Van Ingen" <lvaningen@esncc.com>

Peter Eisentraut <peter_e@gmx.net> writes:
> Lane Van Ingen wrote:
>> Does anyone know what the initial user/password should be? Thanks.

> Probably postgres without a password but with ident authentication, 
> which means you must log in as the postgres user on your OS.  (That one 
> probably doesn't have a password either, so go through root.)

ie, something like

	sudo su - postgres -c "psql"

Since the default is ident auth, even if you'd assigned a password it
would be irrelevant to whether you could get into the database or not.
If you want to use passwords to control that, you'll need to edit
pg_hba.conf.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-08-25 18:34 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-25 18:26 Problem with PostgreSQL 8.1.4 Install (using RPMs) Lane Van Ingen <lvaningen@esncc.com>
2006-08-25 18:27 ` Peter Eisentraut <peter_e@gmx.net>
2006-08-25 18:34   ` Tom Lane <tgl@sss.pgh.pa.us>

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