Storing config in the data directory

From: Vincent Jaubert <contact(at)vjaubert(dot)com>
To: "pgsql-pkg-debian(at)lists(dot)postgresql(dot)org" <pgsql-pkg-debian(at)lists(dot)postgresql(dot)org>
Subject: Storing config in the data directory
Date: 2024-11-17 11:00:58
Message-ID: joTSP8Gf_Ec9u_ZOxo4Q5ma-rhbpggT0MEr5zSl3X9wL8_BCd2muDNy9WPLZCYADrTl3s5ZGI5G_KNnL4nVW1tJ8O1C-eQIMq8Mp8o9nNj4=@vjaubert.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian

Hi everyone,
i am somewhat struggling with the postgres 16.4 package on Ubuntu. I hope this is the correct mailing list to ask this question.
I am using postgresql on servers deployed in the cloud.
I would like to host both postgres data and config in an attached network storage (block storage). This way, when i want to recreate a new server, i have just to use the same block storage as the previous server to continue working with minimal interruption.
So at boot time, the block storage is mounted at /var/lib/postgresql
The problem is that the debian package choose to store config in /etc/postgresql instead.
I tried various workarounds :

- create a bind mount in /etc/postgresql and another in /var/lib/postgresql
- store settings in /var/lib/postgresql and create a symlink in /etc/postgresql

Both ways work, but when doing like this, for some reason the server is not restarting at bootup.
When running manually `systemctl start postgresql` it works, but whatever i tried, i can't get it to start at boot. I have read dozens of logs, and i don't see any error anywhere.
I am also concerned that in case of failure, the server would not restart.
What could be the source of this ?

Thank you.

Vincent Jaubert

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message apt.postgresql.org Repository Update 2024-11-19 09:55:42 elephant-shed updated to version 1.3.9.pgdg+1
Previous Message Moritz Mühlenhoff 2024-11-16 20:11:28 Re: PostgreSQL CVE-2024-7348 today