"Interrupt requested" in postgresql-DAY.log

From: Louis Battuello <louis(dot)battuello(at)etasseo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: "Interrupt requested" in postgresql-DAY.log
Date: 2014-05-27 14:42:55
Message-ID: 609BD025-49CB-4DA8-AC70-9DE4C1AC6B76@etasseo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a PostgreSQL 9.3.4 database running on CentOS 6 with PostGIS 2.1.2. Each night, I run a cron job to dump (pg_dump) a few schemas for development snapshots. Everything runs without error.

However, it seems that the dump process consistently results in a single line in the postgresql-*.log file. Oddly enough, this entry seems to ignore the log_line_prefix configuration parameter.

postgres(at)db:/var/lib/pgsql/9.3/data $ cat pg_log/postgresql-Fri.log
Interrupt requested
postgres(at)db:/var/lib/pgsql/9.3/data $ grep log_line_prefix postgresql.conf
log_line_prefix = '< %t > ' # special values:
postgres(at)db:/var/lib/pgsql/9.3/data $ psql
psql (9.3.4)
Type "help" for help.

postgres=# show log_line_prefix;
log_line_prefix
-----------------
< %t >
(1 row)

postgres=# \q

Any ideas where this could be coming from and why it isn’t prefixed?

Thanks,
Louis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message saqibrafique 2014-05-27 14:47:37 Conversion from CHAR HEX
Previous Message Adrian Klaver 2014-05-27 14:40:10 Re: pg_upgrade from 8.3 to 9.1 and Flag --disable-integer-datetimes