Postgres Pro
Downloads
Home   >   mailing lists

Re: truncate table in pitr system - Mailing list pgsql-admin

From Simon Riggs
Subject Re: truncate table in pitr system
Date
Msg-id CA+U5nMKtxqzXnCXqMVHzYisvMxYmFQtD_xm=nTr3-+-etqBVMQ@mail.gmail.com
Whole thread Raw
In response to truncate table in pitr system  (Silvio Brandani <silvio.brandani@tech.sdb.it>)
List pgsql-admin
Tree view 
2011/12/7 Silvio Brandani <silvio.brandani@tech.sdb.it>:

> I have a system with archive log shipping to a standby server read only with
> replication streaming.
> is possible to use the truncate in the primary or it will affect the log
> shipping architecture and will corrupt the standby server??

It Just Works.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-admin by date:

Previous
From: Silvio Brandani
Date:
Subject: truncate table in pitr system
Next
From: "Jan-Peter Seifert"
Date:
Subject: Number of connections still limited on Windows 64-bit?