Re: I need to know password for postgres

Oliver,
              There are no uncommented entries in  pg_hba.conf.  Surely
I need to uncomment some of these?

I have managed to give postgres a password but I can't access database.

To be honest I screwed up and have reinstalled my Redhat partition so
I'm back to square one ie. the postgresql and gphotocoll RPMs installed.

Thanks for taking the trouble.

Dave


Oliver Elphick wrote:

>On Tue, 2002-08-13 at 21:31, Chad Thompson wrote:
>
>>from a prompt type
>>"passwd postgres" (no quotes)
>>
>>this will prompt you to change the password for postgres
>>
>...
>
>>>The setup insructions are
>>>
>>>1. login as postgres - which I can only do by su  and then su postgres.
>>>2. createdb - no problem
>>>3. launch gphotocoll as postgres.  I have to supply the password for
>>>postgres and I don't know it.
>>>
>
>No he doesn't need to change the Unix password for postgres; he had
>already got access to that by using su.
>
>If you really need a database password, do this:
>
>    To get access to the database, edit pg_hba.conf, which is stored in
>    the top-level data directory.  I don't know where its default
>    location is on Red Hat.
>
>    There should be a lot of explanatory comment in that file.  That
>    should help you understand what it does.  Presumably the first line
>    that matches the way gphotocoll is trying to access it is a line
>    that specifies password or crypt.
>
>    To set the database password for postgres, add this line at the top
>    of pg_hba.conf:
>
>      local all trust
>
>    Connect to PostgreSQL with psql from the postgres Unix account:
>
>      psql -d template1
>
>    Change the postgres password:
>
>      ALTER USER postgres WITH PASSWORD 'this_is_my_password';
>
>    Type Ctrl-D or \q to come out of psql
>
>    Edit pg_hba.conf again and remove the trust line.
>
>But I'm not sure you do need a password with the set up you described;
>you said that createdb worked and you did not have to supply a password.
>If you had universal password access control, createdb would have asked
>you for a password.
>
>Perhaps you should post the contents of your pg_hba.conf (without the
>comments!).  It may be that you need to do something to allow a Unix
>user who is not "postgres" to access the database as "postgres".  I
>would also want to know why gphotocoll has to be user "postgres", since
>this gives it administration rights over the whole database
>installation.
>