Re: truncate table in pitr system

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: truncate table in pitr system
Date: 2011-12-07 11:58:10
Message-ID: CA+U5nMKtxqzXnCXqMVHzYisvMxYmFQtD_xm=nTr3-+-etqBVMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

2011/12/7 Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jan-Peter Seifert 2011-12-07 12:46:35 Number of connections still limited on Windows 64-bit?
Previous Message Silvio Brandani 2011-12-07 11:43:11 truncate table in pitr system