Обсуждение: 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