Thread: Logging in postgres

Logging in postgres

From
Antony Stace
Date:
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


Re: Logging in postgres

From
Markus Bertheau
Date:
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



Re: Logging in postgres

From
Antony Stace
Date:
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 Bertheau


Cheers

Tony


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


Re: Logging in postgres

From
Markus Bertheau
Date:
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
>
> Anything else I need to do?

add

debug_print_query = true

Markus Bertheau



Re: Logging in postgres

From
Antony Stace
Date:
>
> > 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 just added

debug_print_query

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?

Cheers

Tony
---------------------------------------------------------------------


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


Re: Logging in postgres

From
Markus Bertheau
Date:
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
> > >
> > > Anything else I need to do?
> >
> > add
> >
> > debug_print_query = true
> >
> I just added
>
> debug_print_query
>
> 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?

hmm, that is my postgresql.conf:

tcpip_socket = true
port = 5432
hostname_lookup = false
sort_mem = 128
shared_buffers = 12288 # min 16
fsync = off
deadlock_timeout = 10000
wal_buffers = 64 # min 4
wal_files = 4 # range 0-64
log_connections = true
log_timestamp = true
log_pid = true
debug_print_query = true
debug_print_rewritten = false
show_executor_stats = false
show_query_stats = false

what is different?

btw: I presume we talk about 7.1.x

Markus Bertheau


Re: Logging in postgres

From
Tom Lane
Date:
Antony Stace <s45652001@yahoo.com> 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 stderr but you've directed same
to /dev/null (or not where you are looking, anyway).

2. Postgres is logging to syslog, but you've configured syslog to
discard the output (or put it somewhere else than where you are
looking).

            regards, tom lane