Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

263
Views
How to disable replication_slot on postgres

Is there a method to disable a specific replication_slot? When I try to drop it I got an error because it is Active. Thanks

over 4 years ago · Santiago Trujillo
1 answers
Answer question

0

No, you need to turn it off on the replica side before dropping. If you can't do that, then you have to terminate the wal sender and then drop the slot before it has a chance to start up again. Since it is a race, you should arrange to submit the drop command on the same keystroke as the terminate command.

select pg_drop_replication_slot('rep_slot');
    ERROR:  replication slot "rep_slot" is active for PID 162564
select pg_terminate_backend(162564); select pg_drop_replication_slot('rep_slot');
over 4 years ago · Santiago Trujillo Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!