From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | stan <stanb(at)panix(dot)com>, Ray O'Donnell <ray(at)rodonnell(dot)ie> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: server will not start (Debian) |
Date: | 2019-12-10 17:06:21 |
Message-ID: | 8c3c0bf6-1647-4934-8580-5c54c55fef01@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/10/19 9:03 AM, stan wrote:
>
> On Tue, Dec 10, 2019 at 04:13:02PM +0000, Ray O'Donnell wrote:
>> On 10/12/2019 16:11, Adrian Klaver wrote:
>>> On 12/10/19 7:32 AM, stan wrote:
>>>> On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
>>>>> Hi Stan
>>>>>
>>>>> Check security make sure V12 postgres?? has the correct credentials....
>>>>>
>>>> OK,
>>>>
>>>> postgres(at)stantest:/var/run/postgresql$ ls -ld
>>>> drwxrwsr-x 2 postgres postgres 40 Dec 10 08:35 .
>>>>
>>>> Looks correct to me.
>>>>
>>>> This sundirectory 12-main.pg_stat_tmp keeps getting deleted.
>>>>
>>>> If I create it by hand as user psotgres, the DB starts up when I run:
>>>>
>>>> /usr/lib/postgresql/12/bin/postgres -D /var/lib/postgresql/12/main -c
>>>> config_file=/etc/postgresql/12/main/postgresql.conf
>>>>
>>>> But tring to start it with /etc/ini.d/postgresql start fails
>>>>
>>>
>>> How did you install Postgres 12?
>>>
>>> Why are you using the file in init.d/ instead of pg_ctlcluster?
>>
>> Or indeed systemctl? :-)
>
> OK, here is the latets. If I do sudo systemctl start postgresql(at)12-main
>
> the instance starts and works fine.
>
> However, if I reboot the machine, the instance is not started.
>
> Thoughts as to what to check next, appreciated.
In /etc/postgresql/12/main there is file start.conf with:
# Automatic startup configuration
# auto: automatically start the cluster
# manual: manual startup with pg_ctlcluster/postgresql(at)(dot)service only
# disabled: refuse to start cluster
# See pg_createcluster(1) for details. When running from systemd,
# invoke 'systemctl daemon-reload' after editing this file.
auto
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-12-10 17:27:38 | Re: A question about upgrading on Debian/Ubuntu |
Previous Message | Adrian Klaver | 2019-12-10 17:03:44 | Re: server will not start (Debian) |