On Fri, Dec 30, 2005 at 06:21:28PM +0530, surabhi.ahuja wrote: > I am working with PostgerSQL 8.0.0. > where can i find the startup scripts for the same. Well, it's been in contrib/strat-scripts since 8.0.0 so you should find it there. > One more thing, > I could not understand this: > number of processes is going to be at least 3+number of connections > > do u mean that for each connection there is a "postmaster" process? and what are those 3 processes? > actually the ppl who use the application often use kill -9 postmaster. in such a case the pid file still remains. One postmaster, 2 for the stats collector and possibly 1 for the autovacuum daemon. Plus one for each connection to the database. People shouldn't use kill -9 on the postmaster, they should use the normal signals, or just "pg_ctl stop". Or if you use a startup script, /etc/init.d/postgresql start/stop. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment:
pgpm2RJ68AH8u.pgp
Description: PGP signature
