Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BE8CF9FB363 for ; Tue, 23 Oct 2007 18:47:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 17079-01 for ; Tue, 23 Oct 2007 18:47:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.236]) by postgresql.org (Postfix) with ESMTP id 44B619FA349 for ; Tue, 23 Oct 2007 18:47:47 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so831292nzf for ; Tue, 23 Oct 2007 14:47:46 -0700 (PDT) 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=m17SwSALY06/ZakBNAXASfWqpkRR9hlmqAGencPY3o4=; b=LrIhliWfn9JB4Y38d6tDu02SBz6BnXkcAyEN4hglx6L3PJKSWk/H4uPYV1GUF9QwzTjYUlmutloIopVYSIB21rAFGgVYeXGBzdP2V3/Z6Y5Se9hV3z/FhQqjaHckxsEhDOCeceWWCp4P43+6Fpy5xM+cWOH8v0yWQ4454AqWOOE= 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=okZT3b2bqIACy6aaMpJIQlBaK+VhjZOK5QzxlHj+ocTkFBQKrjr278cD6zXEWTyupu3xEpoSiRA8KJqukRPtjoy+K6VVmhu0VF6jQPk+h9H7ESUJKByRPNwR3poD97MxtP8McaYMEmcGU1rBiRIazuChpRry+dUPCoMjwPonibo= Received: by 10.114.13.1 with SMTP id 1mr7474106wam.1193176065282; Tue, 23 Oct 2007 14:47:45 -0700 (PDT) Received: by 10.114.197.19 with HTTP; Tue, 23 Oct 2007 14:47:45 -0700 (PDT) Message-ID: <4544e0330710231447w33ee94d7r6ffbb98afb716d70@mail.gmail.com> Date: Tue, 23 Oct 2007 16:47:45 -0500 From: "Peter Koczan" To: "Suresh Gupta VG" Subject: Re: Postgresql takes more time to update Cc: scott.marlowe@gmail.com, pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0AC8BA74@ZENMAILHQ1.ind.zensar.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3921_7229116.1193176065301" References: <3D5445983859B84B92669C0D883EA6FB0AC8BA74@ZENMAILHQ1.ind.zensar.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/228 X-Sequence-Number: 27142 ------=_Part_3921_7229116.1193176065301 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 10/23/07, Suresh Gupta VG wrote: > > Hi Peter, > > > > 1) We are using "psql 7.4.2" version of Postgresql, need to create a > new schema similar to the current schema with all the objects as in the > current schema. Do we have any command to support this operation? > If you upgrade to the newest release in the 7.4 branch, you should just have to stop the database server and start the new version of postgres. If you are upgrading to an 8.x version (8.0, 8.1, or 8.2), you'll have to dump/restore using the method Scott mentioned. 2) We need to shift all the data between 2 different databases in 2 > different servers. What is the best way to go either backup or copy command? > Again, it depends on if you're going with the newest 7.4 release or a new 8.x release. For the newest 7.4, you can simply rsync or do a straight copy of the file system. If you're going with 8.x, you'll need to dump/restore using the method Scott mentioned. 3) Any equivalent command to export and import commands in Oracle/SQL. > I'm afraid I don't know enough about Oracle to answer that question. Peter ------=_Part_3921_7229116.1193176065301 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On 10/23/07, Suresh Gupta VG <suresh.g@zensar.com> wrote:

Hi Peter,

 

1)       We are using "psql 7.4.2" version of Postgresql, need to create a new schema similar to the current schema with all the objects as in the current schema. Do we have any command to support this operation?


If you upgrade to the newest release in the 7.4 branch, you should just have to stop the database server and start the new version of postgres. If you are upgrading to an 8.x version (8.0, 8.1, or 8.2), you'll have to dump/restore using the method Scott mentioned.

2)       We need to shift all the data between 2 different databases in 2 different servers. What is the best way to go either backup or copy command?


Again, it depends on if you're going with the newest 7.4 release or a new 8.x release. For the newest 7.4, you can simply rsync or do a straight copy of the file system. If you're going with 8.x, you'll need to dump/restore using the method Scott mentioned.

3)        Any equivalent command to export and import commands in Oracle/SQL.


I'm afraid I don't know enough about Oracle to answer that question.

Peter
------=_Part_3921_7229116.1193176065301--