Re: psql schemas

From: "Peter Koczan" <pjkoczan(at)gmail(dot)com>
To: "Suresh Gupta VG" <suresh(dot)g(at)zensar(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: psql schemas
Date: 2007-11-05 17:39:26
Message-ID: 4544e0330711050939i586246caodbbd17c044a6939b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>
> I had a file with name "dump_live" which contains all the dump using
> "pg_dumpall > dump_live". Now, I need to restore it to another schema
> "schema2". How can I restore the data from that file to specified empty
> schema2. (This schema is created with out any objects). Pls advice me how to
> handle.
>
You dumped the entire database cluster...data, schema definitions,
user/group data, etc. You're going to have to specify options for dumping
and restoring data to do what you wish. This is well-documented in the list
archives, the website, man pages, and many, many other places. Please read
them.

Browse pgsql-admin by date

  From Date Subject
Next Message Dávið Klein Sundsskarð 2007-11-06 11:24:46 Log statements by username
Previous Message Peter Koczan 2007-11-05 17:32:50 Re: Postgresql pg_dumpall