| From: | "Rainer Brestan" <rainer(dot)brestan(at)gmx(dot)net> |
|---|---|
| To: | pgsql-cluster-hackers(at)postgresql(dot)org |
| Subject: | [pg_rewind] Request for command line switch to prevent removal of stored procedures |
| Date: | 2015-08-17 10:16:50 |
| Message-ID: | trinity-dec9e13c-22a3-4d29-9953-d7f6fc84a18c-1439806609964@3capp-gmx-bs18 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-cluster-hackers |
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>pg_rewind installes stored procedures at begin and remove them after end of operation.</div>
<div>This makes it impossible to run twice simultaneously.</div>
<div> </div>
<div>pg_rewind is a useful extension for Pacemaker clusters.</div>
<div>It makes it possible to demote and sync automatically to the new master (when it is promoted), because it needs only few seconds.</div>
<div>Therefore, this feature can be integrated in the psql resource agent.</div>
<div> </div>
<div>But it is impossible for the resource agent to guarantee only one node will cann pg_rewind at the same time.</div>
<div>Especially when the Postgres resource is in different clusters configured.</div>
<div>One slave (which calls pg_rewind) will remove the stored procedures another slave is accessing.</div>
<div> </div>
<div>Would it be possible to add a command line switch to pg_rewind, which does not remove the stored procedures at end of operation and check for existance on start ?</div>
<div>Default is to remove at end.</div>
<div> </div>
<div>In case we use pg_rewind with Pacemaker, it is harmless existing all the time in the database.</div>
<div>And we can integrate a recover feature into Pacemaker for Postgres resources.</div>
<div> </div>
<div>Rainer</div></div></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | FattahRozzaq | 2015-09-09 06:41:22 | Can we limit the total size of WAL? |
| Previous Message | Genc | 2015-07-09 11:52:20 | Design of live and archive database |