Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup the part of postgres database - Mailing list pgsql-general

From roopa perumalraja
Subject Re: Backup the part of postgres database
Date
Msg-id 536908.92902.qm@web50813.mail.yahoo.com
Whole thread Raw
In response to Re: Backup the part of postgres database  ("Adam Rich" <adam.r@sbcglobal.net>)
Responses Re: Backup the part of postgres database  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view

Hi Adam,
 
Thanks a lot for your immediate reply. can you please tell me how to use the command pg_dump to backup specific tables. Thanks a lot in advance.
 
Regards
Roopa

Adam Rich <adam.r@sbcglobal.net> wrote:
Roopa,
You can use the command pg_dump to backup specific tables.   But you won't be able to
restrict the backup to specific rows.  (You can always create a separate table just for backups,
and dump just that table).
 
 
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of roopa perumalraja
Sent: Sunday, January 14, 2007 8:39 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Backup the part of postgres database

Hi all,
 
Is it possible to back up only part of my database for example from tables which have data from April to July 2006, if so what will be the command for that.
 
Thanks a lot in advance
Roopa
It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.

Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games.

pgsql-general by date:

Previous
From: "Adam Rich"
Date:
Subject: Re: Backup the part of postgres database
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Backup the part of postgres database