pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgsql: Remove pg_dump's --no-synchronized-snapshots switch.
2+ messages / 2 participants
[nested] [flat]

* pgsql: Remove pg_dump's --no-synchronized-snapshots switch.
@ 2021-12-15 23:45 Tom Lane <tgl@sss.pgh.pa.us>
  2021-12-17 15:40 ` Re: pgsql: Remove pg_dump's --no-synchronized-snapshots switch. Adrien Nayrat <adrien.nayrat@anayrat.info>
  0 siblings, 1 reply; 2+ messages in thread

From: Tom Lane @ 2021-12-15 23:45 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Remove pg_dump's --no-synchronized-snapshots switch.

Server versions for which there was a plausible reason to
use this switch are all out of support now.  Leaving it
around would accomplish little except to let careless DBAs
shoot themselves in the foot.

Discussion: https://postgr.es/m/556122.1639520324@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2a712066d0587f65fcecd44e884dc6a09958dbdd

Modified Files
--------------
doc/src/sgml/ref/pg_dump.sgml | 14 +-------------
src/bin/pg_dump/pg_backup.h   |  1 -
src/bin/pg_dump/pg_dump.c     | 11 ++---------
3 files changed, 3 insertions(+), 23 deletions(-)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pgsql: Remove pg_dump's --no-synchronized-snapshots switch.
  2021-12-15 23:45 pgsql: Remove pg_dump's --no-synchronized-snapshots switch. Tom Lane <tgl@sss.pgh.pa.us>
@ 2021-12-17 15:40 ` Adrien Nayrat <adrien.nayrat@anayrat.info>
  0 siblings, 0 replies; 2+ messages in thread

From: Adrien Nayrat @ 2021-12-17 15:40 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

On 12/16/21 00:45, Tom Lane wrote:
> Remove pg_dump's --no-synchronized-snapshots switch.
> 
> Server versions for which there was a plausible reason to
> use this switch are all out of support now.  Leaving it
> around would accomplish little except to let careless DBAs
> shoot themselves in the foot.
> 
> Discussion: https://postgr.es/m/556122.1639520324@sss.pgh.pa.us
> 

Hello,

I have seen one situation where this option could have been useful even on 
recent Postgres version:

Few years ago, I have seen an instance hit wraparound (1 million transactions 
left) due to a bug (vacuum didn't freeze some blocks, bug has been fixed since).

I had to perform a dump/restore, but can't use parallel dump as Postgres refused 
to export transaction snapshot. So the dump was ... long.

Late in the night, I didn't notice I could have used --no-synchronized-snapshots 
to perform parallel dump. As Postgres didn't accept new transaction, there was 
no risk of incoherent dump.

I don't know if we should keep this option. I just want to share a case where 
this option could have been useful.


Regards,

-- 
Adrien





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2021-12-17 15:40 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-12-15 23:45 pgsql: Remove pg_dump's --no-synchronized-snapshots switch. Tom Lane <tgl@sss.pgh.pa.us>
2021-12-17 15:40 ` Adrien Nayrat <adrien.nayrat@anayrat.info>

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