X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id AC6E69DC827 for ; Fri, 30 Dec 2005 10:19:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67670-02 for ; Fri, 30 Dec 2005 10:19:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svana.org (svana.org [203.20.62.76]) by postgresql.org (Postfix) with ESMTP id 49EC19DC826 for ; Fri, 30 Dec 2005 10:19:17 -0400 (AST) Received: from kleptog by svana.org with local (Exim 3.35 #1 (Debian)) id 1EsL67-0004CL-00; Sat, 31 Dec 2005 01:19:11 +1100 Date: Fri, 30 Dec 2005 15:19:11 +0100 From: Martijn van Oosterhout To: "surabhi.ahuja" Cc: pgsql-general@postgresql.org Subject: Re: a few questions Message-ID: <20051230141911.GC15410@svana.org> Reply-To: Martijn van Oosterhout Mail-Followup-To: "surabhi.ahuja" , pgsql-general@postgresql.org References: <967CFC4343BF2A4DAFACD026D33DC85118ECA4@jal.iiitb.ac.in> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="1ccMZA6j1vT5UqiK" Content-Disposition: inline In-Reply-To: <967CFC4343BF2A4DAFACD026D33DC85118ECA4@jal.iiitb.ac.in> User-Agent: Mutt/1.3.28i X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6 X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522 48A7 6394 F08A 0DC6 7BE6 X-PGP-Key-URL: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.085 required=5 tests=[AWL=0.085] X-Spam-Score: 0.085 X-Spam-Level: X-Archive-Number: 200512/1335 X-Sequence-Number: 88898 --1ccMZA6j1vT5UqiK Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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 > =20 > do u mean that for each connection there is a "postmaster" process? and w= hat 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, --=20 Martijn van Oosterhout 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. --1ccMZA6j1vT5UqiK Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQFDtUHeIB7bNG8LQkwRAikiAKCPV/I+RHbveIpJuXDi637AdMoCCACeNxaS m3qmSlKx3gx/Ng+ekNBZnCQ= =7TGu -----END PGP SIGNATURE----- --1ccMZA6j1vT5UqiK--