On Wed, Jul 29, 2015 at 10:15 PM, Andres Freund wrote: > It's not that uncommon to have replicas only access the primary for > replication type connections. So it seems completely sensible to use the > replication protocol to manage slots. And that you can't really do with > psql.
Actually, you can. CREATE_REPLICATION_SLOT is one of the commands that work with psql, but that's not really practical compared to what pg_recvlogical and pg_receivexlog can do. $ psql -d "replication=1" =# CREATE_REPLICATION_SLOT hoge PHYSICAL; slot_name | consistent_point | snapshot_name | output_plugin -----------+------------------+---------------+--------------- hoge | 0/0 | null | null (1 row) -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
