echo -e "\du\n\l" | psql -U postgres
pg_dumpall -E UTF8 -U postgres --if-exists --inserts -c > dump_data+schema.sql
service postgresql stop

mv /usr/local/pgsql/data /usr/local/pgsql/data.old

pkg info -oa | grep -Fi postgresql
  postgresql16-client-16.9       databases/postgresql16-client
  postgresql16-server-16.9_1     databases/postgresql16-server
pkg install -y databases/postgresql17-server
pkg info -oa | grep -Fi postgresql
  postgresql17-client-17.5       databases/postgresql17-client
  postgresql17-server-17.5_1     databases/postgresql17-server

su - postgres -c "initdb -D /usr/local/pgsql/data -U postgres -E UTF8 --locale=de_DE.UTF-8"
cat /usr/local/pgsql/data/PG_VERSION
service postgresql start
echo -e "\du" | psql -U postgres

time cat dump_data+schema.sql | psql -U postgres -d template1
  real    41m21.991s
  user    0m4.765s
  sys     0m3.138s

echo "SELECT * FROM pg_stat_activity;" | psql -U postgres