Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E5BEA9F942E for ; Mon, 5 Nov 2007 13:39:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20694-07 for ; Mon, 5 Nov 2007 13:39:28 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by postgresql.org (Postfix) with ESMTP id 6ACEF9F93E4 for ; Mon, 5 Nov 2007 13:39:28 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so2407392waf for ; Mon, 05 Nov 2007 09:39:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=aFEq3CMEObR6Ixy6Kmh0dbsWdCzw/oV2yWp7fKjn4/g=; b=Xiv5Ym8sFFezjEP2brKMvYbysW8mPK9XNe1kp/u/maGBya2J+6k4bk6apNKE50CGNUp8NUIqh8mC9nac635rXz4WjaeNi9VLPB1NHwJqhR527IepwV4eS9b78pVSFkDKGtkpXIvOl6hdDJId0cOcnOwsbiWL40d/VptFe+6TVLU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=fcpwtJzDOckReK+Nf0R6/fsFFujcpB60Moomvh5GvOVxMJN9Z9ilsnWxRMfmTzRDgq9Wsyfbb5xCoHK9JqbJZ042/4WjdTdM/fb/AEfvmMHRD0uW56xGLlCtDYWoMGjhkzzHZiIbMq1Nibw39csf+hUKEkO5y9wU4VoADLScRfA= Received: by 10.114.149.2 with SMTP id w2mr5408624wad.1194284366684; Mon, 05 Nov 2007 09:39:26 -0800 (PST) Received: by 10.114.197.19 with HTTP; Mon, 5 Nov 2007 09:39:26 -0800 (PST) Message-ID: <4544e0330711050939i586246caodbbd17c044a6939b@mail.gmail.com> Date: Mon, 5 Nov 2007 11:39:26 -0600 From: "Peter Koczan" To: "Suresh Gupta VG" Subject: Re: psql schemas Cc: pgsql-admin@postgresql.org In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0AF4AE01@ZENMAILHQ1.ind.zensar.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_31424_2546585.1194284366674" References: <3D5445983859B84B92669C0D883EA6FB0AF4AE01@ZENMAILHQ1.ind.zensar.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/53 X-Sequence-Number: 27296 ------=_Part_31424_2546585.1194284366674 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline > > 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. ------=_Part_31424_2546585.1194284366674 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

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.
------=_Part_31424_2546585.1194284366674--