Search Postgresql Archives

Re: Funky template1 problem?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"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 




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux