473,288 Members | 1,729 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,288 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 1553

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...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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)...

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.