Received: from lh00.opsion.fr (lh00.opsion.fr [212.73.208.226]) by postgresql.org (8.11.3/8.11.4) with SMTP id f8F13n799098 for ; Fri, 14 Sep 2001 21:03:49 -0400 (EDT) (envelope-from cnliou@eurosport.com) Received: from 10.1.1.8 [10.1.1.8] by lh00.opsion.fr; Sat, 15 Sep 2001 00:54:58 GMT Send-By: 203.66.130.112 with Mozilla/4.78 [en] (Win95; U) To: Subject: Re: need help From: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Date: Sat, 15 Sep 2001 00:54:58 GMT Message-id: <200109150054.3ad7@lh00.opsion.fr> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f8F13n799099 X-Archive-Number: 200109/502 X-Sequence-Number: 15225 > Once we start a Postmaster process, will it keep running forever? It will if you run it in background like postmaste -i -D /home/mydir/pgsql-database-dir & > How can we restart/stop??(the commands???) The preferred command might be pg_ctl that comes along with postgresql distribution: pg_ctl start pg_ctl stop killing the postmaster process (kill ) also works although this approach is not recommended. > Also, should we start the Postmaster only as the "postgres" superuser??? I would say this is a management issue and it is you who decide whether to start postmaster by postgres or not. I have not seen in the document saying that this is the only way to go. > Is it possible to have users for postgres database also....like in linux....we have users? Yes. you can define users somewhere. The document already explains. CN CN -------------------------------------------------------- You too can have your own email address from Eurosport. http://www.eurosport.com