Contents
To use the PostgreSQL Yum Repository, follow these steps:
- Select version:
- Select platform:
- Select architecture:
- Install the repository RPM: Select version and platform above.
- Install the client packages: Select version and platform above.
- Optionally install the server packages: Select version and platform above.
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*
