After installation PostgreSQL is listening on localhost only. To change that adjustment has to be done in postgresql.conf.
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.
Recently I decided to use Amazon AWS EC2 platform to host systems in the Cloud. As operating system I needed is Linux I quickly deployed Amazon Linux AMI, which is quick and simple to do.
Once instance was created I downloaded key pair. Now it came down to connecting to my virtual machine in the cloud.My SSH client of choice is SecureCRT. Let’s see how to configure session parameters in SecureCRT in order to connect to Amazon Linux AMI instance hosted on EC2 platform.
I’m using SecureCRT 7.0.1 to connect to server hosted on Amazon EC2 platform.