pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Koczan <pjkoczan@gmail.com>
To: Suresh Gupta VG <suresh.g@zensar.com>
Cc: scott.marlowe@gmail.com
Cc: pgsql-admin@postgresql.org
Cc: pgsql-admin-owner@postgresql.org
Subject: Re: Postgresql takes more time to update
Date: Tue, 23 Oct 2007 16:47:45 -0500
Message-ID: <4544e0330710231447w33ee94d7r6ffbb98afb716d70@mail.gmail.com> (raw)
In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0AC8BA74@ZENMAILHQ1.ind.zensar.com>
References: <3D5445983859B84B92669C0D883EA6FB0AC8BA74@ZENMAILHQ1.ind.zensar.com>

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

view thread (15+ messages)  latest in thread

Message-ID: <4544e0330710231447w33ee94d7r6ffbb98afb716d70@mail.gmail.com>
Permalink:  ../4544e0330710231447w33ee94d7r6ffbb98afb716d70@mail.gmail.com/
Also on:    postgresql.org/message-id/4544e0330710231447w33ee94d7r6ffbb98afb716d70@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: pjkoczan@gmail.com, suresh.g@zensar.com, scott.marlowe@gmail.com, pgsql-admin-owner@postgresql.org
  Subject: Re: Postgresql takes more time to update
  In-Reply-To: <4544e0330710231447w33ee94d7r6ffbb98afb716d70@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox