Can not stop postgres 8.2 process on Solaris 10

Neng Titie

11/8/22, 3:00 PM

I have difficulty to stop postgres process in solaris 10 prior to upgrade the version. The process keep coming back even I kill with -9. I've done pg_ctl stop -W -D /location/to/data/ -m immediate but shutdown process keep failing.

From log:

LOG:  database system was interrupted at 2021-07-08 20:00:35 WIT
LOG:  checkpoint record is at 21/59607654
LOG:  redo record is at 21/59607654; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 0/127808448; next OID: 1355215
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  record with zero length at 21/5960769C
LOG:  redo is not required
LOG:  database system is ready
LOG:  background writer process (PID 27107) was terminated by signal 9
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
LOG:  received smart shutdown request
LOG:  database system was interrupted at 2021-07-08 21:47:51 WIT
LOG:  checkpoint record is at 21/5960769C
LOG:  redo record is at 21/5960769C; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 0/127808448; next OID: 1355215
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  record with zero length at 21/596076E4
LOG:  redo is not required
LOG:  database system is ready
LOG:  shutting down
LOG:  database system is shut down
LOG:  database system was shut down at 2021-07-08 21:48:09 WIT
LOG:  checkpoint record is at 21/5960772C
LOG:  redo record is at 21/5960772C; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 0/127808448; next OID: 1355215
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system is ready

It seems have autostart process but I can't find it.

0 + 1

postgresql

solaris

solaris-10

Andrew Henle

11/8/22, 4:01 PM

Have you checked if the PostgreSQL server is run under an SMF service?

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Can not stop postgres 8.2 process on Solaris 10

TH: ไม่สามารถหยุดกระบวนการ postgres 8.2 บน Solaris 10

RO: Nu se poate opri procesul postgres 8.2 pe Solaris 10

RU: Не удается остановить процесс postgres 8.2 на Solaris 10

VI: Không thể dừng quá trình postgres 8.2 trên Solaris 10

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.