Contents
For YUM installations (Fedora / Red Hat / CentOS / Scientific Linux)
- Head over to PostgreSQL Yum Repository.
- Select the version of PostgreSQL that you want to install and then your OS, version and architecture.
- Install the RPM.
- Do a quick search which will show you available packages for postgres.
How do I start PostgreSQL on Ubuntu?
Installing PostgreSQL using APT
- Log into your server via SSH.
- Access root by running the following command: sudo su –
- To install PostgreSQL, as well as the necessary server software, run the following command:
- Configure PostgreSQL to start up upon server boot.
- Start PostgreSQL.
How do I log into PostgreSQL on Linux?
To connect to PostgreSQL from the command line:
- Log in to your A2 Hosting account using SSH.
- At the command line, type the following command.
- At the Password prompt, type the database user’s password.
- After you access a PostgreSQL database, you can run SQL queries and more.