From: | marcelo <marcelo(dot)nicolet(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unknown lvalue 'PIDFILE' in section 'Service' |
Date: | 2017-06-28 16:28:53 |
Message-ID: | 413363f5-8744-a842-74fd-b09993b8d2fc@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Niel Smith | 2017-06-28 18:32:44 | PostGreSQL Timeout, auto shutdown and Pkey errors |
Previous Message | Chris Travers | 2017-06-28 15:39:20 | Re: Is the row version available in SQL? |