Re: Strange messages...
On Wed, 30 Aug 2000, Ashley Clark wrote: > They are courtesy of PostgreSQL, the behaviour of the config file has > changed between two of the versions. You can add PGDEBUG=0 to your > /etc/postgresql/postmaster.init file and they will disappear. > Cool! Thanks, Dwarf -- _-_-_-_-_- Author of "The Debian Linux User's Guide" _-_-_-_-_-_- aka Dale Scheetz Phone: 1 (850) 656-9769 Flexible Software 11000 McCrackin Road e-mail: [EMAIL PROTECTED] Tallahassee, FL 32308 _-_-_-_-_-_- See www.linuxpress.com for more details _-_-_-_-_-_-_-
Re: Strange messages...
On Wed, 30 Aug 2000, Jules Bean wrote: > Well, they're from Postgres, I can tell you that much. OK... > > Probably you have one of the debug trace options on in your postgres > config files (in /etc/postgresql). "I have"? ;-) I looked in /etc/postgresql and found several files, none of which set any debug options. pg_hba.conf Mostly comments except for a two line declaration that local host is trusted. pg_ident.conf Completely comments postgresql.env Incorporates postmaster.init into script and then assigns and exports several paths, two of which do not exist on my machine. postmaster.init Asside from a small block of code that determines POSTGRES_HOME and a line setting PGDATESTYLE to ISO, this file is all comments as well. So it looks like this is somehow "hard coded" in the binary? I guess I could just remove the package ... I installed it for educational purposes, and then never got to class ;-) Thanks, Dwarf -- _-_-_-_-_- Author of "The Debian Linux User's Guide" _-_-_-_-_-_- aka Dale Scheetz Phone: 1 (850) 656-9769 Flexible Software 11000 McCrackin Road e-mail: [EMAIL PROTECTED] Tallahassee, FL 32308 _-_-_-_-_-_- See www.linuxpress.com for more details _-_-_-_-_-_-_-
Re: Strange messages...
* Dale Scheetz in "Strange messages..." dated 2000/08/30 04:17 wrote: > Since my last upgrade to potato I've been getting a lot of messages > like the following: > > DEBUG: --Relation pg_rules-- > 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. [snip] > There doesn't seem to be any real information here. Can anyone tell > me what is triggering these messages? They are courtesy of PostgreSQL, the behaviour of the config file has changed between two of the versions. You can add PGDEBUG=0 to your /etc/postgresql/postmaster.init file and they will disappear. -- hackers ally pgpnMLidb4d2b.pgp Description: PGP signature
Re: Strange messages...
On Wed, Aug 30, 2000 at 04:17:42AM -0400, Dale Scheetz wrote: > Since my last upgrade to potato I've been getting a lot of messages like > the following: > > DEBUG: --Relation pg_rules-- > 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 [snip] > There doesn't seem to be any real information here. Can anyone tell me > what is triggering these messages? Well, they're from Postgres, I can tell you that much. Probably you have one of the debug trace options on in your postgres config files (in /etc/postgresql). HTH Jules
Re: Strange messages...
Quoting Dale Scheetz ([EMAIL PROTECTED]): > Since my last upgrade to potato I've been getting a lot of messages like > the following: > There doesn't seem to be any real information here. Can anyone tell me > what is triggering these messages? They're postgres debug messages. Somehow, the newest postgres packages are emitting debug messages all the time. I've seen them too, but haven't gotten around to checking where they come from yet. Greets, Robert -- | [EMAIL PROTECTED] - Cistron Internet Services - www.cistron.nl| | php3/c/perl/html/c++/sed/awk/linux/sql/cgi/security | | My statements are mine, and not necessarily cistron's. | Dance is the vertical expression of a horizontal intention.
Strange messages...
Since my last upgrade to potato I've been getting a lot of messages like the following: DEBUG: --Relation pg_rules-- 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_views-- 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_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. There doesn't seem to be any real information here. Can anyone tell me what is triggering these messages? Thanks, Dwarf -- _-_-_-_-_- Author of "The Debian Linux User's Guide" _-_-_-_-_-_- aka Dale Scheetz Phone: 1 (850) 656-9769 Flexible Software 11000 McCrackin Road e-mail: [EMAIL PROTECTED] Tallahassee, FL 32308 _-_-_-_-_-_- See www.linuxpress.com for more details _-_-_-_-_-_-_-
