pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres log_destination question
2+ messages / 2 participants
[nested] [flat]
* postgres log_destination question
@ 2015-03-28 00:33 naveen kumar <mnaveendba2@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: naveen kumar @ 2015-03-28 00:33 UTC (permalink / raw)
To: pgsql-admin
Hello All,
I have configured postgresql on 2 machines. on both machines I have setup
log_destination = 'syslog' and log_directory='pg_log'. if check logs on
both machines, on one machine logs are moved to /var/log/pg_log and another
one logs are moved to syslog only.
and log_line_prefix is set to 'host=%r,user=%u,db=%d' but still some sqls
are logging with out prifix.
Can any one help me on this please..
Thanks & Regards,
M Naveen Kuamr,
PostgreSQL Database Administrator,
Mobile Number: +91 7755929449.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: postgres log_destination question
@ 2015-03-28 14:06 John Scalia <jayknowsunix@gmail.com>
parent: naveen kumar <mnaveendba2@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: John Scalia @ 2015-03-28 14:06 UTC (permalink / raw)
To: naveen kumar <mnaveendba2@gmail.com>; pgsql-admin
On 3/27/2015 8:33 PM, naveen kumar wrote:
> Hello All,
>
> I have configured postgresql on 2 machines. on both machines I have setup log_destination = 'syslog' and log_directory='pg_log'. if check logs on both machines, on one machine
> logs are moved to /var/log/pg_log and another one logs are moved to syslog only.
> and log_line_prefix is set to 'host=%r,user=%u,db=%d' but still some sqls are logging with out prifix.
>
> Can any one help me on this please..
>
> Thanks & Regards,
> M Naveen Kuamr,
> PostgreSQL Database Administrator,
> Mobile Number: +91 7755929449.
One thing that sticks out to me is "host=%r" should probably be "host=%h". not that I've checked what the %r stands for. What I'd do for the main problem, however, is check which
directory on each host is $PGDATA, as it sounds like one of your systems is looking for everything somewhere else and it could be reading a different postgresql.conf file.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-03-28 14:06 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-03-28 00:33 postgres log_destination question naveen kumar <mnaveendba2@gmail.com>
2015-03-28 14:06 ` John Scalia <jayknowsunix@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox