postgresql installation

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


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.

So... nothing really works. pgAccess doesn't work. and perl DBI doesn't work.

it's got to be simple. But I don't know what it is and I'm reluctant to start tearing up all the configuration files thinking I actually know what I'm doing.

help?


--
To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx

Relevant Pages

  • Re: postgresql installation
    ... there's no way I seem able to make a localhost tcp_ip connection. ... I'm not certain about this 'md5' thing. ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: Modem logs on, but cant be used
    ... Sep 26 20:45:53 localhost network: Setting network parameters: succeeded ... Sep 26 20:48:00 localhost pppd: Serial connection established. ... alias usb-controller1 ehci-hcd ... # Example - obey only what nisplus tells us... ...
    (linux.redhat.misc)
  • Re: Local http proxy
    ... network connection and type 'ipconfig' in your command prompt. ... starts TCP/IP stack and you're able to ping localhost. ... > with the pocket internet explorer. ...
    (microsoft.public.pocketpc.developer.networking)
  • Re: [SLE] Sieve: unable to connect at line 169
    ... > Connected to localhost. ... > Connection closed by foreign host. ... as well as for imap? ... > If you have a system user with a mailbox in Cyrus, ...
    (SuSE)
  • Re: ssh tunnel problems
    ... Connecting to localhost port 5000. ... debug1: connect to address 127.0.0.1 port 5000: Connection refused ... password and I connect and see files on my home computer (from being ...
    (Fedora)