It's pronounced Diane. I do data architecture, operations, and backend development. In my spare time I maintain Massive.js, a data mapper for Node.js and PostgreSQL.
Postgres' authentication settings are stored in $datadir/pg_hba.conf. To allow access over the network, you'll need to add an entry with host type, an IP mask that includes the computer you're connecting from, and a suitable authentication method (the current standard is scram-sha-256). After changing pg_hba.conf issue select pg_reload_conf(); in psql or pg_ctl reload from the shell to get the server to read the new configuration.
It's pronounced Diane. I do data architecture, operations, and backend development. In my spare time I maintain Massive.js, a data mapper for Node.js and PostgreSQL.
Postgres' authentication settings are stored in $datadir/pg_hba.conf. To allow access over the network, you'll need to add an entry with
host
type, an IP mask that includes the computer you're connecting from, and a suitable authentication method (the current standard isscram-sha-256
). After changingpg_hba.conf
issueselect pg_reload_conf();
in psql orpg_ctl reload
from the shell to get the server to read the new configuration.Oh, and make sure port 5432 (by default) is open.
Ok thanks. Am I correct in that all I need is Postgres running on my virtual server with Ubuntu, or am I also needing something like Apache?
Just Postgres. Database servers (like Postgres) and web servers (like Apache) both handle comms their own way.