Configuring postgresql in debian

After the installation from the debian packages, you should run :

sudo pg_createcluster 8.3 main

To make the server listen to the network edit /etc/postgresql/8.3/main/postgresql.conf and modify it to read :

listen_addresses = '*' # what IP address(es) to listen on;

and edit /etc/postgresql/8.3/main/pg_hba.conf and add a line for each user you would like to authorize the user called "myuser" who is located on network 201.171.245.62/32 for using the database "mydb" :

host mydb my user 201.171.245.62/32 md5

and then grant privileges to that user on the table geometry_columns :

psql mydb
GRANT select, insert, update, delete ON TABLE public.geometry_columns TO myuser;