pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLog file Query
3+ messages / 2 participants
[nested] [flat]
* Log file Query
@ 2005-09-13 06:45 Yogvinder Singh <yogvinder@newgen.co.in>
0 siblings, 1 reply; 3+ messages in thread
From: Yogvinder Singh @ 2005-09-13 06:45 UTC (permalink / raw)
To: pgsql-admin
hi ppl,
I am using postgres7.3 version. I am unable to find any log.
all the files
1) /usr/local/pgsql/data/serverlog
2) /var/log/pgsql
etc are empty
pg_xlog and pg_clog directory files dont seem to be meaningful.
i tried
log_connections = true
log_pid = true
log_statement = true
log_duration = true
log_timestamp = true
log_min_error_statement = debug5
but where this log_statement log will go...
Moreover where databaseserver log is made
i m starting postgres as:
service postgresql start
i mean when database server is improperly shutdown or some other error condition etc must be logged somewhere
is it in the serverlog file.??
Moreover i want to log all the steps that postmaster makes at startup...
can anyone help me on this
^ permalink raw reply [nested|flat] 3+ messages in thread
* Log file Query
@ 2005-09-13 09:21 Yogvinder Singh <yogvinder@newgen.co.in>
0 siblings, 0 replies; 3+ messages in thread
From: Yogvinder Singh @ 2005-09-13 09:21 UTC (permalink / raw)
To: pgsql-admin
well there is nothing in the /var/log
or /var/lib/pgsql/data
any explanation
or how can i enable logging
i am using postgres7.3 on whitebox linux 4
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Log file Query
@ 2005-09-13 15:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: Yogvinder Singh <yogvinder@newgen.co.in>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2005-09-13 15:10 UTC (permalink / raw)
To: Yogvinder Singh <yogvinder@newgen.co.in>; +Cc: pgsql-admin
"Yogvinder Singh" <yogvinder@newgen.co.in> writes:
> I am using postgres7.3 version. I am unable to find any log. =
In 7.3 your best bet is to log via syslog. Set syslog to 2 in
postgresql.conf and adjust the other settings if needed, then make sure
your syslog daemon is configured to put the messages where you want
them.
What is probably happening right now is that the postmaster is set to
send log messages to stderr but the start script you are using is
redirecting postmaster stderr to /dev/null. While you could modify
the start script, I don't recommend it for production purposes because
7.3 doesn't have any support for rotating log files that way. syslog
is the only production-grade logging approach in that version.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-09-13 15:10 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-13 06:45 Log file Query Yogvinder Singh <yogvinder@newgen.co.in>
2005-09-13 15:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-09-13 09:21 Log file Query Yogvinder Singh <yogvinder@newgen.co.in>
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