Hello,
In my log files I have an error that occurs frequently :
FATAL: could not read from statistics collector pipe
and
FATAL: could not write to statistics collector pipe: No connection
could be made because the target machine actively refused it.
The server release is 8.0.3 and is running o
Hello everybody !
I am coming from the (expensive) "Oracle World" and I am a newbie in
PG administration. I am currently working on backup concerns... I am
using pg_dump and I have not encountered any problems but I have some
questions about the internal management of data consistency in PG
server
Hello,
An autovacuum deamon has been installed as a Windows service during
the setup of my PG 8.0.3 server on WinXP. I am surprised because I
believed that autovacuum was only available in 8.1 server. There is
no autovacuum_XXX parameters in postgresql.conf... How can I be sure
that autovacuum is
Hello,
I would like to track (timestamp and error number) in the database or
in text files the exceptions that occur in my PL/pgSQL functions.
1. How can I retrieve the SQLCODE in a 8.0.3 PG server ?
2. How can I trace the exception in a table although an implicit
rollback is done when a exceptio
Hello,
Having freshly installed a PG database (8.0.3), I have difficulties in
tracing exceptions in my PL/pgSQL functions. All my functions
implement a BEGIN-EXCEPTION-END block in which exceptions must be
traced :
BEGIN
-- Some stuff
EXCEPTION
WHEN OTHERS THEN
-- trace
END;
I would l
