Re: can't get pg_stat_statements to work - Mailing list pgsql-novice

From Tom Lane
Subject Re: can't get pg_stat_statements to work
Date
Msg-id 15624.1442689043@sss.pgh.pa.us
Whole thread Raw
In response to Re: can't get pg_stat_statements to work  (richard@xentu.com)
Responses Re: can't get pg_stat_statements to work  (richard@xentu.com)
List pgsql-novice
richard@xentu.com writes:
> Sorry, I was unclear in my description.
> In the normal course of events, log files are written in the format
> /var/lib/postgresql/8.4/main/pg_log/postgresql-2015-09-19_182328.log
> It's only when the server fails to start, as I described, that no such
> file is generated.

In that case, the error is happening before the server switches the
log destination away from its initial stderr.  You need to look at
the postmaster start script to see where it's sending stderr to
begin with.  (In Red Hat's scripts there's a fixed file used for such
early-startup output, but I don't know what Ubuntu does about it.)

Another idea would be to try launching the server by hand, ie just

    postmaster -D /path/to/data/directory

and see what happens.  With no redirection, the desired message should
just appear on your terminal.

            regards, tom lane


pgsql-novice by date:

Previous
From: richard@xentu.com
Date:
Subject: Re: can't get pg_stat_statements to work
Next
From: richard@xentu.com
Date:
Subject: Re: can't get pg_stat_statements to work