| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | S H <msq001(at)live(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Regarding template1 database |
| Date: | 2013-04-24 13:26:36 |
| Message-ID: | 5177DD8C.4040805@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | François Beausoleil | 2013-04-24 13:31:01 | Re: pg_stop_backup running for 2h10m? |
| Previous Message | Adrian Klaver | 2013-04-24 13:23:02 | Re: pgdump error "Could not open file pg_clog/0B8E: No such file or directory" |