PostgreSQL data directory configuration

Question

I am using PostgreSQL for CentOS. And i changed the data directory to store PostgreSQL data on a different disk.

nano /usr/lib/systemd/system/postgresql.service

#Environment=PGDATA=/var/lib/pgsql/data
Environment=PGDATA=/data/pgsql/data

However, after installing the package update, the contents of the configuration file were changed back to the default settings.

Do I need to check the configuration file every time I install a package update later? Or is there a way to preserve the config file?

You should use systemctl edit to create an override file: serverfault.com/a/840999/581635 — Mike Organek
– Mike Organek, Commented Jul 14, 2020 at 10:15

Laurenz Albe · Accepted Answer · 2020-07-14 10:18:46Z

3

There are two ways to deal with this:

the old way:

You create a file /etc/systemd/system/postgresql.service that contains

 .include /usr/lib/systemd/system/postgresql.service

 [Service]
 Environment=PGDATA=/data/pgsql/data

the new way:

You create a directory /etc/systemd/system/postgresql.service.d that contains a file named (for example) pgdata.conf with the contents
```
 [Service]
 Environment=PGDATA=/data/pgsql/data
```

Then notify systemd with

systemctl daemon-reload

This configuration change will override the corresponding value from /usr/lib/systemd/system/postgresql.service, so the change will survive an upgrade.

answered Jul 14, 2020 at 10:18

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL data directory configuration

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related