| From: | ROS Didier <didier(dot)ros(at)edf(dot)fr> |
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, "pgsql-sql-owner(at)postgresql(dot)org" <pgsql-sql-owner(at)postgresql(dot)org> |
| Subject: | pg_walldump and PITR. PostgreSQL 10.1 |
| Date: | 2018-02-13 12:58:44 |
| Message-ID: | 9dfe5e39a17c4cae9508099b77246c6a@PCYINTPEXMU001.NEOPROD.EDF.FR |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi
I would like to make PITR restoration and for that purpose I would like to use pg_waldump in order to find oid of the table or xid of the problematic transaction (update ville set nville = 'PANAME' ; ).
How can I do that ? I can't find detailed documentation on this tool.
Thanks in advance.
NB : I can send you the complete scenario script I use, in order to reproduce the test case...
Best regards
[cid:image002(dot)png(at)01D14E0E(dot)8515EB90]
Didier ROS
Expertise SGBD
DS IT/IT DMA/Solutions Groupe EDF/Expertise Applicative - SGBD
Nanterre Picasso - E2 565D (aile nord-est)
32 Avenue Pablo Picasso
92000 Nanterre
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ROS Didier | 2018-02-19 15:35:58 | barman 1.3.3 - barman list-backup ne montre pas tous les backup disponibles |
| Previous Message | Stuart | 2018-02-12 14:33:04 | Re: Conditional update |