Re: Regarding template1 database

On 4/23/2013 7:26 AM, S H wrote:
> ... template1 vacuuming with Analyze is executed through cron job
> every one hour and some times it is taking lot of time

what do you get from...

$ sudo -u postgres psql template1
psql (9.2.4)
Type "help" for help.

template1=# \d
No relations found.

thats normal above. do you have tables and stuff in this template1
database?

and to see about the rest...

template1=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype
| Access privileges
----------------+-------------+-----------+-------------+-------------+------------------------
blogs | blogs | UTF8 | en_US.UTF-8 |
en_US.UTF-8 |
junk | postgres | UTF8 | en_US.UTF-8 |
en_US.UTF-8 |
pierce | pierce | UTF8 | en_US.UTF-8 |
en_US.UTF-8 | pierce=CTc/pierce +
| | | | | =Tc/pierce
template0 | postgres | UTF8 | en_US.UTF-8 |
en_US.UTF-8 | =c/postgres +
| | | | |
postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 |
en_US.UTF-8 | postgres=C*T*/postgres+
| | | | | =c/postgres
(5 rows)

template1=#

--
john r pierce 37N 122W
somewhere on the middle of the left coast