Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I am running postgres 9.6 cluster on ubuntu 20.
All installation and starting the database is fine, however, I am experiencing a weird behavior.
In the pg_hba.conf file, I am trusting any connection from any user from the local host and it is working just fine when I start the cluster using the "pg_ctl start" utility.
However, when I start it from the systemd, systemctl start [email protected], it fails with the following error
Anyone has proper explanation for this difference in behaviour ?
Figured it why; When you use pg_ctl to stop/start your cluster, you define your data directory with -D argument.
However, when you start postgres with systemd 'systemctl stop/start <>', it fetch the configuration (postgresql.conf and pg_hba.conf) from /etc/postgresql/.... according to what is defined in the service definition in systemd.
That is what caused the difference in behaviour.
