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
