Contents
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 Ubuntu?
Change default PostgreSQL passwords
- Connect as ubuntu to the instance where PostgreSQL is installed.
- Switch to the root user.
- Log in to psql using the postgres database login role, connecting to the postgres database.
- Issue the \password command to alter the passwords of the three login roles.
- To exit psql, type \q.
How install PostgreSQL Linux?
For 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. rpm -ivh pgdg-centos92-9.2-6.noarch.rpm.
- Do a quick search which will show you available packages for postgres. yum list postgres*
