"Jerry LeVan" <jerry.levan@xxxxxxx> wrote in message news:DF90ADCC-643E-4EA7-AB6C-423815301EF5@xxxxxxxxxx > Hi, > > I have a bunch of small dbs (levan, pictures, and a couple of others). > > I have had these db's over many upgrades and I have just noticed that > template1 seems to be a bit munged... > > testuser=> \c template1 > You are now connected to database "template1". > template1=> \d > List of relations > Schema | Name | Type | Owner > --------+----------------+----------+------- > public | lo_shadow | table | levan > public | my_description | table | levan > public | person | table | levan > public | person_id_seq | sequence | levan > public | pics | table | levan > public | pics_ident_seq | sequence | levan > (6 rows) > Can you show the relfilenode (the physical file name of the relation) of these tables like this: select relname, relfilenode from pg_class, pg_namespace where relnamespace = pg_namespace.oid and nspname = 'public'; And check if they are really in the template1? Regards, Qingqing
