Message-ID: <51DFCB17.5050905@2ndquadrant.it>
Date: Fri, 12 Jul 2013 11:23:35 +0200
From: Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130623 Thunderbird/17.0.7
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Couldn't start postgres, got no logging, ran postgres
 manually for info-- help?
References: 
 <CAOC+FBXTnv4rro4Z26ZtaG35gTqO9vviRgH937ubD1BL9d4ZaA@mail.gmail.com>
In-Reply-To: 
 <CAOC+FBXTnv4rro4Z26ZtaG35gTqO9vviRgH937ubD1BL9d4ZaA@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------070902060101060606050509"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------070902060101060606050509
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi Oliver,

Il 12/07/2013 04:07, Wells Oliver ha scritto:
> I ran:
>
> pg_ctlcluster 9.1 main start
>
> Received:
>
> The PostgreSQL server failed to start. Please check the log output.
>
> But, hey, in /var/log/postgresql, there was absolutely no logging. 
> Nothing. After some googling, I tried:
>
> usr/lib/postgresql/9.1/bin/postgres -D /data/postgresql/9.1/main -c 
> config_file=/etc/postgresql/9.1/main/postgresql.conf
>
> From the command line, which spit out to the terminal:
>
> 2013-07-12 02:04:05 GMT [30091]: [1-1] FATAL:  data directory 
> "/data/postgresql/9.1/main" has group or world access
>
> 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.

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.

Regards,
Giuseppe.

-- 
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
giuseppe.broccolo@2ndQuadrant.it | www.2ndQuadrant.it


--------------070902060101060606050509
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body 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>
  </body>
</html>

--------------070902060101060606050509--