Re: Unable to start the slave instance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Jul 6, 2017 at 2:02 PM, Daulat Ram <Daulat.Ram@xxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux