pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem 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