Обсуждение: postmaster hangs
Hi,
I issued command to start up postmaster and got following logs:
$ postmaster -D /usr/local/pgsql/data
LOG: shmdt(0xeb0000) failed: Invalid argument
LOG: database system was shut down at 2003-12-03 11:40:26 CST
LOG: checkpoint record is at 0/9DE830
LOG: redo record is at 0/9DE830; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 534; next OID: 17142
LOG: database system is ready
LOG: shmdt(0xeb0000) failed: Invalid argument
LOG: database system was shut down at 2003-12-03 11:40:26 CST
LOG: checkpoint record is at 0/9DE830
LOG: redo record is at 0/9DE830; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 534; next OID: 17142
LOG: database system is ready
Then it hangs there forever. What should I do next? use C^ C to stop it?
Thanks for any advice in advance
Mimi
On Wed, Dec 03, 2003 at 01:57:46PM -0600, Mimi Wu wrote: > > $ postmaster -D /usr/local/pgsql/data ... snip ... > LOG: database system is ready > > Then it hangs there forever. What should I do next? use C^ C to stop it? Add a "&" at the end of the command to get it to run in the background. Example: $ postmaster -D /usr/local/pgsql/data & Part of the reason why pg_ctl is nicer. Note to maintainers: this should be added to the FAQ_MSWIN and *README files. --Dan -- FREE scripts that make web and database programming easier http://www.analysisandsolutions.com/software/ T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7th Ave #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409