Redhat

Running multiple PostgreSQL clusters using systemd

Requirements   Using systemd   Multiple instance of PostgreSQL       First instance running on port 5491       Second instance running on port 5492 Steps to setup first service STEP 1 create and edit service file sudo vi /etc/systemd/system/postgresql-9.4-5941.service STEP 2 Import original and Add Env .include /lib/systemd/system/postgresql-9.4.service [Service] Environment="PGDATA=/var/lib/pgsql/9.4/data1/" STEP 3 Modify postgresql.conf for instance sudo vi /var/lib/pgsql/9.4/data1/postgresql.conf" STEP 4 Change port for postgresql