I need to access a postgresql database from a remote machine on a VPS at DigitalOcean running 12.10 and postgresql 9.1.
How do I do this? I noticed port 5432 is closed, how do I open this?
To open the port 5432 edit your
and reload or restart you DBMS
now you can connect with
if you are unable to authentify yourself, then you need to give your user access rights to your database
hereafter you need also a reload
I don't need to mention that this is a basic configuration, now you should think about modify your firewall and improve the security of your DBMS.
For the message "server not listening", that happen to me was, that i don't erase of # on the archive postgresql.conf i mean:
(Sorry for my english).