I'm trying to configure streaming replication between a Red Hat server running PostGreSQL 9.2.2 and a Debian server running PostGreSQL 9.2.24 with Hot Standby enabled.
While the base backup works fine using pg_basebackup, I get the following errors with hot standby enabled on the Debian slave when starting PostGreSQL:
WARNING: WAL was generated with wal_level=minimal, data may be missing
HINT: This happens if you temporarily set wal_level=minimal without taking a new base backup.
FATAL: hot standby is not possible because wal_level was not set to "hot_standby" on the master server
HINT: Either set wal_level to "hot_standby" on the master, or turn off hot_standby here
If I turn Hot Standby off on the Debian Slave I get the following errors:
FATAL: database system identifier differs between the primary and standby
DETAIL: The primary's identifier is 5940475598986796885, the standby's identifier is 6557962695089036503.
Configuring streaming replication with Hot Standby enabled locally on the Red Hat server works like a charm, and I've thus concluded that the issues must be one of the following:
- PostGreSQL's minor version differs between the 2 servers
- The two servers are running different operating systems
Any insight or guidance as to achieve this scenario would be greatly appreciated.
Cheers
Jona