su -m keeps root’s HOME, and psql notices
In February 2024 I wrote about could not open certificate file “/root/.postgresql/postgresql.crt”: Permission denied. I fixed it by adding sslcertmode=disable to the connection string, and ended with: does anyone know why this might have happened? That fix has been copied into several scripts since, for example the one in Why does this PostgreSQL \copy fail when launched by the daemon? Tonight I hit it again, and this time the cause was plain to
su -m keeps root’s HOME, and psql notices Read More »