Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 33CC29FB52D for ; Mon, 22 Jan 2007 12:18:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 69050-07 for ; Mon, 22 Jan 2007 12:18:30 -0400 (AST) X-Greylist: delayed 04:58:19.471471 by SQLgrey-1.7.4 Received: from smtp19.orange.fr (smtp19.orange.fr [80.12.242.1]) by postgresql.org (Postfix) with ESMTP id A7B7F9FB532 for ; Mon, 22 Jan 2007 12:18:30 -0400 (AST) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf1928.orange.fr (SMTP Server) with ESMTP id 8EFA51C000A7; Mon, 22 Jan 2007 17:18:29 +0100 (CET) Received: from ALEX (ATuileries-153-1-66-100.w83-202.abo.wanadoo.fr [83.202.33.100]) by mwinf1928.orange.fr (SMTP Server) with ESMTP id 5942E1C00090; Mon, 22 Jan 2007 17:18:29 +0100 (CET) X-ME-UUID: 20070122161829365.5942E1C00090@mwinf1928.orange.fr From: "Alexandre Becquereau" To: "'Tom Lane'" Cc: References: <000001c73e17$47369d80$0a01a8c0@ALEX> <18805.1169482227@sss.pgh.pa.us> Subject: Re: Startup problem Date: Mon, 22 Jan 2007 17:18:28 +0100 Message-ID: <007801c73e40$f3ddfff0$0a01a8c0@ALEX> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 11 Thread-Index: Acc+P9m5UvaLHXgISeaUN1m7yCmYqwAAM9Pw X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 In-Reply-To: <18805.1169482227@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: X-Archive-Number: 200701/198 X-Sequence-Number: 24354 Thank you, i replaced the su command by runuser and everything works perfectly now! Regards, Alexandre BECQUEREAU -- SafeLogic www.safelogic.com www.pgeep.com -----Message d'origine----- De : Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 Envoy=E9 : lundi 22 janvier 2007 17:10 =C0 : Alexandre Becquereau Cc : pgsql-admin@postgresql.org Objet : Re: [ADMIN] Startup problem=20 "Alexandre Becquereau" writes: > I have a problem running Postgres at startup. I use the=20 > start-scripts/linux script in /etc/rc.local. The one in our contrib/? That's pretty old, crufty, and unmaintained. The one most people actually use on RPM-based systems is the one that = comes with our RPM distribution ... is there a reason you're not using the = RPM? Anyway I would guess the problem comes from the fact that the contrib = script uses "su". The RPM script doesn't: # For SELinux we need to use 'runuser' not 'su' if [ -x /sbin/runuser ] then SU=3Drunuser else SU=3Dsu fi and eventually $SU -l postgres -c "$PGENGINE/postmaster -p '$PGPORT' -D '$PGDATA' ${PGOPTS} &" >> "$PGLOG" 2>&1 < /dev/null but you really ought to adopt the whole script not just that one bit. > I previously used a 7.6 version on Fedora Core 3 and there was no=20 > problem launching it on boot. I believe FC3 didn't have SELinux security ... it certainly didn't have = it enabled by default. regards, tom lane