ERROR: must be superuser or replication role to use

Specify that this replication slot is a temporary one Temporary slots are not saved to disk and are automatically dropped on error or when the session has

The function pg_create_physical_replication_slot is used to create a physical replication slot This command has to be run in the master node

postgres create replication slot slot=pg2 $ echo $? 0 $ psql -c DROP_REPLICATION_SLOT pg2 host= port=5432 replication=database user=mba dbname=postgres SELECT $ This would get

postgresql drop replication slot Streaming replication in PostgreSQL involves creating an active copy of a database on a database instance This copy, commonly called a