Thread

1. start

   H.J. Sanders <hjs@worldonline.nl> — 2004-05-03T19:36:52Z

   Hello list.
   
   
   I have difficulties starting the postmaster automatically at boot time
   (everything I tried is done by 'root').
   
   Can someone give me an example for LINUX (SUSE 8).
   
   Many thanks.
   
   
   Henk Sanders
   
   
   

2. Re: start

   Peter Eisentraut <peter_e@gmx.net> — 2004-05-03T19:56:03Z

   H.J. Sanders wrote:
   > I have difficulties starting the postmaster automatically at boot
   > time (everything I tried is done by 'root').
   >
   > Can someone give me an example for LINUX (SUSE 8).
   
   Maybe you would rather want to download the binary packages, which take 
   care of that.  RPMs for SuSE are available on the PostgreSQL mirrors in 
   the directory "binary".
   
   
   

3. Re: start

   scott.marlowe <scott.marlowe@ihs.com> — 2004-05-03T20:16:29Z

   On Mon, 3 May 2004, H.J. Sanders wrote:
   
   > 
   > Hello list.
   > 
   > 
   > I have difficulties starting the postmaster automatically at boot time
   > (everything I tried is done by 'root').
   > 
   > Can someone give me an example for LINUX (SUSE 8).
   
   Just FYI, this probably belongs on admin, but no biggie.
   
   I start my postgresql database with this line:
   
   su - postgres -c 'pg_ctl start | rotatelogs $PGDATA/pglog 86400 2>1&'
   
   If you have apache rotatelogs in the postgres user's path, you can start 
   the database as postgresql AND set the logs to be rotated every 24 hours 
   with this line.  If not, and you don't need to log the database's 
   notices and such, then just enter this:
   
   su - postgres -c 'pg_ctl start 2>1&'
   
   
   

4. Re: start

   Andrei Bintintan <klodoma@ar-sd.net> — 2004-05-04T14:20:51Z

   You say that you're running Suse 8.
   
   You can also start the process with that Yast.
   Start Yast2 -> System -> Runlevel Editor-> and then you can select the
   runlevel when you want that postgre starts. I start it at runlevel 3.
   If you installed postgre it manually you have a little work to do, probably
   you will have to make your own start script.
   In my situation(also manual installation)  I just copied the script which
   came with suse and edited it for my configuration... it worked for me.
   
   Good luck!
   
   
   ----- Original Message ----- 
   From: "H.J. Sanders" <hjs@worldonline.nl>
   To: <pgsql-sql@postgresql.org>
   Sent: Monday, May 03, 2004 10:36 PM
   Subject: [SQL] start
   
   
   > 
   > Hello list.
   > 
   > 
   > I have difficulties starting the postmaster automatically at boot time
   > (everything I tried is done by 'root').
   > 
   > Can someone give me an example for LINUX (SUSE 8).
   > 
   > Many thanks.
   > 
   > 
   > Henk Sanders
   > 
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 8: explain analyze is your friend