From: | Julio Leyva <jcleyva(at)hotmail(dot)com> |
---|---|
To: | <lennin(dot)caro(at)yahoo(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>, Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
Subject: | Re: [GENERAL] PITR - base backup question |
Date: | 2008-08-28 14:02:03 |
Message-ID: | BLU102-W13EFB1C149C5EA264002A8A1600@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
----------------------------------------
> Date: Wed, 27 Aug 2008 06:58:33 -0700
> From: lennin(dot)caro(at)yahoo(dot)com
> Subject: Re: [ADMIN] [GENERAL] PITR - base backup question
> To: pgsql-general(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org; richard(dot)broersma(at)gmail(dot)com
>
>
>
>
> --- On Tue, 8/26/08, Richard Broersma wrote:
>
>> From: Richard Broersma
>> Subject: [GENERAL] PITR - base backup question
>> To: "pgsql-general(at)postgresql(dot)org" , pgsql-admin(at)postgresql(dot)org
>> Date: Tuesday, August 26, 2008, 10:53 PM
>> From the following link:
>> http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP
>>
>> Step 3 says to perform the back up.
>>
>> Does this mean a File System Backup of the Data
>> directory?\
It is a file system backup, we use PITR and every time we need a new checkpoint we create a TAR file of the postgresql home directory
>> OR
>> Does this mean performing a pg_dumpall and backing up
>> the dump file?
>>
> is a file system backup of he data directory
>> --
>> Regards,
>> Richard Broersma Jr.
>
>
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
From | Date | Subject | |
---|---|---|---|
Next Message | John | 2008-08-28 14:25:21 | Checking Postgres Version Question |
Previous Message | windsurferdrew-pg | 2008-08-28 12:24:56 | Re: WAL files during a backup |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-08-28 14:30:54 | Re: indexes on functions and create or replace function |
Previous Message | Andrew Sullivan | 2008-08-28 13:21:56 | Re: Vaccuum best practice: cronjob or autovaccuum? |