Re: server will not start (Debian)

On 12/10/19 8:24 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@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?
> 
> sudo apt-get install pointed at:
> 
> deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
> 
>>>
>>> Why are you using the file in init.d/ instead of pg_ctlcluster?
>>
>> Or indeed systemctl? :-)
> 
> I tried that also. did not remeber
> 
> also:
> 
> postgres@ica-db:~$ pg_ctlcluster 12 main start
> Warning: the cluster will not be running as a systemd service. Consider
> using systemctl:
>    sudo systemctl start postgresql@12-main
>    Cluster is already running.

You need to do the above as root:

aklaver@arkansas:~$ pg_lsclusters
Ver Cluster Port Status Owner    Data directory              Log file
11  main    5431 down   postgres /var/lib/postgresql/11/main 
/var/log/postgresql/postgresql-11-main.log
12  main    5432 online postgres /var/lib/postgresql/12/main 
/var/log/postgresql/postgresql-12-main.log


aklaver@arkansas:~$ pg_ctlcluster 11 main start
Warning: the cluster will not be running as a systemd service. Consider 
using systemctl:
   sudo systemctl start postgresql@11-main
Error: You must run this program as the cluster owner (postgres) or root

aklaver@arkansas:~$ sudo pg_ctlcluster 11 main start
[sudo] password for aklaver:

aklaver@arkansas:~$ pg_lsclusters
Ver Cluster Port Status Owner    Data directory              Log file
11  main    5431 online postgres /var/lib/postgresql/11/main 
/var/log/postgresql/postgresql-11-main.log
12  main    5432 online postgres /var/lib/postgresql/12/main 
/var/log/postgresql/postgresql-12-main.log

Also the cluster is already running.
To confirm what you have running do:

ps ax | grep post

> 
>>
>> Ray.
>>
>> -- 
>> Raymond O'Donnell // Galway // Ireland
>> ray@rodonnell.ie
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com