Re: [ADMIN] postmaster restart on a different dataDir

2007-08-14 Thread Medi Montaseri
Actually I found the answerpg_ctl supports a -w switch which waits for the start operation to complete. Decibel...without -w, pg_ctl will return immediately before postmaster is fully operational. If you don't believe me start the engine and try to connect to it right away with pgsql(1)...

[ADMIN] postmaster restart on a different dataDir

2007-08-13 Thread Medi Montaseri
Hi, I am trying to measure startup time of postmaster. Say I have postmaster running on -D /tmp/d1 and would like to restart it on -D /tmp/d2. If I just say time pg_ctl restart -D /tmp/d2 it will not produce an accurate result because pg_ctl will start postmaster in the background and return