From ffcc02249a0f230c69c7328d336d16308e840fdf Mon Sep 17 00:00:00 2001
From: Paul Norman <penorman@mac.com>
Date: Tue, 27 May 2025 14:50:19 -0700
Subject: [PATCH] vectortile: set postgres application_name

---
 cookbooks/vectortile/templates/default/import-planet.erb        | 1 +
 cookbooks/vectortile/templates/default/render-lowzoom.erb       | 1 +
 .../vectortile/templates/default/tilekiln-storage-init.erb      | 2 ++
 cookbooks/vectortile/templates/default/tiles-rerender.erb       | 1 +
 cookbooks/vectortile/templates/default/vector-update-tile.erb   | 1 +
 5 files changed, 6 insertions(+)

diff --git a/cookbooks/vectortile/templates/default/import-planet.erb b/cookbooks/vectortile/templates/default/import-planet.erb
index 3d6110181..f0bac4058 100644
--- a/cookbooks/vectortile/templates/default/import-planet.erb
+++ b/cookbooks/vectortile/templates/default/import-planet.erb
@@ -8,6 +8,7 @@
 set -e
 
 export LUA_PATH='/srv/vector.openstreetmap.org/osm2pgsql-themepark/lua/?.lua;;'
+export PGAPPNAME='import-planet'
 
 # Import the osm2pgsql file specified as an argument, using the locations for spirit
 osm2pgsql \
diff --git a/cookbooks/vectortile/templates/default/render-lowzoom.erb b/cookbooks/vectortile/templates/default/render-lowzoom.erb
index 51d630472..b14550f40 100644
--- a/cookbooks/vectortile/templates/default/render-lowzoom.erb
+++ b/cookbooks/vectortile/templates/default/render-lowzoom.erb
@@ -1,5 +1,6 @@
 #!/bin/sh
 set -eu
+export PGAPPNAME='render-lowzoom'
 
 # The source daily vaccum is best placed before the tilegen, as it has marginal speed benefits
 vacuumdb --analyze \
diff --git a/cookbooks/vectortile/templates/default/tilekiln-storage-init.erb b/cookbooks/vectortile/templates/default/tilekiln-storage-init.erb
index 972d0e488..24a799aed 100644
--- a/cookbooks/vectortile/templates/default/tilekiln-storage-init.erb
+++ b/cookbooks/vectortile/templates/default/tilekiln-storage-init.erb
@@ -3,6 +3,8 @@
 # Usage
 # sudo -u tileupdate tilekiln-storage-init
 
+export PGAPPNAME='tilekiln-storage-init'
+
 <%= @tilekiln_bin %> storage init \
   --storage-dbname <%= @storage_database %> \
   --config <%= @config_path %>
diff --git a/cookbooks/vectortile/templates/default/tiles-rerender.erb b/cookbooks/vectortile/templates/default/tiles-rerender.erb
index d1ca4bdab..910560771 100644
--- a/cookbooks/vectortile/templates/default/tiles-rerender.erb
+++ b/cookbooks/vectortile/templates/default/tiles-rerender.erb
@@ -1,5 +1,6 @@
 #!/bin/sh
 set -eu
+export PGAPPNAME='tiles-rerender'
 
 cd "<%= @expiry_dir %>"
 # Only expire z10+ tiles
diff --git a/cookbooks/vectortile/templates/default/vector-update-tile.erb b/cookbooks/vectortile/templates/default/vector-update-tile.erb
index a356cbb10..3db8220c0 100644
--- a/cookbooks/vectortile/templates/default/vector-update-tile.erb
+++ b/cookbooks/vectortile/templates/default/vector-update-tile.erb
@@ -6,6 +6,7 @@
 set -eu
 
 export LUA_PATH='/srv/vector.openstreetmap.org/osm2pgsql-themepark/lua/?.lua;;'
+export PGAPPNAME='vector-update'
 
 cd "<%= @expiry_dir %>"
 rm -f z*.txt
-- 
2.39.5