Users can be created either by using the command createuser or one the SQL statements CREATE ROLE or CREATE USER. The createuser command, which is a wrapper to the SQL Command CREATE ROLE, has the added advantage of providing for the interactive creation users by answering a series of questions. To run createuser interactively you…
Category: Postgresql
Configure Postgres to accept remote connections
The default postgres configuration will only accept local connections to the database. If you are, for example, using psql and trying to connect to a remote server called remote-server you may receive a response like: Running netstat on the server sheds light on the problem: the postgresql server is bound to address 127.0.0.1 This behavior…