Thread: Backup the part of postgres database

Backup the part of postgres database

From
roopa perumalraja
Date:
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.

Re: Backup the part of postgres database

From
"Adam Rich"
Date:
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.

Re: Backup the part of postgres database

From
roopa perumalraja
Date:

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.

Re: Backup the part of postgres database

From
"Joshua D. Drake"
Date:
roopa perumalraja wrote:
> 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. 

pg_dump --help

>
>   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,
ifso 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.


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


Re: Backup the part of postgres database

From
"Shoaib Mir"
Date:
COPY command might also help....

COPY (SELECT * FROM country WHERE country_name LIKE 'A%') TO '/usr1/proj/bray/sql/a_list_countries.copy';

Details can be found at --> http://www.postgresql.org/docs/current/static/sql-copy.html

------------------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 1/15/07, roopa perumalraja <roopabenzer@yahoo.com> wrote:
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.


Re: Backup the part of postgres database

From
btober@ct.metrocast.net
Date:
Joshua D. Drake wrote:
> roopa perumalraja wrote:
>   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. 
>
> pg_dump --help

Better yet, try this first:
"http://www.catb.org/~esr/faqs/smart-questions.html".