[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: Re: [PERFORM] Unable to start the slave instance
From: Michael Paquier <michael.paquier () gmail ! com>
Date: 2017-07-06 5:10:00
Message-ID: CAB7nPqS0NrdFpQ9LvnFRrrgpG6AOr_Uivm8E6pc0jCyJqdkPiA () mail ! gmail ! com
[Download RAW message or body]
On Thu, Jul 6, 2017 at 2:02 PM, Daulat Ram <Daulat.Ram@cyient.com> 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 (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic