Re: postgresql installation

[Oliver Elphick <olly@lfix.co.uk>]

On Tue, 2006-02-14 at 18:17 -0500, Tom Allison wrote:
> OK, I'm just getting stuck on something regarding getting this postgresql 
> started up.
> 
> For starters, there's no way I seem able to make a localhost tcp_ip connection.
> 
> postgresql.conf
> tcpip_socket = true
> port = 5432
> 
> pg_hba.conf
> local   all         postgres                          ident sameuser
> local   all         all                                             ident sameuser
> host    all         all         127.0.0.1         255.255.255.255   md5
> host    all         all         ::1 
> ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        md5

Did you reload the postmaster after changing this?

  su -c "/etc/init.d/postgresql reload"

> 
> I went into the template1 database and set my password for my username so that I 
> could make connections from localhost.  I'm not certain about this 'md5' thing. 
>   I set the password to match "foo" and not the md5_hex version of "foo".  I'm 
> assuming that this is not a problem...  But maybe it's a bad assumption.

md5 means that the password is compared in md5 format.  To set the
password, connect to template1 as postgres using a local connection (do
not specify any host) and:

 ALTER USER username WITH PASSWORD 'newpassword';

now you should be able to connect using that password:

  psql -d template1 -h localhost -U username


-- 
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
   Do you want to know God?   http://www.lfix.co.uk/knowing_god.html