Sunday, July 02, 2006

Postgres 7.4

Another small fix for the installation of Postgres 7.4 on Ubuntu Dapper.

After installation and setting up users and a default database, psql got me into the terminal, but I couldn't connect from PgAdminIII.

I tried to connect to the localhost with:
psql -h localhost
This failed, because as default, the TCP/IP socket is set to false. The simple fix is to edit the config file and ensure that the port is set to 5432 and the tcpip_socket is set to true.
sudo pico /etc/postgresql/7.4/main/postgresql.conf
port = 5432
tcpip_socket = true

No comments: