Re: Postgresql takes more time to update

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks Scott and Peter,

 

Can we get a part of data from the database based on any rules like date, field value, etc. b’cas I need the dump of data everyday in a separate files. Can you pls suggest me on this.

 

G.V. Suresh Gupta

   Sr. Software Engineer

   Batelco Phase II

Mo: +91 9890898688

Ph : +9120 66453213


From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx]
Sent: Wednesday, October 24, 2007 2:17 AM
To: Suresh Gupta VG
Cc: Peter Koczan; pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: Postgresql takes more time to update

 

On 10/23/07, Suresh Gupta VG <suresh.g@xxxxxxxxxx> 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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux