public inbox for [email protected]  

help / color / mirror / Atom feed

From: Michael Paquier <[email protected]>
To: Daulat Ram <[email protected]>
Cc: Scott Marlowe <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Unable to start the slave instance
Date: Thu, 6 Jul 2017 14:10:00 +0900
Message-ID: <CAB7nPqS0NrdFpQ9LvnFRrrgpG6AOr_Uivm8E6pc0jCyJqdkPiA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<CAOR=d=2Y9Q1PMF6kY3ci6ZdxpVQ+PjEd8gjG0Tdjhax=f-rCvA@mail.gmail.com>
	<[email protected]>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

On Thu, Jul 6, 2017 at 2:02 PM, Daulat Ram <[email protected]> wrote:
> We are using different releases of windows. Is this issue reported due to different versions of windows releases.
> Master server : Windows 7 Professional
> Slave server : Windows 10 Professional

Please do not top-post.

That may be a problem. Versions of PostgreSQL compiled across
different platforms are different things, and replication is not
supported for that as things happen at a low binary level.

> Step:9
> Replicating the Initial database:
> On the master server, we can use an internal postgres backup start command to create a backup label command. We then will transfer the database data to our slave and then issue an internal backup stop command to clean up:
> psql -c “select pg_start_backup(‘initial_backup’);”
> rsync -cva –inplace –exclude=*pg_xlog* /var/lib/postgresql/9.3/main/ slave_IP_address:/var/lib/postgresql/9.3/main/
> psql -c “select pg_stop_backup ();”

Shouldn't you remove the data of the slave as well first?
-- 
Michael


-- 
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Unable to start the slave instance
  In-Reply-To: <CAB7nPqS0NrdFpQ9LvnFRrrgpG6AOr_Uivm8E6pc0jCyJqdkPiA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox