On Thu, 16 Jan 2003 13:47, David Stephen wrote: > I have installed Postgres from source on a server running Debian 2.2.20. > > It works fine, I can use psql and have created a database and couple of > tables. BUT I can't get access from a remote machine. > > telnet svr 5432 produces: > telnet: Unable to connect to remote host: Connection refused > > (I haven't fiddled with the default port) > > Where as I get a connection to MySQL on port 3306 > > The /etc/services file includes the lines: > postgres 5432/tcp # POSTGRES > postgres 5432/udp # POSTGRES > > I can't find any refeneces to failed attempts to connect (using either > pgAdmin II or telnet) in the postgres log file or any other log file for > that matter. > > Can anyone suggest a cure?
postgresql can be started using either a unix filesystem socket or a TCP/IP one. You have to start it with the TCP/IP support if you want to connect over the net. pg_ctl -o -i -D/var/lib/pgsql/data/base start -- Sincerely etc., Christopher Sawtell
