Settings in master server:
max_wal_senders = 1
wal_level = 'archive'
archive_mode = on
archive_command = 'cd .'
wal_keep_segmen ts = 10000
Settings in slave server:
in recovery.conf file:
Standby_mode = 'on'
primary_conninf o = 'host=ipaddress of master user=repuser'
trigger_file = '/tmp/postgresql.trig ger.5432'
log_connections =on is set up on both master and slave server
entry is made for replication user in pg_hba.conf file in master
server
host replication repuser ipaddress/32 trust
when trying to replicate i get the following error
2014-07-14 19:28:22 IST LOG: database system was shut down in
recovery at 2014- 07-14 19:28:21 IST
2014-07-14 19:28:22 IST LOG: entering standby mode
2014-07-14 19:28:22 IST WARNING: WAL was generated with
wal_level=minim al, data may be missing
2014-07-14 19:28:22 IST HINT: This happens if you temporarily set
wal_level=minim al without taking a new base backup.
2014-07-14 19:28:22 IST LOG: consistent recovery state reached at 0/19FFE28
2014-07-14 19:28:22 IST LOG: record with zero length at 0/19FFE28
2014-07-14 19:28:22 IST FATAL: database system identifier differs
between the primary and standby
2014-07-14 19:28:22 IST DETAIL: The primary's identifier is
602201902774904 0119, the standby's identifier is 603356240519390 4122.
2014-07-14 19:28:23 IST LOG: connection received: host=[local]
2014-07-14 19:28:23 IST FATAL: the database system is starting up
_______________ _
IST FATAL: database system identifier differs between the primary
and standby
2014-07-14 19:28:37 IST DETAIL: The primary's identifier is
602201902774904 0119, the standby's identifier is
603356240519390 4122.
What does these lines mean ??????
_______________ _______________ _______________ _______________ _______
__________
when i give this command
service postgresql-9.3 start
i get the following error in startup.log file
2014-07-15 11:25:59 IST FATAL: lock file "postmaster.pid " already
exists
2014-07-15 11:25:59 IST HINT: Is another postmaster (PID 25961)
running in data directory "/opt/postgres/PostgreSQL/9.3/data"?
_______________ _______________ _______________ _______________ __
If anyone had already faced this kind of issue pls suggest a
solution.
max_wal_senders = 1
wal_level = 'archive'
archive_mode = on
archive_command = 'cd .'
wal_keep_segmen ts = 10000
Settings in slave server:
in recovery.conf file:
Standby_mode = 'on'
primary_conninf o = 'host=ipaddress of master user=repuser'
trigger_file = '/tmp/postgresql.trig ger.5432'
log_connections =on is set up on both master and slave server
entry is made for replication user in pg_hba.conf file in master
server
host replication repuser ipaddress/32 trust
when trying to replicate i get the following error
2014-07-14 19:28:22 IST LOG: database system was shut down in
recovery at 2014- 07-14 19:28:21 IST
2014-07-14 19:28:22 IST LOG: entering standby mode
2014-07-14 19:28:22 IST WARNING: WAL was generated with
wal_level=minim al, data may be missing
2014-07-14 19:28:22 IST HINT: This happens if you temporarily set
wal_level=minim al without taking a new base backup.
2014-07-14 19:28:22 IST LOG: consistent recovery state reached at 0/19FFE28
2014-07-14 19:28:22 IST LOG: record with zero length at 0/19FFE28
2014-07-14 19:28:22 IST FATAL: database system identifier differs
between the primary and standby
2014-07-14 19:28:22 IST DETAIL: The primary's identifier is
602201902774904 0119, the standby's identifier is 603356240519390 4122.
2014-07-14 19:28:23 IST LOG: connection received: host=[local]
2014-07-14 19:28:23 IST FATAL: the database system is starting up
_______________ _
IST FATAL: database system identifier differs between the primary
and standby
2014-07-14 19:28:37 IST DETAIL: The primary's identifier is
602201902774904 0119, the standby's identifier is
603356240519390 4122.
What does these lines mean ??????
_______________ _______________ _______________ _______________ _______
__________
when i give this command
service postgresql-9.3 start
i get the following error in startup.log file
2014-07-15 11:25:59 IST FATAL: lock file "postmaster.pid " already
exists
2014-07-15 11:25:59 IST HINT: Is another postmaster (PID 25961)
running in data directory "/opt/postgres/PostgreSQL/9.3/data"?
_______________ _______________ _______________ _______________ __
If anyone had already faced this kind of issue pls suggest a
solution.