Re: Bug#82029: Postgres installing (fwd) - Mailing list pgsql-general
| From | Oliver Elphick |
|---|---|
| Subject | Re: Bug#82029: Postgres installing (fwd) |
| Date | |
| Msg-id | 200101171118.f0HBHot27488@linda.lfix.co.uk Whole thread Raw |
| Responses |
Re: Re: Bug#82029: Postgres installing (fwd)
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: Re: Bug#82029: Postgres installing (fwd) (Tom Lane <tgl@sss.pgh.pa.us>) |
| List | pgsql-general |
Can anyone suggest what may be happening here? The original bug report was that initdb stuck with postgres consuming most of the CPU cycles. Now initdb has succeeded but `\d prova' in a test database consistently stalls, again with postgres taking most of the CPU. The release is Debian 7.0.3-1; no-one else is reporting any such problem. ------- Forwarded Message Date: Wed, 17 Jan 2001 09:18:09 +0100 From: Ivan Vighetto <ivan.vighetto@its.it> To: Oliver Elphick <olly@lfix.co.uk> Subject: Re: Bug#82029: Postgres installing This is a multi-part message in MIME format. - --------------FDA2A8E027E43C63CB451101 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Oliver Elphick wrote: > Ivan Vighetto wrote: > >I got sources from the address you gave me an recompiled packages: install at > >ion > >OK, tried to create a new database with "createdb test", done successfully , > >added a user with "adduser gunny", all ok. Connected to database test with > >psql, created table "prova" gave the command "\d prova"..., I'am waiting.. .. > >The proces that get most of the CPU is "/usr/lib/postgresql/bin/postgres > >localhost postgres test idle" > > So: you have recompiled the postgresql packages for 7.0.3-1 and installed > the resulting binary packages? Yes > > This time, you have successfuly done initdb and created a database, but > are now held up on `\d prova', which will actually run these queries > (and possibly some others): > > SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules > FROM pg_class WHERE relname='prova' > The execution stops here. > > SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef , > a.attnum > FROM pg_class c, pg_attribute a, pg_type t > WHERE c.relname = 'prova' > AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid > ORDER BY a.attnum > > SELECT c2.relname > FROM pg_class c, pg_class c2, pg_index i > WHERE c.relname = 'prova' AND c.oid = i.indrelid AND i.indexrelid = c2.oid > ORDER BY c2.relname > > Use `psql -E' to see what queries are being executed. Enable logging > with PGDEBUG=2 and PGECHO=yes in /etc/init.d/postmaster.init and > restart the postmaster. Connect with `psql -E' and try to list the > table structure with \d. Look in the log file to see where it had got > to when it got stuck. > > -- > Oliver Elphick Oliver.Elphick@lfix.co.uk > Isle of Wight http://www.lfix.co.uk/oliver > PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 > GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C > ======================================== > "Jesus said unto her, I am the resurrection, and the > life; he that believeth in me, though he weI re dead, > yet shall he live" John 11:25 I attach the postgres log file. - --------------FDA2A8E027E43C63CB451101 Content-Type: text/plain; charset=us-ascii; name="postgres.log" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="postgres.log" 010116.15:35:25.589 [23788] DEBUG: Data Base System is starting up at Tue Jan 16 15:35:25 2001 010116.15:35:25.591 [23788] DEBUG: Data Base System was shut down at Tue Jan 1 6 15:35:18 2001 010116.15:35:25.617 [23788] DEBUG: Data Base System is in production state at Tue Jan 16 15:35:25 2001 Couldn't open /var/lib/postgres/data/pg_options Couldn't open /var/lib/postgres/data/pg_options Couldn't open /var/lib/postgres/data/pg_options Couldn't open /var/lib/postgres/data/pg_options 010116.15:40:29.764 [23819] FATAL 1: The system is shutting down Couldn't open /var/lib/postgres/data/pg_options Couldn't open /var/lib/postgres/data/pg_options Couldn't open /var/lib/postgres/data/pg_options Couldn't open /var/lib/postgres/data/pg_options 010116.15:59:12.820 [23851] FATAL 1: The system is shutting down Couldn't open /var/lib/postgres/data/pg_options Couldn't open /var/lib/postgres/data/pg_options Couldn't open /var/lib/postgres/data/pg_options Couldn't open /var/lib/postgres/data/pg_options 010117.04:00:03.139 [23938] DEBUG: --Relation pg_type-- 010117.04:00:03.152 [23938] DEBUG: Pages 2: Changed 0, reaped 0, Empty 0, New 0; Tup 122: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 109, MaxLen 109; Re- using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.01u sec. 010117.04:00:03.163 [23938] DEBUG: Index pg_type_typname_index: Pages 2; Tuple s 122. CPU 0.00s/0.00u sec. 010117.04:00:03.167 [23938] DEBUG: Index pg_type_oid_index: Pages 2; Tuples 12 2. CPU 0.00s/0.00u sec. 010117.04:00:03.431 [23938] DEBUG: --Relation pg_attribute-- 010117.04:00:03.463 [23938] DEBUG: Pages 7: Changed 0, reaped 0, Empty 0, New 0; Tup 461: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 98, MaxLen 98; Re-us ing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.03u sec. 010117.04:00:03.488 [23938] DEBUG: Index pg_attribute_relid_attnum_index: Page s 4; Tuples 461. CPU 0.00s/0.01u sec. 010117.04:00:03.502 [23938] DEBUG: Index pg_attribute_relid_attnam_index: Page s 7; Tuples 461. CPU 0.00s/0.01u sec. 010117.04:00:03.876 [23938] DEBUG: --Relation pg_proc-- 010117.04:00:04.028 [23938] DEBUG: Pages 26: Changed 0, reaped 0, Empty 0, New 0; Tup 1083: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 177, MaxLen 229; R e-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.14u sec. 010117.04:00:04.063 [23938] DEBUG: Index pg_proc_proname_narg_type_index: Page s 28; Tuples 1083. CPU 0.00s/0.02u sec. 010117.04:00:04.093 [23938] DEBUG: Index pg_proc_oid_index: Pages 7; Tuples 10 83. CPU 0.00s/0.02u sec. 010117.04:00:04.448 [23938] DEBUG: --Relation pg_class-- 010117.04:00:04.455 [23938] DEBUG: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 65: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 4, MinLen 106, MaxLen 140; Re-u sing: Free/Avail. Space 500/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:04.459 [23938] DEBUG: Index pg_class_relname_index: Pages 2; Tupl es 65: Deleted 0. CPU 0.00s/0.00u sec. 010117.04:00:04.463 [23938] DEBUG: Index pg_class_oid_index: Pages 2; Tuples 6 5: Deleted 0. CPU 0.00s/0.00u sec. 010117.04:00:04.717 [23938] DEBUG: --Relation pg_tables-- 010117.04:00:04.718 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:04.947 [23938] DEBUG: --Relation pg_group-- 010117.04:00:04.947 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:04.969 [23938] DEBUG: Index pg_group_sysid_index: Pages 2; Tuples 0. CPU 0.00s/0.00u sec. 010117.04:00:04.972 [23938] DEBUG: Index pg_group_name_index: Pages 2; Tuples 0. CPU 0.00s/0.00u sec. 010117.04:00:05.132 [23938] DEBUG: --Relation pg_database-- 010117.04:00:05.134 [23938] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 2: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 80, MaxLen 85; Re-usin g: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:05.359 [23938] DEBUG: --Relation pg_attrdef-- 010117.04:00:05.360 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:05.368 [23938] DEBUG: Index pg_attrdef_adrelid_index: Pages 2; Tu ples 0. CPU 0.00s/0.00u sec. 010117.04:00:05.488 [23938] DEBUG: --Relation pg_relcheck-- 010117.04:00:05.489 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:05.497 [23938] DEBUG: Index pg_relcheck_rcrelid_index: Pages 2; T uples 0. CPU 0.00s/0.00u sec. 010117.04:00:05.920 [23938] DEBUG: --Relation pg_trigger-- 010117.04:00:05.921 [23938] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 1: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 152, MaxLen 152; Re-us ing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:05.937 [23938] DEBUG: Index pg_trigger_tgrelid_index: Pages 2; Tu ples 1. CPU 0.00s/0.00u sec. 010117.04:00:05.940 [23938] DEBUG: Index pg_trigger_tgconstrrelid_index: Pages 2; Tuples 1. CPU 0.00s/0.00u sec. 010117.04:00:05.942 [23938] DEBUG: Index pg_trigger_tgconstrname_index: Pages 2; Tuples 1. CPU 0.00s/0.00u sec. 010117.04:00:06.158 [23938] DEBUG: --Relation pg_inherits-- 010117.04:00:06.159 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:06.172 [23938] DEBUG: Index pg_inherits_relid_seqno_index: Pages 2; Tuples 0. CPU 0.00s/0.00u sec. 010117.04:00:06.472 [23938] DEBUG: --Relation pg_index-- 010117.04:00:06.476 [23938] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 32: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 164, MaxLen 164; Re-u sing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:06.479 [23938] DEBUG: Index pg_index_indexrelid_index: Pages 2; T uples 32. CPU 0.00s/0.00u sec. 010117.04:00:06.683 [23938] DEBUG: --Relation pg_statistic-- 010117.04:00:06.686 [23938] DEBUG: Pages 3: Changed 3, reaped 1, Empty 0, New 0; Tup 168: Vac 90, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 64, MaxLen 125; Re- using: Free/Avail. Space 7404/7404; EndEmpty/Avail. Pages 0/1. CPU 0.00s/0.00u sec. 010117.04:00:06.716 [23938] DEBUG: Index pg_statistic_relid_att_index: Pages 2 ; Tuples 168: Deleted 90. CPU 0.00s/0.02u sec. 010117.04:00:06.890 [23938] DEBUG: Rel pg_statistic: Pages: 3 --> 2; Tuple(s) moved: 90. CPU 0.00s/0.03u sec. 010117.04:00:06.911 [23938] DEBUG: Index pg_statistic_relid_att_index: Pages 2 ; Tuples 168: Deleted 90. CPU 0.00s/0.02u sec. 010117.04:00:07.509 [23938] DEBUG: --Relation pg_operator-- 010117.04:00:07.545 [23938] DEBUG: Pages 9: Changed 0, reaped 0, Empty 0, New 0; Tup 559: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 116, MaxLen 116; Re- using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.03u sec. 010117.04:00:07.562 [23938] DEBUG: Index pg_operator_oprname_l_r_k_index: Page s 8; Tuples 559. CPU 0.00s/0.01u sec. 010117.04:00:07.577 [23938] DEBUG: Index pg_operator_oid_index: Pages 4; Tuple s 559. CPU 0.00s/0.01u sec. 010117.04:00:07.870 [23938] DEBUG: --Relation pg_opclass-- 010117.04:00:07.872 [23938] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 30: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 68, MaxLen 68; Re-usi ng: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:07.884 [23938] DEBUG: Index pg_opclass_name_index: Pages 2; Tuple s 30. CPU 0.00s/0.00u sec. 010117.04:00:07.888 [23938] DEBUG: Index pg_opclass_deftype_index: Pages 2; Tu ples 30. CPU 0.00s/0.00u sec. 010117.04:00:10.250 [23938] DEBUG: --Relation pg_am-- 010117.04:00:10.251 [23938] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 4: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 148, MaxLen 148; Re-us ing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:10.264 [23938] DEBUG: Index pg_am_name_index: Pages 2; Tuples 4. CPU 0.00s/0.00u sec. 010117.04:00:10.539 [23938] DEBUG: --Relation pg_amop-- 010117.04:00:10.544 [23938] DEBUG: Pages 2: Changed 0, reaped 0, Empty 0, New 0; Tup 182: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 46, MaxLen 46; Re-us ing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:10.586 [23938] DEBUG: Index pg_amop_strategy_index: Pages 2; Tupl es 182. CPU 0.00s/0.00u sec. 010117.04:00:10.593 [23938] DEBUG: Index pg_amop_opid_index: Pages 2; Tuples 1 82. CPU 0.00s/0.00u sec. 010117.04:00:11.095 [23938] DEBUG: --Relation pg_amproc-- 010117.04:00:11.098 [23938] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 51: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 46, MaxLen 46; Re-usi ng: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:11.308 [23938] DEBUG: --Relation pg_language-- 010117.04:00:11.310 [23938] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 3: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 79, MaxLen 84; Re-usin g: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:11.332 [23938] DEBUG: Index pg_language_oid_index: Pages 2; Tuple s 3. CPU 0.00s/0.00u sec. 010117.04:00:11.335 [23938] DEBUG: Index pg_language_name_index: Pages 2; Tupl es 3. CPU 0.00s/0.00u sec. 010117.04:00:11.941 [23938] DEBUG: --Relation pg_aggregate-- 010117.04:00:11.945 [23938] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 45: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 104, MaxLen 111; Re-u sing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:11.959 [23938] DEBUG: Index pg_aggregate_name_type_index: Pages 2 ; Tuples 45. CPU 0.00s/0.00u sec. 010117.04:00:12.193 [23938] DEBUG: --Relation pg_ipl-- 010117.04:00:12.194 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:12.320 [23938] DEBUG: --Relation pg_inheritproc-- 010117.04:00:12.321 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:12.451 [23938] DEBUG: --Relation pg_rewrite-- 010117.04:00:12.476 [23938] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 5: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 903, MaxLen 1236; Re-u sing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.02u sec. 010117.04:00:12.492 [23938] DEBUG: Index pg_rewrite_rulename_index: Pages 2; T uples 5. CPU 0.00s/0.00u sec. 010117.04:00:12.495 [23938] DEBUG: Index pg_rewrite_oid_index: Pages 2; Tuples 5. CPU 0.00s/0.00u sec. 010117.04:00:12.717 [23938] DEBUG: --Relation pg_listener-- 010117.04:00:12.718 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:12.735 [23938] DEBUG: Index pg_listener_relname_pid_index: Pages 2; Tuples 0. CPU 0.00s/0.00u sec. 010117.04:00:12.867 [23938] DEBUG: --Relation pg_description-- 010117.04:00:12.931 [23938] DEBUG: Pages 9: Changed 0, reaped 0, Empty 0, New 0; Tup 1103: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 42, MaxLen 110; Re- using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.06u sec. 010117.04:00:12.967 [23938] DEBUG: Index pg_description_objoid_index: Pages 6; Tuples 1103. CPU 0.00s/0.02u sec. 010117.04:00:13.210 [23938] DEBUG: --Relation pg_indexes-- 010117.04:00:13.210 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:13.346 [23938] DEBUG: --Relation pg_shadow-- 010117.04:00:13.348 [23938] DEBUG: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 2: Vac 1, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 80, MaxLen 80; Re-usin g: Free/Avail. Space 8012/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:13.612 [23938] DEBUG: --Relation pg_user-- 010117.04:00:13.613 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:13.744 [23938] DEBUG: --Relation pg_rules-- 010117.04:00:13.745 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:13.878 [23938] DEBUG: --Relation pg_views-- 010117.04:00:13.879 [23938] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. Couldn't open /var/lib/postgres/data/pg_options 010117.04:00:14.938 [23940] DEBUG: --Relation pg_type-- 010117.04:00:14.951 [23940] DEBUG: Pages 2: Changed 1, reaped 0, Empty 0, New 0; Tup 123: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 109, MaxLen 109; Re- using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.01u sec. 010117.04:00:14.962 [23940] DEBUG: Index pg_type_typname_index: Pages 2; Tuple s 123. CPU 0.00s/0.00u sec. 010117.04:00:14.966 [23940] DEBUG: Index pg_type_oid_index: Pages 2; Tuples 12 3. CPU 0.00s/0.00u sec. 010117.04:00:15.309 [23940] DEBUG: --Relation pg_attribute-- 010117.04:00:15.341 [23940] DEBUG: Pages 7: Changed 1, reaped 0, Empty 0, New 0; Tup 468: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 98, MaxLen 98; Re-us ing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.03u sec. 010117.04:00:15.365 [23940] DEBUG: Index pg_attribute_relid_attnum_index: Page s 4; Tuples 468. CPU 0.00s/0.01u sec. 010117.04:00:15.382 [23940] DEBUG: Index pg_attribute_relid_attnam_index: Page s 7; Tuples 468. CPU 0.00s/0.01u sec. 010117.04:00:15.813 [23940] DEBUG: --Relation pg_proc-- 010117.04:00:15.973 [23940] DEBUG: Pages 26: Changed 0, reaped 0, Empty 0, New 0; Tup 1083: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 177, MaxLen 229; R e-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.02s/0.13u sec. 010117.04:00:16.005 [23940] DEBUG: Index pg_proc_proname_narg_type_index: Page s 28; Tuples 1083. CPU 0.00s/0.02u sec. 010117.04:00:16.035 [23940] DEBUG: Index pg_proc_oid_index: Pages 7; Tuples 10 83. CPU 0.00s/0.02u sec. 010117.04:00:16.415 [23940] DEBUG: --Relation pg_class-- 010117.04:00:16.422 [23940] DEBUG: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 66: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 3, MinLen 106, MaxLen 140; Re-u sing: Free/Avail. Space 388/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:16.426 [23940] DEBUG: Index pg_class_relname_index: Pages 2; Tupl es 66: Deleted 0. CPU 0.00s/0.00u sec. 010117.04:00:16.429 [23940] DEBUG: Index pg_class_oid_index: Pages 2; Tuples 6 6: Deleted 0. CPU 0.00s/0.00u sec. 010117.04:00:16.694 [23940] DEBUG: --Relation pg_tables-- 010117.04:00:16.695 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:16.918 [23940] DEBUG: --Relation pg_group-- 010117.04:00:16.919 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:16.938 [23940] DEBUG: Index pg_group_sysid_index: Pages 2; Tuples 0. CPU 0.00s/0.00u sec. 010117.04:00:16.940 [23940] DEBUG: Index pg_group_name_index: Pages 2; Tuples 0. CPU 0.00s/0.00u sec. 010117.04:00:17.087 [23940] DEBUG: --Relation pg_database-- 010117.04:00:17.088 [23940] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 2: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 80, MaxLen 85; Re-usin g: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:17.336 [23940] DEBUG: --Relation pg_attrdef-- 010117.04:00:17.336 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:17.345 [23940] DEBUG: Index pg_attrdef_adrelid_index: Pages 2; Tu ples 0. CPU 0.00s/0.00u sec. 010117.04:00:17.497 [23940] DEBUG: --Relation pg_relcheck-- 010117.04:00:17.497 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:17.505 [23940] DEBUG: Index pg_relcheck_rcrelid_index: Pages 2; T uples 0. CPU 0.00s/0.00u sec. 010117.04:00:17.932 [23940] DEBUG: --Relation pg_trigger-- 010117.04:00:17.933 [23940] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 1: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 152, MaxLen 152; Re-us ing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:17.949 [23940] DEBUG: Index pg_trigger_tgrelid_index: Pages 2; Tu ples 1. CPU 0.00s/0.00u sec. 010117.04:00:17.952 [23940] DEBUG: Index pg_trigger_tgconstrrelid_index: Pages 2; Tuples 1. CPU 0.00s/0.00u sec. 010117.04:00:17.955 [23940] DEBUG: Index pg_trigger_tgconstrname_index: Pages 2; Tuples 1. CPU 0.00s/0.00u sec. 010117.04:00:18.189 [23940] DEBUG: --Relation pg_inherits-- 010117.04:00:18.190 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:18.203 [23940] DEBUG: Index pg_inherits_relid_seqno_index: Pages 2; Tuples 0. CPU 0.00s/0.00u sec. 010117.04:00:18.506 [23940] DEBUG: --Relation pg_index-- 010117.04:00:18.510 [23940] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 32: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 164, MaxLen 164; Re-u sing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:18.513 [23940] DEBUG: Index pg_index_indexrelid_index: Pages 2; T uples 32. CPU 0.00s/0.00u sec. 010117.04:00:18.725 [23940] DEBUG: --Relation pg_statistic-- 010117.04:00:18.728 [23940] DEBUG: Pages 3: Changed 3, reaped 1, Empty 0, New 0; Tup 168: Vac 90, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 64, MaxLen 125; Re- using: Free/Avail. Space 7404/7404; EndEmpty/Avail. Pages 0/1. CPU 0.00s/0.00u sec. 010117.04:00:18.761 [23940] DEBUG: Index pg_statistic_relid_att_index: Pages 2 ; Tuples 168: Deleted 90. CPU 0.00s/0.02u sec. 010117.04:00:18.955 [23940] DEBUG: Rel pg_statistic: Pages: 3 --> 2; Tuple(s) moved: 90. CPU 0.00s/0.03u sec. 010117.04:00:18.979 [23940] DEBUG: Index pg_statistic_relid_att_index: Pages 2 ; Tuples 168: Deleted 90. CPU 0.00s/0.02u sec. 010117.04:00:19.565 [23940] DEBUG: --Relation pg_operator-- 010117.04:00:19.604 [23940] DEBUG: Pages 9: Changed 0, reaped 0, Empty 0, New 0; Tup 559: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 116, MaxLen 116; Re- using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.03u sec. 010117.04:00:19.622 [23940] DEBUG: Index pg_operator_oprname_l_r_k_index: Page s 8; Tuples 559. CPU 0.00s/0.01u sec. 010117.04:00:19.639 [23940] DEBUG: Index pg_operator_oid_index: Pages 4; Tuple s 559. CPU 0.00s/0.01u sec. 010117.04:00:19.945 [23940] DEBUG: --Relation pg_opclass-- 010117.04:00:19.947 [23940] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 30: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 68, MaxLen 68; Re-usi ng: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:19.960 [23940] DEBUG: Index pg_opclass_name_index: Pages 2; Tuple s 30. CPU 0.00s/0.00u sec. 010117.04:00:19.965 [23940] DEBUG: Index pg_opclass_deftype_index: Pages 2; Tu ples 30. CPU 0.00s/0.00u sec. 010117.04:00:22.315 [23940] DEBUG: --Relation pg_am-- 010117.04:00:22.317 [23940] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 4: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 148, MaxLen 148; Re-us ing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:22.329 [23940] DEBUG: Index pg_am_name_index: Pages 2; Tuples 4. CPU 0.00s/0.00u sec. 010117.04:00:22.616 [23940] DEBUG: --Relation pg_amop-- 010117.04:00:22.620 [23940] DEBUG: Pages 2: Changed 0, reaped 0, Empty 0, New 0; Tup 182: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 46, MaxLen 46; Re-us ing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:22.663 [23940] DEBUG: Index pg_amop_strategy_index: Pages 2; Tupl es 182. CPU 0.00s/0.00u sec. 010117.04:00:22.670 [23940] DEBUG: Index pg_amop_opid_index: Pages 2; Tuples 1 82. CPU 0.00s/0.00u sec. 010117.04:00:22.884 [23940] DEBUG: --Relation pg_amproc-- 010117.04:00:22.885 [23940] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 51: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 46, MaxLen 46; Re-usi ng: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:23.108 [23940] DEBUG: --Relation pg_language-- 010117.04:00:23.110 [23940] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 3: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 79, MaxLen 84; Re-usin g: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:23.133 [23940] DEBUG: Index pg_language_oid_index: Pages 2; Tuple s 3. CPU 0.00s/0.00u sec. 010117.04:00:23.136 [23940] DEBUG: Index pg_language_name_index: Pages 2; Tupl es 3. CPU 0.00s/0.00u sec. 010117.04:00:23.751 [23940] DEBUG: --Relation pg_aggregate-- 010117.04:00:23.756 [23940] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 45: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 104, MaxLen 111; Re-u sing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:23.770 [23940] DEBUG: Index pg_aggregate_name_type_index: Pages 2 ; Tuples 45. CPU 0.00s/0.00u sec. 010117.04:00:23.993 [23940] DEBUG: --Relation pg_ipl-- 010117.04:00:23.993 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:24.119 [23940] DEBUG: --Relation pg_inheritproc-- 010117.04:00:24.120 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:24.262 [23940] DEBUG: --Relation pg_rewrite-- 010117.04:00:24.285 [23940] DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 5: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 903, MaxLen 1236; Re-u sing: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.02u sec. 010117.04:00:24.302 [23940] DEBUG: Index pg_rewrite_rulename_index: Pages 2; T uples 5. CPU 0.00s/0.00u sec. 010117.04:00:24.306 [23940] DEBUG: Index pg_rewrite_oid_index: Pages 2; Tuples 5. CPU 0.00s/0.00u sec. 010117.04:00:24.517 [23940] DEBUG: --Relation pg_listener-- 010117.04:00:24.517 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:24.535 [23940] DEBUG: Index pg_listener_relname_pid_index: Pages 2; Tuples 0. CPU 0.00s/0.00u sec. 010117.04:00:24.667 [23940] DEBUG: --Relation pg_description-- 010117.04:00:24.739 [23940] DEBUG: Pages 9: Changed 0, reaped 0, Empty 0, New 0; Tup 1103: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 42, MaxLen 110; Re- using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.06u sec. 010117.04:00:24.779 [23940] DEBUG: Index pg_description_objoid_index: Pages 6; Tuples 1103. CPU 0.00s/0.02u sec. 010117.04:00:25.021 [23940] DEBUG: --Relation pg_indexes-- 010117.04:00:25.021 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:25.168 [23940] DEBUG: --Relation pg_shadow-- 010117.04:00:25.169 [23940] DEBUG: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 2: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 1, MinLen 80, MaxLen 80; Re-usin g: Free/Avail. Space 8012/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 010117.04:00:25.435 [23940] DEBUG: --Relation prova-- 010117.04:00:25.436 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:25.589 [23940] DEBUG: --Relation pg_user-- 010117.04:00:25.589 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:25.754 [23940] DEBUG: --Relation pg_rules-- 010117.04:00:25.754 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. 010117.04:00:25.899 [23940] DEBUG: --Relation pg_views-- 010117.04:00:25.900 [23940] DEBUG: Pages 0: Changed 0, reaped 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. CPU 0.00s/0.00u sec. Smart Shutdown request at Wed Jan 17 09:46:51 2001 010117.09:46:51.051 [24183] DEBUG: Data Base System shutting down at Wed Jan 1 7 09:46:51 2001 010117.09:46:51.131 [24183] DEBUG: Data Base System shut down at Wed Jan 17 09 :46:51 2001 binding ShmemCreate(key=52e2c1, size=2262016) 010117.09:48:12.073 [24210] DEBUG: Data Base System is starting up at Wed Jan 17 09:48:12 2001 010117.09:48:12.075 [24210] DEBUG: Data Base System was shut down at Wed Jan 1 7 09:46:51 2001 010117.09:48:12.104 [24210] DEBUG: Data Base System is in production state at Wed Jan 17 09:48:12 2001 010117.09:48:12.104 [24210] proc_exit(0) 010117.09:48:12.105 [24210] shmem_exit(0) 010117.09:48:12.105 [24210] exit(0) /usr/lib/postgresql/bin/postmaster: reaping dead processes... /usr/lib/postgresql/bin/postmaster: ServerLoop: handling reading 4 /usr/lib/postgresql/bin/postmaster: ServerLoop: handling reading 4 /usr/lib/postgresql/bin/postmaster: ServerLoop: handling writing 4 /usr/lib/postgresql/bin/postmaster: BackendStartup: pid 24217 user postgres db - - socket 4 /usr/lib/postgresql/bin/postmaster child[24217]: starting with (/usr/lib/postgr esql/bin/postgres -d2 -B 128 -E -v131072 -p - ) Couldn't open /var/lib/postgres/data/pg_options FindExec: found "/usr/lib/postgresql/bin/postgres" using argv[0] 010117.09:48:55.938 [24217] started: host=localhost user=postgres database=- 010117.09:48:55.942 [24217] InitPostgres 010117.09:48:55.945 [24217] FATAL 1: Database "-" does not exist in the system catalog. 010117.09:48:55.946 [24217] proc_exit(0) 010117.09:48:55.947 [24217] shmem_exit(0) 010117.09:48:55.947 [24217] exit(0) /usr/lib/postgresql/bin/postmaster: reaping dead processes... /usr/lib/postgresql/bin/postmaster: CleanupProc: pid 24217 exited with status 0 /usr/lib/postgresql/bin/postmaster: ServerLoop: handling reading 4 /usr/lib/postgresql/bin/postmaster: ServerLoop: handling reading 4 /usr/lib/postgresql/bin/postmaster: ServerLoop: handling writing 4 /usr/lib/postgresql/bin/postmaster: BackendStartup: pid 24219 user postgres db template1 socket 4 /usr/lib/postgresql/bin/postmaster child[24219]: starting with (/usr/lib/postgr esql/bin/postgres -d2 -B 128 -E -v131072 -p template1 ) Couldn't open /var/lib/postgres/data/pg_options FindExec: found "/usr/lib/postgresql/bin/postgres" using argv[0] 010117.09:49:00.658 [24219] started: host=localhost user=postgres database=temp late1 010117.09:49:00.662 [24219] InitPostgres 010117.09:49:00.864 [24219] reset_client_encoding().. 010117.09:49:00.865 [24219] reset_client_encoding() done. 010117.09:49:00.868 [24219] StartTransactionCommand 010117.09:49:00.868 [24219] query: select getdatabaseencoding() 010117.09:49:00.916 [24219] ProcessQuery 010117.09:49:00.918 [24219] CommitTransactionCommand 010117.09:49:00.958 [24219] StartTransactionCommand 010117.09:49:00.959 [24219] query: SELECT usesuper FROM pg_user WHERE usename = 'postgres' 010117.09:49:01.035 [24219] ProcessQuery 010117.09:49:01.039 [24219] CommitTransactionCommand /usr/lib/postgresql/bin/postmaster: ServerLoop: handling reading 4 /usr/lib/postgresql/bin/postmaster: ServerLoop: handling reading 4 /usr/lib/postgresql/bin/postmaster: ServerLoop: handling writing 4 /usr/lib/postgresql/bin/postmaster: BackendStartup: pid 24220 user postgres db test socket 4 /usr/lib/postgresql/bin/postmaster child[24220]: starting with (/usr/lib/postgr esql/bin/postgres -d2 -B 128 -E -v131072 -p test ) Couldn't open /var/lib/postgres/data/pg_options FindExec: found "/usr/lib/postgresql/bin/postgres" using argv[0] 010117.09:49:08.366 [24220] started: host=localhost user=postgres database=test 010117.09:49:08.369 [24220] InitPostgres 010117.09:49:08.594 [24220] reset_client_encoding().. 010117.09:49:08.595 [24220] reset_client_encoding() done. 010117.09:49:08.597 [24220] StartTransactionCommand 010117.09:49:08.598 [24220] query: select getdatabaseencoding() 010117.09:49:08.650 [24220] ProcessQuery 010117.09:49:08.652 [24220] CommitTransactionCommand 010117.09:49:08.657 [24219] proc_exit(0) 010117.09:49:08.657 [24219] shmem_exit(0) 010117.09:49:08.658 [24219] exit(0) /usr/lib/postgresql/bin/postmaster: reaping dead processes... /usr/lib/postgresql/bin/postmaster: CleanupProc: pid 24219 exited with status 0 010117.09:49:08.666 [24220] StartTransactionCommand 010117.09:49:08.667 [24220] query: SELECT usesuper FROM pg_user WHERE usename = 'postgres' 010117.09:49:08.746 [24220] ProcessQuery 010117.09:49:08.750 [24220] CommitTransactionCommand 010117.09:49:39.020 [24220] StartTransactionCommand 010117.09:49:39.021 [24220] query: SELECT relhasindex, relkind, relchecks, relt riggers, relhasrules FROM pg_class WHERE relname='prova' - --------------FDA2A8E027E43C63CB451101-- ------- End of Forwarded Message -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "And, behold, I come quickly; and my reward is with me, to give every man according as his work shall be." Revelation 22:12
pgsql-general by date: