Thread: [GENERAL] iso-8859-1 lvalue 'PIDFILE' in section 'Service'
Hi
Today I installed postgresql 9.4 on Lubuntu 15.04 from the EnterpriseDB's package.
I modified pg_hba.conf to accept connections from the local network, and tried to start the backend. It do not; looking the log, I can see the message I copied to the subject. The full log entry is [/lib/systemd/system/postgresql-9.4.service:12] Unknown lvalue 'PIDFILE' in section 'Service'
But the corresponding entry in /lib/systemd/system/postgresql-9.4.service shows PIDFILE=/opt/PostgreSQL/9.4/data/postmaster.pid which is perfectly valid, because the
data dir is Environment=PGDATA=/opt/PostgreSQL/9.4/data
What is going wrong?
TIA
Marcelo
Today I installed postgresql 9.4 on Lubuntu 15.04 from the EnterpriseDB's package.
I modified pg_hba.conf to accept connections from the local network, and tried to start the backend. It do not; looking the log, I can see the message I copied to the subject. The full log entry is [/lib/systemd/system/postgresql-9.4.service:12] Unknown lvalue 'PIDFILE' in section 'Service'
But the corresponding entry in /lib/systemd/system/postgresql-9.4.service shows PIDFILE=/opt/PostgreSQL/9.4/data/postmaster.pid which is perfectly valid, because the
data dir is Environment=PGDATA=/opt/PostgreSQL/9.4/data
What is going wrong?
TIA
Marcelo
On 06/28/2017 05:06 AM, marcelo wrote: > Hi > > Today I installed postgresql 9.4 on Lubuntu 15.04 from the > EnterpriseDB's package. > > I modified pg_hba.conf to accept connections from the local network, and > tried to start the backend. It do not; looking the log, I can see the > message I copied to the subject. The full log entry is > [/lib/systemd/system/postgresql-9.4.service:12] Unknown lvalue 'PIDFILE' > in section 'Service' > > But the corresponding entry in > /lib/systemd/system/postgresql-9.4.service shows > PIDFILE=/opt/PostgreSQL/9.4/data/postmaster.pid which is perfectly > valid, because the > data dir is Environment=PGDATA=/opt/PostgreSQL/9.4/data > > What is going wrong? I am no systemd expert by any means, but I have to believe that it should be: Environment=PIDFILE=/opt/PostgreSQL/9.4/data/postmaster.pid > > TIA > > Marcelo > > -- Adrian Klaver adrian.klaver@aklaver.com
On 28/06/17 10:17, Adrian Klaver wrote: > On 06/28/2017 05:06 AM, marcelo wrote: >> Hi >> >> Today I installed postgresql 9.4 on Lubuntu 15.04 from the >> EnterpriseDB's package. >> >> I modified pg_hba.conf to accept connections from the local network, >> and tried to start the backend. It do not; looking the log, I can see >> the message I copied to the subject. The full log entry is >> [/lib/systemd/system/postgresql-9.4.service:12] Unknown lvalue >> 'PIDFILE' in section 'Service' >> >> But the corresponding entry in >> /lib/systemd/system/postgresql-9.4.service shows >> PIDFILE=/opt/PostgreSQL/9.4/data/postmaster.pid which is perfectly >> valid, because the >> data dir is Environment=PGDATA=/opt/PostgreSQL/9.4/data >> >> What is going wrong? > > I am no systemd expert by any means, but I have to believe that it > should be: > > Environment=PIDFILE=/opt/PostgreSQL/9.4/data/postmaster.pid > Hi Adrian Thank you very much. I tried your "recipe" and it was the solution. But I had to change the pg_hba.conf permissions, from -rw------- 1 root root 4318 jun 28 06:57 data/pg_hba.conf to -rw-r--r-- 1 root root 4318 jun 28 06:57 data/pg_hba.conf I note this, because others may find the same issue. Now, the server is started! Marcelo