Home > mailing lists

Postgresql-11 confusing situtation - Mailing list pgsql-general

From	Domen Šetar
Subject	Postgresql-11 confusing situtation
Date	June 5, 2019 15:46:44
Msg-id	1712870b1d2a457f975645383a2e0f9a@izum.si Whole thread Raw
Responses	Re: Postgresql-11 confusing situtation Re: Postgresql-11 confusing situtation Re: Postgresql-11 confusing situtation
List	pgsql-general

Tree view

Hi,

I’m using Postgresql 11.3 on Centos 7.6.18.10 server.

I have very unusual issue which I don’t know if it is OK:

I have running postgresql server with default instance:

[root@pgpmaster ~]# systemctl status postgresql-11

● postgresql-11.service - PostgreSQL 11 database server

Loaded: loaded (/usr/lib/systemd/system/postgresql-11.service; enabled; vendor preset: disabled)

Active: active (running) since Wed 2019-06-05 14:37:21 CEST; 49s ago

Docs: https://www.postgresql.org/docs/11/static/

Process: 3552 ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)

Main PID: 3576 (postmaster)

Tasks: 9

CGroup: /system.slice/postgresql-11.service

├─3576 /usr/pgsql-11/bin/postmaster -D /var/lib/pgsql/11/data/

├─3609 postgres: logger

├─3621 postgres: checkpointer

├─3622 postgres: background writer

├─3623 postgres: walwriter

├─3624 postgres: autovacuum launcher

├─3625 postgres: archiver

├─3626 postgres: stats collector

└─3627 postgres: logical replication launcher

Jun 05 14:37:20 pgpmaster.localhost systemd[1]: Starting PostgreSQL 11 database server...

Jun 05 14:37:20 pgpmaster.localhost postmaster[3576]: 2019-06-05 14:37:20.923 CEST [3576] LOG: listening on IPv4 address "0.0.0.0", port 5432

Jun 05 14:37:20 pgpmaster.localhost postmaster[3576]: 2019-06-05 14:37:20.924 CEST [3576] LOG: listening on IPv6 address "::", port 5432

Jun 05 14:37:20 pgpmaster.localhost postmaster[3576]: 2019-06-05 14:37:20.928 CEST [3576] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"

Jun 05 14:37:21 pgpmaster.localhost postmaster[3576]: 2019-06-05 14:37:21.026 CEST [3576] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"

Jun 05 14:37:21 pgpmaster.localhost postmaster[3576]: 2019-06-05 14:37:21.123 CEST [3576] LOG: redirecting log output to logging collector process

Jun 05 14:37:21 pgpmaster.localhost postmaster[3576]: 2019-06-05 14:37:21.123 CEST [3576] HINT: Future log output will appear in directory "log".

Jun 05 14:37:21 pgpmaster.localhost systemd[1]: Started PostgreSQL 11 database server.

If I restart it using systemctl restart postgresql-11 command, everything is OK, but if I use commands:

# pg_ctl -D /var/lib/pgsql/11/data/ -m immediate stop

# pg_ctl -D /var/lib/pgsql/11/data/ -m immediate start

Then I get following situtation:

# systemctl status postgresql-11

● postgresql-11.service - PostgreSQL 11 database server

Loaded: loaded (/usr/lib/systemd/system/postgresql-11.service; enabled; vendor preset: disabled)

Active: inactive (dead) since Wed 2019-06-05 14:41:32 CEST; 1min 40s ago

Docs: https://www.postgresql.org/docs/11/static/

Process: 3576 ExecStart=/usr/pgsql-11/bin/postmaster -D ${PGDATA} (code=exited, status=0/SUCCESS)

Process: 3552 ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)

Main PID: 3576 (code=exited, status=0/SUCCESS)