BUG #13448: DOC about : pg_dump use logical replication snapshot

From: digoal(at)126(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13448: DOC about : pg_dump use logical replication snapshot
Date: 2015-06-17 00:45:24
Message-ID: 20150617004524.2730.86600@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13448
Logged by: digoal
Email address: digoal(at)126(dot)com
PostgreSQL version: Unsupported/Unknown
Operating system: CentOS 6.x x64
Description:

PostgreSQL 9.5 release notes:
E.1.3.9.2. pg_dump

Allow pg_dump to share a snapshot taken by another session using --snapshot
(Simon Riggs, Michael Paquier)

The remote snapshot must have been exported by pg_export_snapshot() or been
defined when creating a logical replication slot. This can be used by
parallel pg_dump to use a consistent snapshot across pg_dump processes.

There is no problem, But how to use a logical replication slot's snapshot?
Now we must do it manual?
Like this:
pg95(at)db-172-16-3-150-> psql 'hostaddr=127.0.0.1 port=1922 user=postgres
dbname=postgres replication=database'
psql (9.5devel)
Type "help" for help.
postgres=# CREATE_REPLICATION_SLOT ab12 LOGICAL
"/opt/pgsql9.5/lib/test_decoding.so";
slot_name | consistent_point | snapshot_name | output_plugin

-----------+------------------+---------------+------------------------------------
ab12 | 7/77B59A00 | 00000736-1 |
/opt/pgsql9.5/lib/test_decoding.so
(1 row)

pg95(at)db-172-16-3-150-> pg_dump --snapshot=00000736-1

And there is no document descript it.
Another command pg_recvlogical also can use stream replication protocol to
create slot,but it exit soon and no any snapshot info output to stdout, we
can use log_replication_commands to trace the snapshot, but we cann't use it
because pg_recvlogical exit soon.

I think , pg_recvlogical can add option --wait-dump | --wait second for
--create-slot, wait a moment or wait some body import the snapshot, then
close it or send the next replication commands.

Regards,
Digoal

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sameer Kumar 2015-06-17 01:17:06 Re: pg_xlog on a hot_stanby slave
Previous Message Venkata Balaji N 2015-06-17 00:44:24 Re: pg_xlog on a hot_stanby slave