Skip site navigation (1) Skip section navigation (2)

Re: re-create information_schema

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 (view raw or flat)
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)

In response to

pgsql-admin by date

Next:From: Rural HunterDate: 2012-03-05 13:27:43
Subject: Safe to put indexes in tablespaces on raid0 disk?
Previous:From: Peter EisentrautDate: 2012-03-03 18:27:19
Subject: Re: re-create information_schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group