2024-06-07 13:34:15.468 IST [79895] LOG:  starting PostgreSQL 15.5 (Ubuntu 15.5-0ubuntu0.23.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 12.3.0-1ubuntu1~23.04) 12.3.0, 64-bit
2024-06-07 13:34:15.469 IST [79895] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2024-06-07 13:34:15.469 IST [79895] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-07 13:34:15.473 IST [79898] LOG:  database system was shut down at 2024-06-07 13:34:14 IST
2024-06-07 13:34:15.476 IST [79895] LOG:  database system is ready to accept connections
2024-06-07 13:34:17.639 IST [79915] FATAL:  lock file "postmaster.pid" already exists
2024-06-07 13:34:17.639 IST [79915] HINT:  Is another postmaster (PID 79895) running in data directory "/var/lib/postgresql/15/main"?
2024-06-07 13:39:15.571 IST [79896] LOG:  checkpoint starting: time
2024-06-07 13:39:19.837 IST [79896] LOG:  checkpoint complete: wrote 45 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.213 s, sync=0.013 s, total=4.267 s; sync files=11, longest=0.012 s, average=0.002 s; distance=262 kB, estimate=262 kB
2024-06-07 13:39:42.021 IST [81517] FATAL:  lock file "postmaster.pid" already exists
2024-06-07 13:39:42.021 IST [81517] HINT:  Is another postmaster (PID 79895) running in data directory "/var/lib/postgresql/15/main"?
2024-06-07 13:41:33.234 IST [79895] LOG:  received fast shutdown request
2024-06-07 13:41:33.235 IST [79895] LOG:  aborting any active transactions
2024-06-07 13:41:33.238 IST [79895] LOG:  background worker "logical replication launcher" (PID 79901) exited with exit code 1
2024-06-07 13:41:33.238 IST [79896] LOG:  shutting down
2024-06-07 13:41:33.239 IST [79896] LOG:  checkpoint starting: shutdown immediate
2024-06-07 13:41:33.242 IST [79896] LOG:  checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=236 kB
2024-06-07 13:41:33.245 IST [79895] LOG:  database system is shut down
2024-06-07 13:41:39.437 IST [81613] LOG:  starting PostgreSQL 15.5 (Ubuntu 15.5-0ubuntu0.23.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 12.3.0-1ubuntu1~23.04) 12.3.0, 64-bit
2024-06-07 13:41:39.437 IST [81613] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2024-06-07 13:41:39.438 IST [81613] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-07 13:41:39.442 IST [81616] LOG:  database system was shut down at 2024-06-07 13:41:33 IST
2024-06-07 13:41:39.447 IST [81613] LOG:  database system is ready to accept connections
2024-06-07 13:41:41.637 IST [81633] FATAL:  lock file "postmaster.pid" already exists
2024-06-07 13:41:41.637 IST [81633] HINT:  Is another postmaster (PID 81613) running in data directory "/var/lib/postgresql/15/main"?
2024-06-07 13:43:05.389 IST [81613] LOG:  received smart shutdown request
2024-06-07 13:43:05.394 IST [81613] LOG:  background worker "logical replication launcher" (PID 81619) exited with exit code 1
2024-06-07 13:43:05.394 IST [81614] LOG:  shutting down
2024-06-07 13:43:05.395 IST [81614] LOG:  checkpoint starting: shutdown immediate
2024-06-07 13:43:05.401 IST [81614] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.007 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB
2024-06-07 13:43:05.406 IST [81613] LOG:  database system is shut down
2024-06-07 13:44:09.004 IST [81701] LOG:  starting PostgreSQL 15.5 (Ubuntu 15.5-0ubuntu0.23.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 12.3.0-1ubuntu1~23.04) 12.3.0, 64-bit
2024-06-07 13:44:09.004 IST [81701] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2024-06-07 13:44:09.005 IST [81701] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-07 13:44:09.008 IST [81704] LOG:  database system was shut down at 2024-06-07 13:43:05 IST
2024-06-07 13:44:09.012 IST [81701] LOG:  database system is ready to accept connections
2024-06-07 13:44:11.195 IST [81721] FATAL:  lock file "postmaster.pid" already exists
2024-06-07 13:44:11.195 IST [81721] HINT:  Is another postmaster (PID 81701) running in data directory "/var/lib/postgresql/15/main"?
2024-06-07 13:46:37.158 IST [81767] FATAL:  pre-existing shared memory block (key 4614192, ID 393250) is still in use
2024-06-07 13:46:37.158 IST [81767] HINT:  Terminate any old server processes associated with data directory "/var/lib/postgresql/15/main".
2024-06-07 13:46:37.158 IST [81767] LOG:  database system is shut down
2024-06-07 13:47:09.181 IST [81701] LOG:  could not open file "postmaster.pid": No such file or directory
2024-06-07 13:47:09.181 IST [81701] LOG:  performing immediate shutdown because data directory lock file is invalid
2024-06-07 13:47:09.181 IST [81701] LOG:  received immediate shutdown request
2024-06-07 13:47:09.181 IST [81701] LOG:  could not open file "postmaster.pid": No such file or directory
2024-06-07 13:47:09.185 IST [81701] LOG:  database system is shut down
root@kartik-81WE:~#