pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Broersma Jr <rabroersma@yahoo.com>
To: lmyho <lm_yho@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
Date: Tue, 28 Mar 2006 05:00:52 -0800 (PST)
Message-ID: <20060328130052.81125.qmail@web31801.mail.mud.yahoo.com> (raw)
In-Reply-To: <20060328070807.65298.qmail@web30812.mail.mud.yahoo.com>

 Please can anyone help me here?  I've been so frustrated.:(  If there is auto-created password
> for this auto-created postgres user, please anyone tell me what it is??  And also otherwise, how
> can I log-in using the "ident auth" method??

If you just getting started with postgresql you will want to change the user postgres ident to
"trust".

Then you should be able to log into postgresql using "psql -U postgres -d template1"

There you can change the postgres db-user password with

alter user postgres password 'password';

once completed then log out using "\q"

Now if you wanted to change you ident method back to md5 you will be able to use you new password.

This should work, but you would probably be better server by following the directions in the
postgresql documentation.

Regards,

Richard Broersma Jr.



view thread (8+ messages)  latest in thread

Message-ID: <20060328130052.81125.qmail@web31801.mail.mud.yahoo.com>
Permalink:  ../20060328130052.81125.qmail@web31801.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/20060328130052.81125.qmail@web31801.mail.mud.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: rabroersma@yahoo.com, lm_yho@yahoo.com
  Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
  In-Reply-To: <20060328130052.81125.qmail@web31801.mail.mud.yahoo.com>
  References: <20060328070807.65298.qmail@web30812.mail.mud.yahoo.com> <20060328130052.81125.qmail@web31801.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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