Re: Regarding template1 database - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Regarding template1 database
Date
Msg-id 5177DD8C.4040805@gmail.com
Whole thread Raw
In response to Re: Regarding template1 database  (S H <msq001@live.com>)
Responses Re: Regarding template1 database
List pgsql-general
On 04/24/2013 04:57 AM, S H wrote:
>      $ sudo -u postgres psql template1
>      psql (9.2.4)
>      Type "help" for help.
>
>      template1=# \d
>      No relations found.
>
> I am getting as mentioned above. I am not sure what is taking vacuuming
> long time.

If you are getting 'No relations found' then there is nothing in template1.

 From psql try:

\l+

This will show a list of databases in the cluster and their sizes.

>
> - What is the recommendation of vacuuming for wraparound issue for
> template1 - Once in month/week/year?
>
> - Is it required to run analyze on template1 and postgres database
> (system databases).
>
> Since it is already in production i can maximum change the interval and
> vacuum options and nothing more...


--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pgdump error "Could not open file pg_clog/0B8E: No such file or directory"
Next
From: François Beausoleil
Date:
Subject: Re: pg_stop_backup running for 2h10m?