Обсуждение: postmaster hangs

Поиск
Список
Период
Сортировка

postmaster hangs

От
"Mimi Wu"
Дата:
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
 
Then it hangs there forever. What should I do next? use C^ C to stop it?
 
Thanks for any advice in advance
 
Mimi

Re: postmaster hangs

От
Daniel Convissor
Дата:
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