Postgres Pro
Downloads
Home   >   mailing lists

Re: PostGreSQL - Accessing It - Mailing list pgsql-general

From Mel Roman
Subject Re: PostGreSQL - Accessing It
Date
Msg-id cAg_a.131239$4UE.68389@news01.bloor.is.net.cable.rogers.com
Whole thread Raw
In response to PostGreSQL - Accessing It  ("Michael" <michael@transmissionsllc.com>)
Responses Re: PostGreSQL - Accessing It  (Thomas Beutin <tyrone@laokoon.IN-Berlin.DE>)
Re: PostGreSQL - Accessing It  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
In article <3F397B8E.8080307@commandprompt.com>, "Joshua D. Drake" wrote:
> Michael wrote:
>
>> I cannot access/create a database from root or any of the other
>> accounts I have setup for RH9. I noticed that there is a user setup
>> for postgres (I guess this part of the postgres install) but can’t
>> login as that user. I can’t even read or change the password. How do I
>> get at PostGreSql?
>>
> You need to be the user postgres. Try psql -U postgres template1 . You
> may also have to initdb the database.
>

I have the same problem as Michael.  I've installed postgresql and am
running the service, but I can't log in as postgres.  I just tried the
command line "psql -U postgres template1", but I get the message
"authentication failed for user 'postgres'".  The administrator's manual
confirms that I first need to connect as this predefined user, but
doesn't say what that user's password is.

How can I find out the password for user postgres so that I can finally
begin working with this database?

TIA,

--

Mel Roman
mel@melroman.net

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Commercial support?
Next
From: "Envex Developments"
Date:
Subject: Installing DBD::Pg Perl module locally.