Re: "No transaction in progress" warning

On Thu, May 7, 2009 at 11:29 AM, Conrad Lender <crlender(at)gmail(dot)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