Search Postgresql Archives

[ADMIN] how to recovery your database when stops replicating

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

 



Hi all,

 

I´m testing BDR and have a big deal. When it gets corrupted, after time of working well, I cannot do a recovery and the only way to get the system working again seems to reset all again. It means:

 

-          Stop all nodes.

-          Delete data directories in both nodes

-          Comment BDR entries in postgresql.conf in node A.

-          Start node A and restore database.

-          Uncomment BDR entries in node A.

-          Start node B with BDR entries so that executes initial copy.

-          It works again.

 

I think there should be a better way to do it. I have some mails from here telling this:

 

-          Execute this sql in both nodes:

 

SELECT slot_name, datoid, database, active FROM pg_replication_slots WHERE slot_name LIKE 'bdr_'||(SELECT oid FROM pg_database WHERE datname = current_database())||'_%';

 

-          Execute this sql to be able to DDL again:

COPY (SELECT * FROM pg_logical_slot_get_binary_changes('bdr_17911_6120567807158814813_1_16385__', NULL, 1, 'interactive', 'true')) TO '/dev/null';

 

-          Reconnect  and do this:

SET bdr.skip_ddl_replication = on;

 

 

But that method don´t work for me. Any help? How do you recovery your database when stops replicating?

 

Thanks in advance

 

Ruth Patricia Melendo Ventura

Software Engineer

TELTRONIC, S.A.U.

T: +34 976 465656   Ext. 179

F: +34 976 465722

www.teltronic.es

 

Logo40

 

Before printing this e-mail please consider your environmental responsibility.

*****  DISCLAIMER  *****

This message is intended exclusively for the named person. It may contain confidential, propietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. Your must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorised to state them to be the views of TELTRONIC. If the addressee of this message does not consent to the use of internet e-mail, please communicate it to us immediately.

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux