Question 188210 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – Getting ERROR: replication slot 'slot_name' does not exist

I’m trying to set up data replication between PostgreSQL databases using Apache Age and I am getting an error message like this: "replication slot ‘slot_name’ does not exist".

I was expecting the primary database’s replication slot to be established and ready for replication.

Tags:

2

Answers


  1. 0

    For replication and load balancing, Apache-age offers the customized support of Pgpool-II(AGEHA), @repo: https://github.com/apache/age/tree/AGEHA,
    You can use this for replication of queries, and load balancing.
    You can follow the conventional procedure of connecting Postgresql to pgpool-II.

    Login or Signup to reply.
  2. 0

    If you are facing such an issue, it is because the replication slot has not been created or the slot doesn’t exist in the database. Make sure you have created the replication slot in PostgreSQL.
    You can use the below command to create a replication slot on the primary database.

    SELECT pg_create_physical_replication_slot('slot_name');

    Replace the slot name with your desired slot name. After creating the replication slot, you can proceed to data replication without facing such an error.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search