pgtune | installation and usage

pgtune helps expands the database server to be as powerful as the hardware it's being deployed on , by taking an existing postgresql.conf file as an input, making changes to it based on the amount of RAM in your server and suggested workload, and output a new file.

pg_basebackup: could not connect to server: FATAL: number of requested standby connections exceeds

-bash-4.1$ pg_basebackup -h oracleasm1.localdomain -D /u01/PG_Adventure
pg_basebackup: could not connect to server: FATAL:  number of requested standby connections exceeds … 

pg_basebackup : could not connect to server: FATAL: no pg_hba.conf entry for replication connection

pg_basebackup: could not connect to server: FATAL:  no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL off

Postgres Drop table : ERROR: must be owner of relation table_name

In Postgres, The right to drop an object is not treated with any grantable privilege. It is only achived by the ownership. How .. ?

Creating a database on Postgresql server

1.    Login to PostgreSQL server

[oracle@oracleasm1 ~]$ su - postgres
Password:
-bash-4.1$
 
-bash-4.1$ psql
psql (8.4.18, server 9.6.15)
WARNING: psql version 8.4, server version 9.6.
         Some psql features might not work.
Type "help" for help.

Installating PostgreSQL Server on CentOS, RHEL 6 / 7 Systems

This article will help you for installing PostgreSQL on CentOS, RHEL 6 / 7 Systems