Antony Stace <[EMAIL PROTECTED]> writes:
> restarted postgres and then did a few queries in the database. But nothing
> is being logged in /var/log/postgresql. Any ideas what else might be wrong?
If you're not seeing any log output at all, then either:
1. Postgres is logging to postmaster's st
On Sat, 2002-01-26 at 16:51, Antony Stace wrote:
>
> >
> > > log_connections = yes
> > > log_timestamp = true
> > > log_pid = true
> > > syslog = 2
> > >
> > > to my postgresql.conf file but it dosent seem to have caused any logging to
>occur in
> > >
> > > /var/log/postgresql
> > >
> > > An
>
> > log_connections = yes
> > log_timestamp = true
> > log_pid = true
> > syslog = 2
> >
> > to my postgresql.conf file but it dosent seem to have caused any logging to occur
>in
> >
> > /var/log/postgresql
> >
> > Anything else I need to do?
>
> add
>
> debug_print_query = true
>
I jus
On Sat, 2002-01-26 at 16:12, Antony Stace wrote:
> Thanks for the reply Markus. I have added
>
> log_connections = yes
> log_timestamp = true
> log_pid = true
> syslog = 2
>
> to my postgresql.conf file but it dosent seem to have caused any logging to occur in
>
> /var/log/postgresql
>
> Any
Thanks for the reply Markus. I have added
log_connections = yes
log_timestamp = true
log_pid = true
syslog = 2
to my postgresql.conf file but it dosent seem to have caused any logging to occur in
/var/log/postgresql
Anything else I need to do?
> tweak your postgresql.conf
>
> Markus Berthe
On Sat, 2002-01-26 at 13:30, Antony Stace wrote:
>
> Hi Folks
>
> I want to log all of the inserts and delete that occur in a postgres database.
>Whats the easiest way to do this?
tweak your postgresql.conf
Markus Bertheau
---(end of broadcast)
Hi Folks
I want to log all of the inserts and delete that occur in a postgres database. Whats
the easiest way to do this?
--
Cheers
Tony
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
