Re: [ADMIN] re-create information_schema

2012-03-03 Thread Ray Stell
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 > > > databas

Re: [ADMIN] re-create information_schema

2012-03-03 Thread Peter Eisentraut
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 y

[ADMIN] Restoring selected records from backup file

2012-03-03 Thread Piyush Lenka
hi, 1. How can we restore selected records from a plain text backup (backup.sql). 2. Is it possible using psql. If yes how Please Help Thanks & Regards Piyush