by skufel | Sep 24, 2012 | Databases
After installation PostgreSQL is listening on localhost only. To change that adjustment has to be done in postgresql.conf. Default location of configuration file /var/lib/pgsql9/data/postgresql.conf. Following line has to be added: listen_addresses = '*' After that...
by skufel | Sep 24, 2012 | Databases
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...
