Unknown lvalue 'PIDFILE' in section 'Service'

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general