0
Config snippets : PostgreSQL : Listening on all IP addresses
After installation PostgreSQL is listening on localhost only. To change that adjustment has to be done in postgresql.conf.
1
Code snippets : PostgreSQL : Add new superuser after PostgreSQL installation
After I instaled PostgreSQL on Amazon Linux AMI, first thing after database server was up and running I start thinking how to create user with administrative privileges, so I can access it using some management applications.
So, here is how to create superuser and set password, which will allow to access PostgreSQL using admin tools.