Hi Craig,
I am trying to set up pglogical replication. I have a table which has
around 4 rows in the provider server.
=
employee_id | visitor_email | vistor_id |date |
message
-+---+---+-+--
1 | ros...@gmail.com | 1 | 2016-08-24 00:00:00 |
This is the first test.
2 | ros...@myrepublic.net | 2 | 2016-08-24 00:00:00 |
This is the second test.
3 | ros...@myrepublic.net | 3 | 2016-08-24 00:00:00 |
This is the third test.
4 | ros...@myrepublic.net | 4 | 2016-08-24 00:00:00 |
This is the fourth test.
===
After creating the above mentioned table. I have created a replication set
in the provider . Then I configured the subscriber node and the
subscription. Ideally, I should see the 4 rows from the provider table in
my subscriber, but I am only seeing the table structure in subscriber, not
the data. If I add a new row in the provider table as follows
INSERT INTO employees (employee_id, visitor_email, date, message) VALUES
(4, 'ros...@myrepublic.net', current_date, 'This is the fourth test.');
Now, I am able to see the last added row in my subscriber table. All the
other 4 rows which were added in the beginning are still missing. What am I
doing wrong here?
Does it mean that only the data which was created after the creation of
replication_sets will be considered? How to add the whole content of a
table to a replication set.?
Any help would be much appreciated.?
Regards,
Muhammed Roshan
On Thu, Aug 18, 2016 at 1:01 PM, Craig Ringer-3 [via PostgreSQL] <
ml-node+s1045698n5916916...@n5.nabble.com> wrote:
> On 17 August 2016 at 18:21, roshan_myrepublic <[hidden email]
> <http:///user/SendEmail.jtp?type=node=5916916=0>> wrote:
>
>> Hi,
>>
>> I am currently exploring pglogical replication for my db servers. I would
>> like to know how can I automatically failover from Provider Node to
>> Subscriber Node, if the Provider node goes down for some reasons. How can
>> I
>> redirect all the traffic to SubscriberNode automatically ? In the normal
>> replication, we use recovery_file and triggers to get this job done. Do we
>> have any similar alternative for pglogical replications as well?
>
>
> There is not, as yet, any integegration into tooling like repmgr. You'll
> want some fairly simple scripts to manage failover, likely:
>
> * Update pgbouncer / haproxy / whatever to redirect connections
> * Drop the subscription on the replica
> * STONITH to make sure the master is really down
> * Clone and start a new master
>
> There's some work on automating this through repmgr, but at this time
> pglogical isn't really focused on failover deployments as its main use
> case. The limitations in PostgreSQL's logical decoding and replication when
> it comes to handling of big xacts, sequences, etc mean it's still better
> suited to data movement/integration etc than HA.
>
> --
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
>
> --
> If you reply to this email, your message will be added to the discussion
> below:
> http://postgresql.nabble.com/How-to-do-failover-in-pglogical-replication-
> tp5916769p5916916.html
> To unsubscribe from How to do failover in pglogical replication?, click
> here
> <http://postgresql.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code=5916769=cm9zaGFuQG15cmVwdWJsaWMubmV0fDU5MTY3Njl8LTEwNjYxNDc1NDg=>
> .
> NAML
> <http://postgresql.nabble.com/template/NamlServlet.jtp?macro=macro_viewer=instant_html%21nabble%3Aemail.naml=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
--
View this message in context:
http://postgresql.nabble.com/How-to-do-failover-in-pglogical-replication-tp5916769p5917300.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
