Re: "No transaction in progress" warning - Mailing list pgsql-general

From Scott Mead
Subject Re: "No transaction in progress" warning
Date
Msg-id d3ab2ec80905070840x193a2ea2r988699e0ce779514@mail.gmail.com
Whole thread Raw
In response to Re: "No transaction in progress" warning  (Conrad Lender <crlender@gmail.com>)
Responses Re: "No transaction in progress" warning  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thu, May 7, 2009 at 11:29 AM, Conrad Lender <crlender@gmail.com> wrote:

I'm beginning to feel incredibly dense now, but this actually brought my
original problem back. When I do specify log_filename and log_directory,
and restart Postgres, the test you suggested ('select 1/0;') shows up as
an error in the log file

/var/log/postgresql/postgresql-8.3-main.log.{timestamp}

When I leave both log_directory and log_filename commented out (my
original settings), then restart postgres, it creates the file

/var/log/postgresql/postgresql-8.3-main.log

This contains three lines about SSL certificates, but the warning from
'select 1/0' will instead be written to this file:

/var/lib/postgresql/8.3/main/pg_log/postgresql-2009-05-07_170932.log

So there are two log files :-|

How did you restart postgres?  I'm guessing that you're using a distribution provided package.  If you're using the /etc/init.d scripts from that package, it's likely that the startup script is redirecting stderr and that the system is configured to use syslog for the rest of the logging.



--Scott


pgsql-general by date:

Previous
From: Conrad Lender
Date:
Subject: Re: "No transaction in progress" warning
Next
From: Andrew Gould
Date:
Subject: Re: PgUS 501c3 Public Charity