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 … 

With this additional configuration in your configuration file, the backup works:

max_wal_senders = 5
wal_level = hot_standby
archive_mode = on

Initiating the Backup if the database is in no-Archivelog mode, Fails with below error






Enabling the log mode :

Edit the postgresql.conf and add the following. Reload the config

archive_command = 'cp %p /var/lib/pgsql/9.6/data/wal_e/%f'     

Now I see, my WAL files have started generating :