X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A38ACD1EDFC for ; Mon, 3 May 2004 17:19:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 30191-01 for ; Mon, 3 May 2004 17:18:57 -0300 (ADT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id 73F8DD1EFA0 for ; Mon, 3 May 2004 17:18:51 -0300 (ADT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id i43KIVBO020347; Mon, 3 May 2004 14:18:32 -0600 (MDT) Date: Mon, 3 May 2004 14:16:29 -0600 (MDT) From: "scott.marlowe" To: "H.J. Sanders" Cc: Subject: Re: start In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-IHS-MailScanner-Envelope-Sender: scott.marlowe@ihs.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/19 X-Sequence-Number: 17733 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&'