We are using PostgreSQL about two years beginning from version 7.0.
I have one question about starting postmaster:
Is there way to detach it from the controlling terminal under FreeBSD?
My situation: I start postmaster manually:
su pgsql -c "/usr/local/pgsql/bin/pg_ctl
-D /usr/local/pgsql/data -l /usr/local/pgsql/log/pgsql.log start"
Log:
[1] LOG: database system was shut down at 2003-11-18 08:28:48 MSK
[2] LOG: checkpoint record is at 2/781889D0
[3] LOG: redo record is at 2/781889D0; undo record is at 0/0; shutdown TRUE
[4] LOG: next transaction id: 45635; next oid: 32885093
[5] LOG: database system is ready
and I see:
9655 p1 S+ 0:00,01 /usr/local/pgsql/bin/postmaster (postgres)
9657 p1 S+ 0:00,00 postmaster: stats buffer process (postgres)
9658 p1 S+ 0:00,00 postmaster: stats collector process (postgres)
It is attached to console p1. So when I press Ctrl+C in this console
postmaster writes and exits:
Log:
[1] LOG: fast shutdown request
[2] LOG: shutting down
[3] LOG: database system is shut down
When I reload server postmaster starts without any controlling terminal
and I can press Ctrl+C in any console I want:
178 con- I+ 0:00,16 /usr/local/pgsql/bin/postmaster (postgres)
180 con- I+ 0:00,00 postmaster: stats buffer process (postgres)
181 con- I+ 0:00,00 postmaster: stats collector process (postgres)
So I repeat my question:
Is there way to detach it from the controlling terminal under FreeBSD?
--
Best regards Andrey Feofilactovich.