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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
