Re: [GENERAL] replication slot to be used in the future

2017-01-04 Thread Tom DalPozzo
2017-01-04 18:24 GMT+01:00 Adrian Klaver : > On 01/04/2017 08:44 AM, Tom DalPozzo wrote: > >> Hi, >> > > Postgres version? > > Because in 9.6: > > https://www.postgresql.org/docs/9.6/static/functions-admin.h > tml#FUNCTIONS-REPLICATION > > Table 9-82. Replication SQL

Re: [GENERAL] replication slot to be used in the future

2017-01-04 Thread Adrian Klaver
On 01/04/2017 08:44 AM, Tom DalPozzo wrote: Hi, Postgres version? Because in 9.6: https://www.postgresql.org/docs/9.6/static/functions-admin.html#FUNCTIONS-REPLICATION Table 9-82. Replication SQL Functions pg_create_physical_replication_slot(slot_name name [, immediately_reserve boolean

[GENERAL] replication slot to be used in the future

2017-01-04 Thread Tom DalPozzo
Hi, I've got my primary and I make a pg_basebackup -x in order to create a standby. I can connect my standby only later, in some hours, so I'd like the master to keep new WALs but I don't like to use archiving nor keep-segments option. I thought to do it through a physical replication slot (my