pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedtruncate table in pitr system
2+ messages / 2 participants
[nested] [flat]
* truncate table in pitr system
@ 2011-12-07 11:43 Silvio Brandani <silvio.brandani@tech.sdb.it>
0 siblings, 1 reply; 2+ messages in thread
From: Silvio Brandani @ 2011-12-07 11:43 UTC (permalink / raw)
To: pgsql-admin
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.
--
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: truncate table in pitr system
@ 2011-12-07 11:58 Simon Riggs <simon@2ndQuadrant.com>
parent: Silvio Brandani <silvio.brandani@tech.sdb.it>
0 siblings, 0 replies; 2+ messages in thread
From: Simon Riggs @ 2011-12-07 11:58 UTC (permalink / raw)
To: Silvio Brandani <silvio.brandani@tech.sdb.it>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-12-07 11:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-12-07 11:43 truncate table in pitr system Silvio Brandani <silvio.brandani@tech.sdb.it>
2011-12-07 11:58 ` Simon Riggs <simon@2ndQuadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox