Re: server will not start (Debian)

On Tue, Dec 10, 2019 at 06:48:23AM -0500, stan wrote:
> I just went to do soem work on our test/sandbox instance. I had upgraded
> this ssytem to V12 a few days agao. I found that it was not running:
> 
> Here is the last thing in the log:
> 
> 2019-12-06 14:16:06.149 EST [3764] LOG:  received fast shutdown request
> 2019-12-06 14:16:06.154 EST [3764] LOG:  aborting any active transactions
> 2019-12-06 14:16:06.160 EST [3764] LOG:  background worker "logical
> replication launcher" (PID 3771) exited with exit code 1
> 2019-12-06 14:16:06.162 EST [3766] LOG:  shutting down
> 2019-12-06 14:16:06.204 EST [3764] LOG:  database system is shut down
> 
> 
> This was in the logfile that was one rotation back. The current one is
> zero bytes:
> 
> pg_lsclsuters shows:
> 
> Ver Cluster Port Status Owner    Data directory              Log file
> 12  main    5432 down   postgres /var/lib/postgresql/12/main
> /var/log/postgresql/postgresql-12-main.log
> 
> systemctl status postgresql shows:
> 
> root@stantest:/var/log/postgresql# systemctl status postgresql
> ● postgresql.service - PostgreSQL RDBMS
>    Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor
>    prese
>   Active: active (exited) since Fri 2019-12-06 14:22:13 EST; 3 days ago
> Process: 371 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
> Process: 5555 ExecReload=/bin/true (code=exited,
> status=0/SUCCESS)
> Main PID: 371 (code=exited, status=0/SUCCESS)
> 
> Dec 10 06:41:19 stantest systemd[1]: Reloading PostgreSQL RDBMS.
> Dec 10 06:41:19 stantest systemd[1]: Reloaded PostgreSQL RDBMS.
> Warning: Journal has been rotated since unit was started. Log output is incomple
> 
> What do I need to do to get it started AND fix whatever caused this
> unexpected shutdown?
> 
> 
More info:

As user posgres I cna start the server with:

/usr/lib/postgresql/12/bin/postgres -D /var/lib/postgresql/12/main -c
config_file=/etc/postgresql/12/main/postgresql.conf

Then I can connect to it. But sysctl does not start the instance. 


I am also getting this error message:

/var/run/postgresql/12-main.pg_stat_tmp/global.tmp": No such file or
directory
2019-12-10 08:35:02.360 EST [786] LOG:  could not open temporary
statistics file "/var/run/postgresql/12-main.pg_stat_tmp/global.tmp": No
such file or directory

But if I create that directory manually I cna start the server,

As a reminder, this instance was recently upgarded from V11 to V12, if
thta is significant.



-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin