Since we now show the application name in pg_stat_replication, I think it would make sense to have the walreceiver set fallback_application_name on the connection string, like so:
diff --git a/src/backend/replication/libpqwalreceiver/libpqwalreceiver.c b/src/backend/replication/libpqwalreceiver/libpqwalreceiv index c052df2..962ee04 100644 --- a/src/backend/replication/libpqwalreceiver/libpqwalreceiver.c +++ b/src/backend/replication/libpqwalreceiver/libpqwalreceiver.c @@ -92,7 +92,7 @@ libpqrcv_connect(char *conninfo, XLogRecPtr startpoint) * "replication" for .pgpass lookup. */ snprintf(conninfo_repl, sizeof(conninfo_repl), - "%s dbname=replication replication=true", + "%s dbname=replication replication=true fallback_application_name=postgres", conninfo); streamConn = PQconnectdb(conninfo_repl); Using fallback_application_name, it can still be overridden in primary_conninfo if the user wants to use it to separate different instances. Any objections to that? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers