Re: Postgresql takes more time to update

Scott, Thanks for your response.

with thanks and regards,

G.V. Suresh Gupta

Sr. Software Engineer

Batelco Phase II

Mo: +91 9890898688

Ph : +9120 66453213

________________________________

From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Wednesday, October 24, 2007 2:17 AM
To: Suresh Gupta VG
Cc: Peter Koczan; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Postgresql takes more time to update

On 10/23/07, Suresh Gupta VG <suresh(dot)g(at)zensar(dot)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?

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?

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

Can you please give some knowledge on this

1: Upgrade to 7.4.18 (or whatever the latest is) as soon as you can.
Use pg_dump with the -s switch to get just the schema and objects but no
data out. pg_dump --help will give you a list of all the options that
command has. To put your new schema into another database, just
redirect that file to psql:

pg_dump -s -h olddbserver olddbname > schemafile.sql
psql -h newserver newdbname < svhemafile.sql

2: pg_dump is the best way to go. pg_dumpall can dump everything,
including user accounts from one server. Then feed the output to psql
or pg_restore.

3: pg_dump is export, psql or pg_restore are import

DISCLAIMER:
This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails.