postgresql - FATAL: database "dbname" does not exist

Question

I drop one database from production primary server. Still I'm getting error in postgresql error log on secondary server.

FATAL: database "dbname" does not exist User: postgres

I checked, this DB is not used from our any application or monitoring tools. This error occurred 192 times in 1 hour. That means the request comes to this DB every 3.2 sec. Any idea how to get from where this request comes ?

question from:https://stackoverflow.com/questions/65842310/fatal-database-dbname-does-not-exist

Answer 1

Change the log_line_prefix parameter to contain %h, then the IP address of the client that tried to connect will be logged.