473,385 Members | 1,727 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

streaming replication on postgresql-9.3

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
0 1859

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

Similar topics

0
by: Cherrish Vaidiyan | last post by:
Frank <fbortel@nescape.net> wrote in message news:<bqgb99$a04$1@news1.tilbu1.nb.home.nl>... > Cherrish Vaidiyan wrote: > > Hello, > > > > I have certain doubts regarding replication of Oracle 9i ...
6
by: John | last post by:
Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops...
3
by: dlesandrini | last post by:
I need advice about my decision to go with Replication in general. This post was placed on the Microsoft Replication newsgroup, but I really value the feedback that comes from this group as well. ...
56
by: Raphi | last post by:
Hi, I've been using an Access application I wrote for an office with the front-end stored on all computers and the back-end on one of them serving as an Access file server. Now we're moving...
9
by: David W. Fenton | last post by:
See: Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center http://support.microsoft.com/?scid=kb;en-us;321076 This includes the Jet 4...
3
by: Gert van der Kooij | last post by:
Hi, Our SQL Replication is between DB2 databases on Windows servers. I'm searching for the document which tells me how to migrate our SQL Replication environment from V8 to V9 (we also need to...
2
by: Query Builder | last post by:
Hi, I have transactional replication set up on on of our MS SQL 2000 (SP4) Std Edition database server Because of an unfortunate scenario, I had to restore one of the publication databases. I...
0
by: osman7king | last post by:
I have build a replication system on two servers ( Master and Slave) with windows server 2003, how should I configure my application to achieve load balancing? Is load balancing done by the master...
0
by: henryk302 | last post by:
I'm using PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20070115 (SUSE Linux), 64-bit. I set up streaming replication for a read/write primary and a read/only standby. ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.