| From: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: re-create information_schema |
| Date: | 2012-03-03 22:28:04 |
| Message-ID: | 20120303222804.GA25365@cns.vt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sat, Mar 03, 2012 at 08:27:19PM +0200, Peter Eisentraut wrote:
> On ons, 2012-02-29 at 16:25 -0500, Ray Stell wrote:
> > On Wed, Feb 29, 2012 at 03:55:13PM -0500, Ray Stell wrote:
> > > http://www.postgresql.org/docs/9.1/static/release-9-1-2.html
> > > This must be repeated in each
> > > database to be fixed.
> >
> > including postgres, template0, and template1?
>
> Yes, if you want those databases to be fixed.
A trick with template0, or so it seems:
template1=# select datname, datallowconn from pg_database;
datname | datallowconn
-----------+--------------
template1 | t
template0 | f
postgres | t
rd | t
(4 rows)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rural Hunter | 2012-03-05 13:27:43 | Safe to put indexes in tablespaces on raid0 disk? |
| Previous Message | Peter Eisentraut | 2012-03-03 18:27:19 | Re: re-create information_schema |