Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41374=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Uxh9b-00021Q-BB
 for pgsql-admin@arkaria.postgresql.org; Fri, 12 Jul 2013 17:29:11 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41374=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Uxh9a-0001Eo-Po
 for pgsql-admin@arkaria.postgresql.org; Fri, 12 Jul 2013 17:29:10 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <wellsoliver@gmail.com>) id 1Uxh9Y-0001Cc-Gl
 for pgsql-admin@postgresql.org; Fri, 12 Jul 2013 17:29:08 +0000
Received: from mail-pd0-x232.google.com ([2607:f8b0:400e:c02::232])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <wellsoliver@gmail.com>) id 1Uxh9U-0004Fv-Mh
 for pgsql-admin@postgresql.org; Fri, 12 Jul 2013 17:29:07 +0000
Received: by mail-pd0-f178.google.com with SMTP id w11so8822230pde.37
 for <pgsql-admin@postgresql.org>; Fri, 12 Jul 2013 10:29:03 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=sender:content-type:mime-version:subject:from:in-reply-to:date:cc
 :message-id:references:to:x-mailer;
 bh=cP7xTbBUu3IqrrD/zOQawE4xNGBsBHspY+G46DwXXu0=;
 b=hY/r9M500VaiJtKfvvVxb6FYzpmUVFhpiJt6GEmGUktxeN30YfJgNBV6CzetBxcN6X
 lE+OIDF6MqXEJyrBeYXqE/FrFhon8dvVIGOktRMIuWcyxQsKRfoPhFlyH2OQH9kbT9c0
 TqwMTaKeXb7faXjaX35ncao2djKF9KXnqEgxPWeGa9EZJJHjVSPaqis52GV96mt2mb8G
 84qT4ydN5w9Z2QHrRe497mmWo+BpYd/2ZDvElvkYO/fIfG0zoJYE+5gvvnCpGDc3vekP
 BdoBWAGEVpyw/2xMxvn8qNyRovUUKNcyqWy6U/66i1GYZkzWl5PVNA2Zu1g7lGO63olt
 neXA==
X-Received: by 10.68.236.130 with SMTP id uu2mr43207052pbc.87.1373650143373;
 Fri, 12 Jul 2013 10:29:03 -0700 (PDT)
Received: from [192.168.1.102] (ip68-8-28-231.sd.sd.cox.net. [68.8.28.231])
 by mx.google.com with ESMTPSA id qu10sm46421999pbb.12.2013.07.12.10.29.01
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Fri, 12 Jul 2013 10:29:01 -0700 (PDT)
Content-Type: multipart/alternative;
 boundary="Apple-Mail=_C570C93B-5428-41D9-9CAB-BF047271941F"
Mime-Version: 1.0 (Mac OS X Mail 6.5 \(1508\))
Subject: Re: Couldn't start postgres, got no logging,
 ran postgres manually for info-- help?
From: Wells Oliver <wellsoliver@gmail.com>
In-Reply-To: <51DFCB17.5050905@2ndquadrant.it>
Date: Fri, 12 Jul 2013 10:29:00 -0700
Cc: pgsql-admin@postgresql.org
Message-Id: <58263C4A-0786-4FA1-9AA3-C176A9C0ED35@gmail.com>
References: 
 <CAOC+FBXTnv4rro4Z26ZtaG35gTqO9vviRgH937ubD1BL9d4ZaA@mail.gmail.com>
 <51DFCB17.5050905@2ndquadrant.it>
To: Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>
X-Mailer: Apple Mail (2.1508)
X-Pg-Spam-Score: 0.7 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


--Apple-Mail=_C570C93B-5428-41D9-9CAB-BF047271941F
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=iso-8859-1

Alright but what's odd to me is that it's a standard out of the box =
ubuntu configuration, meaning:

log_destination is 'stderr'
logging_collector is on
log_directory is /var/log/postgresql/
log_filename is postgresql-%Y-%m-%d_%H%M%S.log

When I ran pg_ctlcluster start, I only received "please check the log =
output", but there were no errors logged. There are definitely log items =
when the server was running normally.

When I ran postgres manually, I saw the permissions issue. My question =
then is where was this error sent when running pg_ctlcliuster, or why =
was it squashed? It would have been helpful to have that from the start.

--
Wells Oliver
wellsoliver@gmail.com




On Jul 12, 2013, at 2:23 AM, Giuseppe Broccolo =
<giuseppe.broccolo@2ndquadrant.it> wrote:

> Hi Oliver,
>=20
> Il 12/07/2013 04:07, Wells Oliver ha scritto:
>> I ran:
>>=20
>> pg_ctlcluster 9.1 main start
>>=20
>> Received:
>>=20
>> The PostgreSQL server failed to start. Please check the log output.
>>=20
>> But, hey, in /var/log/postgresql, there was absolutely no logging. =
Nothing. After some googling, I tried:
>>=20
>> usr/lib/postgresql/9.1/bin/postgres -D /data/postgresql/9.1/main -c =
config_file=3D/etc/postgresql/9.1/main/postgresql.conf=20
>>=20
>> =46rom the command line, which spit out to the terminal:
>>=20
>> 2013-07-12 02:04:05 GMT [30091]: [1-1] FATAL:  data directory =
"/data/postgresql/9.1/main" has group or world access
>>=20
>> OK, so where the heck did this error message go when I was running =
pg_ctlcluster? It would have saved me a lot of time.
>=20
> By default pg_ctlcluster script redirects postmaster's stderr into =
/var/log/postgresql/postgresql-9.1-main.log.
> This works only if log_destination is stderr and logging_collector is =
disabled, else the logs are stored where configured by log_destination, =
log_filename and log_directory in your postgresql.conf file.
> Advice is to look into your postgresql.conf how (and if) logging is =
configured.
>=20
> Regards,
> Giuseppe.
> --=20
> Giuseppe Broccolo - 2ndQuadrant Italy
> PostgreSQL Training, Services and Support
> giuseppe.broccolo@2ndQuadrant.it | www.2ndQuadrant.it


--Apple-Mail=_C570C93B-5428-41D9-9CAB-BF047271941F
Content-Transfer-Encoding: 7bit
Content-Type: text/html;
	charset=iso-8859-1

<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Alright but what's odd to me is that it's a standard out of the box ubuntu configuration, meaning:<div><br></div><div>log_destination is 'stderr'</div><div>logging_collector is on</div><div>log_directory is /var/log/postgresql/</div><div>log_filename is&nbsp;postgresql-%Y-%m-%d_%H%M%S.log</div><div><br></div><div>When I ran pg_ctlcluster start, I only received "please check the log output", but there were no errors logged. There are definitely log items when the server was running normally.</div><div><br></div><div>When I ran postgres manually, I saw the permissions issue. My question then is where was this error sent when running pg_ctlcliuster, or why was it squashed? It would have been helpful to have that from the start.</div><div><div apple-content-edited="true">
<br>--<br>Wells Oliver<br><a href="mailto:wellsoliver@gmail.com">wellsoliver@gmail.com</a><br><br><br><br>

</div>
<br><div><div>On Jul 12, 2013, at 2:23 AM, Giuseppe Broccolo &lt;<a href="mailto:giuseppe.broccolo@2ndquadrant.it">giuseppe.broccolo@2ndquadrant.it</a>&gt; wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
  
    <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type">
  
  <div bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">Hi Oliver,<br>
      <br>
      Il 12/07/2013 04:07, Wells Oliver ha scritto:<br>
    </div>
    <blockquote cite="mid:CAOC+FBXTnv4rro4Z26ZtaG35gTqO9vviRgH937ubD1BL9d4ZaA@mail.gmail.com" type="cite">
      <div dir="ltr">I ran:
        <div><br>
        </div>
        <div>pg_ctlcluster 9.1 main start</div>
        <div><br>
        </div>
        <div>Received:</div>
        <div><br>
        </div>
        <div>
          <div>The PostgreSQL server failed to start. Please check the
            log output.</div>
          <div><br>
          </div>
          <div>But, hey, in /var/log/postgresql, there was absolutely no
            logging. Nothing. After some googling, I tried:</div>
          <div><br>
          </div>
          <div>
            <div>usr/lib/postgresql/9.1/bin/postgres -D
              /data/postgresql/9.1/main -c
              config_file=/etc/postgresql/9.1/main/postgresql.conf&nbsp;</div>
          </div>
          <div><br>
          </div>
          <div>From the command line, which spit out to the terminal:</div>
          <div><br>
          </div>
          <div>
            <div>2013-07-12 02:04:05 GMT [30091]: [1-1] FATAL: &nbsp;data
              directory "/data/postgresql/9.1/main" has group or world
              access</div>
          </div>
          <div><br>
          </div>
          <div>OK, so where the heck did this error message go when I
            was running pg_ctlcluster? It would have saved me a lot of
            time.</div>
        </div>
      </div>
    </blockquote>
    <br>
    By default pg_ctlcluster script redirects postmaster's stderr into
    /var/log/postgresql/postgresql-9.1-main.log<big>.</big><br>
    This works only if log_destination is stderr and logging_collector
    is disabled, else the logs are stored where configured by
    log_destination, log_filename and log_directory in your
    postgresql.conf file.
    <p>Advice is to look into your postgresql.conf how (and if) logging
      is configured.</p><p>Regards,<br>
      Giuseppe.<br>
    </p>
    <pre class="moz-signature" cols="72">-- 
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
<a class="moz-txt-link-abbreviated" href="mailto:giuseppe.broccolo@2ndQuadrant.it">giuseppe.broccolo@2ndQuadrant.it</a> | <a class="moz-txt-link-abbreviated" href="http://www.2ndquadrant.it/">www.2ndQuadrant.it</a></pre>
  </div>

</blockquote></div><br></div></body></html>
--Apple-Mail=_C570C93B-5428-41D9-9CAB-BF047271941F--