Install Postgresql 12.8 on RHEL 7:
Download following rpm packages from - https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/
postgresql12-libs-12.8-1PGDG.rhel7.x86_64.rpm
postgresql12-12.8-1PGDG.rhel7.x86_64.rpm
postgresql12-server-12.8-1PGDG.rhel7.x86_64.rpm
postgresql12-contrib-12.8-1PGDG.rhel7.x86_64
Install rpm packages for Postgresql:
# yum install postgresql12-libs-12.8-1PGDG.rhel7.x86_64.rpm
# yum install postgresql12-12.8-1PGDG.rhel7.x86_64.rpm
# yum install postgresql12-server-12.8-1PGDG.rhel7.x86_64.rpm
# yum install postgresql12-contrib-12.8-1PGDG.rhel7.x86_64
It will install following utilities at /usr/pg-sql12/bin
clusterdb dropuser pg_basebackup pg_controldata pg_isready pg_restore pg_test_timing postgresql-12-check-db-dir reindexdb createdb initdb pgbench pg_ctl pg_receivewal pg_rewind pg_upgrade postgresql-12-setup vacuumdb
createuser oid2name pg_checksums pg_dump pg_recvlogical pg_standby pg_waldump postmaster vacuumlo dropdb pg_archivecleanup pg_config pg_dumpall pg_resetwal pg_test_fsync postgres psql
Initialize postgresql:
# postgresql-12-setup initdb
Initializing database ... OK
Enable postgresql:
# systemctl enable postgresql-12.service
# Start Postgresql service:
systemctl start postgresql-12.service
Set password for user postgres:
$ sudo su - postgres
$ psql
postgres=# alter user postgres with password 'postgres';
ALTER ROLE
Connect using psql:
$ psql
psql (12.8)
Type "help" for help.
Processes for Postgresql:
# ps -ef | grep postgres
postgres 12161 1 0 13:04 ? 00:00:00 /usr/pgsql-12/bin/postmaster -D /mysql/postgresql/
postgres 12163 12161 0 13:04 ? 00:00:00 postgres: logger
postgres 12165 12161 0 13:04 ? 00:00:00 postgres: checkpointer
postgres 12166 12161 0 13:04 ? 00:00:00 postgres: background writer
postgres 12167 12161 0 13:04 ? 00:00:00 postgres: walwriter
postgres 12168 12161 0 13:04 ? 00:00:00 postgres: autovacuum launcher
postgres 12169 12161 0 13:04 ? 00:00:00 postgres: stats collector
postgres 12170 12161 0 13:04 ? 00:00:00 postgres: logical replication launcher
postgres 12404 12403 0 13:06 pts/0 00:00:00 -bash
postgres 12435 12404 0 13:06 pts/0 00:00:00 psql
postgres 12436 12161 0 13:06 ? 00:00:00 postgres: postgres postgres [local] idle
postgres 13104 12161 0 13:11 ? 00:00:03 postgres: postgres postgres 10.225.109.174(55594) idle
postgres 13106 12161 0 13:11 ? 00:00:04 postgres: postgres test 10.225.109.174(62426) idle
Explore:
https://www.postgresql.org/docs/12/creating-cluster.html
https://blog.crunchydata.com/blog/postgresql-installing-and-creating-cluster-with-rpm-packages
https://sysadminxpert.com/install-postgresql-12-on-centos-7-or-rhel-7/
Comments
Post a Comment