Re: strange message on console
On 16 Nov 2000, Marco Maggesi wrote:
> I have a DS10 with debian potato. Each morning I find
> plenty of this strange messages on the console:
>
> DEBUG: --Relation pg_tables--
> DEBUG: Pages 0: Changed 0, Reapped 0, Empty 0, New 0; Tup 0: Vac 0,
> Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using:
> Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec.
> DEBUG: --Relation pg_indexes--
> DEBUG: Pages 0: Changed 0, Reapped 0, Empty 0, New 0; Tup 0: Vac 0,
> Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using:
> Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec.
>
> No one of this messages is registered in the log files
> `/var/log/*'. Everything seems to work perfectly but I
> would like to understand what's going on. Any help
> appreciated. Thanks
It's just a standard debug dump. Seems that the default configuration of
PostgreSQL is to dump these to the console for some reason.
IIRC, you can edit /etc/postgresql/postmaster.init and change the PGDEBUG
option (or is it PGECHO)...either way, one of them turned these
notifications off on my machine. Of course, restart the daemon after you
change it.
If this doesn't work, search the list archives about it. We had a
discussion about it about 6-8 months ago.
C
Reply to: