By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,918 Members | 1,557 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,918 IT Pros & Developers. It's quick & easy.

streaming replication on postgresql-9.3

P: 1
Settings in master server:
max_wal_senders = 1
wal_level = 'archive'
archive_mode = on
archive_command = 'cd .'
wal_keep_segments = 10000

Settings in slave server:
in recovery.conf file:
Standby_mode = 'on'
primary_conninfo = 'host=ipaddress of master user=repuser'
trigger_file = '/tmp/postgresql.trigger.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=minimal, data may be missing
2014-07-14 19:28:22 IST HINT: This happens if you temporarily set

wal_level=minimal 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

6022019027749040119, the standby's identifier is 6033562405193904122.
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

6022019027749040119, the standby's identifier is

6033562405193904122.

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.
Jul 15 '14 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.