| From: | "Adam Rich" <adam(dot)r(at)sbcglobal(dot)net> |
|---|---|
| To: | "'roopa perumalraja'" <roopabenzer(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Backup the part of postgres database |
| Date: | 2007-01-15 03:19:32 |
| Message-ID: | 068801c73853$f9d75bb0$6400a8c0@dualcore |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of roopa
perumalraja
Sent: Sunday, January 14, 2007 8:39 PM
To: pgsql-general(at)postgresql(dot)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
<http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar
/features/mail/> email alerts with the free Yahoo!
<http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar
/features/mail/> Toolbar.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | roopa perumalraja | 2007-01-15 05:18:32 | Re: Backup the part of postgres database |
| Previous Message | roopa perumalraja | 2007-01-15 02:39:04 | Backup the part of postgres database |