473,322 Members | 1,523 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,322 software developers and data experts.

pg_rewind failing to sync second database

I have a postgresql cluster with following databases with user myuser:

database1
database2
I have setup a replication with one master(192.168.50.8) and slave(192.168.50.9). I failover to slave and when i try to failback to original master using pg_rewind for every database, pg_rewind gets succeed for first database but fails for second database.

For database1, running following command and getting succeed

/usr/pgsql-11/bin/pg_rewind -D "data_dir_path_here" --source-server="port=pg_port_here user=myuser dbname=database1 host=192.168.50.9"

For database2, running following command but getting error:

/usr/pgsql-11/bin/pg_rewind -D "data_dir_path_here" --source-server="port=pg_port_here user=myuser dbname=database2 host=192.168.50.9"

Error: target server must be shut down cleanly Failure, exiting
Apr 27 '19 #1
0 1555

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

Similar topics

4
by: Frnak McKenney | last post by:
I'm using an in-core DataSet as an image of my application's 'database' (a multi-table Access97 mdb file). Updates are made to the DataTables within the DataSet via forms with bound TextBoxes,...
0
by: newbie | last post by:
Hello All, I have a collection of objects that represent entities in a database. The User can modify this collection using a CollectionEditor. Therefore the user can modify the contents of the...
0
by: Wayne | last post by:
The following problem started on my PC about a week ago and I can't link it to any specific change. I'm using Access XP. If I have any database open and try to open any other database by double...
0
by: Wayne | last post by:
Original Post: The following problem started on my PC about a week ago and I can't link it to any specific change. I'm using Access XP. If I have any database open and try to open any other...
0
by: Gordon | last post by:
Hi; This has me confused. I have a dataset which was populated from one database. Can I insert this dataset's rows into a different database table using the same dataAdapter or would I have...
0
by: Wayne | last post by:
I experienced the following problem the last time I installed IE7 beta. Since then I have done a reformat of my hard disc and after using IE6 for a while I installed the latest version of IE7 and...
0
by: koti9876 | last post by:
hi, How sync the database form sql server to MSAccess in c# application?Any one tell me the code for that. Regards, koti.
0
by: beebelbrox | last post by:
Greetings, I am stuck on this. Is it possible to have a subroutine in one database call a subroutine in a second database. my attempt below produces an error. The error i get is "compile error...
0
by: Gael Zoumof | last post by:
Hello, I have two projects, each on their own server and db. Say Proj1, server1, db1, and Proj2, server2, db2. Both are working fine on there own. Proj1 is a big project with multiple...
1
by: JimNeal | last post by:
I have an application where reviwers test two types of water samples (ground water, table 16_5 and surface water, 17_5) for contaminants. They enter in the location of the water source and a...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.