Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id C66BF9ED58D for ; Wed, 7 Dec 2011 07:43:26 -0400 (AST) Received: from mail2.sdb.it ([85.37.147.67]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RYFuG-0001rT-Ca for pgsql-admin@postgresql.org; Wed, 07 Dec 2011 11:43:26 +0000 Received: by mail2.sdb.it (Postfix, from userid 500) id 8B8728028; Wed, 7 Dec 2011 12:43:11 +0100 (CET) Received: from geronimo.sdb.it (geronimo.sdb.it [10.101.1.20]) by mail2.sdb.it (Postfix) with ESMTP id 8668D8022 for ; Wed, 7 Dec 2011 12:43:11 +0100 (CET) Received: from mailtech.sdb.it (localhost [127.0.0.1]) by geronimo.sdb.it (Postfix) with ESMTP id C245F380870 for ; Wed, 7 Dec 2011 12:43:02 +0100 (CET) Received: from [10.118.101.88] (silviob.sdb.it [10.118.101.88]) by mailtech.sdb.it (Postfix) with ESMTP id EF2A760063 for ; Wed, 7 Dec 2011 12:35:17 +0100 (CET) Message-ID: <4EDF514F.9060703@tech.sdb.it> Date: Wed, 07 Dec 2011 12:43:11 +0100 From: Silvio Brandani User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.9.2.23) Gecko/20110920 Thunderbird/3.1.15 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: truncate table in pitr system Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Private-Material: Please read notice X-Pg-Spam-Score: -0.4 (/) X-Archive-Number: 201112/42 X-Sequence-Number: 38800 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?? thanks -- Silvio Brandani --- Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalitą amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/privacy.html Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/privacy/codice_penale_616.html L'Azienda non si assume alcuna responsabilitą giuridica qualora pervengano da questo indirizzo messaggi estranei all'attivitą lavorativa o contrari a norme. --