0

I have a server with postgresql 13 and several postgresql clients that are mutually synchronized by logical replication. Due to problems with the replication in base A that I couldn't solve, I decided to create another identical base B, pass all the data from A to B and start the replication with base B. Then I deleted all the bases A with their subscriptions and publications. The procedure worked quite well but now there are processes trying to connect to base A and I can't find what they are, I already checked all the databases of all the machines with their publications, subscriptions and slots and I can't find any publications or subscriptions that reference to base A! The log on the server only says: 2022-11-10 09:28:12.344 -03 [6628] FATAL: database "A" does not exist

Is there a way to search the catalog by database name to try and find who is connecting?

vittorio
  • 1
  • 1

0 Answers0