i have a fresh install of debian, i chose to install postgresql and mysql during setup (but i later removed mysql anyway). now, postgres is running, 'ps' gives me 3 'postmaster' processess running, but it doesnt seem to open any port on which it would listen for connections. nmap localhost does NOT show the default postgres port open, i tried to set up amarok to use postgres but i got an error stating that the connection to localhost 5432 was refused.

edit: note that i can edit the tables localy, from my own box, via psql

any pointers? :S

Starting with the README.Debian file for the program you're
using is always a good idea; but I'll shortcut this for you.

Postgres in Debian by default only listens to Linux-sockets
and isn't network enabled. Find and modify your postgresql.conf
(hint: /etc/postgres) to listen to all relevant network
addresses. Also check pg_hba.conf to make sure that the application
can connect from localhost to the appropriate database.



Cheers,
Tink

P.S.: Congratulations on the removal of MySQL ;}