From: | Jari Vauhkonen <jari(dot)vauhkonen(at)joensuu(dot)fi> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | TCP/IP connection problem |
Date: | 2006-10-26 13:02:01 |
Message-ID: | 1161867721.4540b1c933417@wwwmail.joensuu.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
I have tried to set up a PostgreSQL server with no success. Connections from
other-than-local hosts won't work. I've tried to connect from Windows XP using
PgWorkSheet && pgAccess.
I have studied the internet for similar problems without an answer. the
following has been done:
-- PSQL & PSQL-server installation
-- configuring the pg_hba.conf with following lines:
host all 127.0.0.1 255.255.255.255 trust
host all <my_ip> 255.255.255.255 trustlocal all trust
host koli <my_ip> 255.255.255.255 trust
-- configuring the postgresql.conf wit following lines:
#listen_addresses = '*'
#port = 5432
#tcpip_socket = true
-- starting the postmaster with command
/usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data &
-- installing the PSQL ODBC driver for Windows
I wonder if the problem is related to the operating system's TCP/IP settings? I
tried netstat to find out if the port 5432 is used, but it seems that it isn't.
What should I do? Remember, I'm quite a newbie with linux-style operating
systems so keep it simple.
Thanks already,
Jari
From | Date | Subject | |
---|---|---|---|
Next Message | Ben Suffolk | 2006-10-26 13:06:44 | Re: TCP/IP connection problem |
Previous Message | Andrew Sullivan | 2006-10-26 11:03:09 | Re: Vacuum Problems (locking) |