Обсуждение: Is pg_basebackup also for "regular" backups?

I was reading the documentation for pg_basebackup and it states that
resulting backups "can be used both for point-in-time recovery and as
the starting point for a log shipping or streaming replication standby
servers".

Should pg_basebackup also be used for "regular" backups, or only for
PITR/streaming replication?

Regards,
Daniel Serodio

On Mon, Oct 15, 2012 at 10:15 PM, Daniel Serodio (lists)
<daniel.lists@mandic.com.br> wrote:
> I was reading the documentation for pg_basebackup and it states that
> resulting backups "can be used both for point-in-time recovery and as the
> starting point for a log shipping or streaming replication standby servers".
>
> Should pg_basebackup also be used for "regular" backups, or only for
> PITR/streaming replication?

It's for "regular backups", based off PITR.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Magnus Hagander wrote:

On Mon, Oct 15, 2012 at 10:15 PM, Daniel Serodio (lists)
<daniel.lists@mandic.com.br> wrote:

I was reading the documentation for pg_basebackup and it states that
resulting backups "can be used both for point-in-time recovery and as the
starting point for a log shipping or streaming replication standby servers".

Should pg_basebackup also be used for "regular" backups, or only for
PITR/streaming replication?

It's for "regular backups", based off PITR.

I'm sorry, I don't understand what you mean by "based off PITR". Do I need PITR enabled in order to use pg_basebackup, or do you mean that I won't lose the ability to use PITR after restoring from a backup created with pg_basebackup, or do you mean something else?

Regards,
Daniel Serodio

On 10/15/12 2:06 PM, Daniel Serodio (lists) wrote:
> I'm sorry, I don't understand what you mean by "based off PITR". Do I
> need PITR enabled in order to use pg_basebackup, or do you mean that I
> won't lose the ability to use PITR after restoring from a backup
> created with pg_basebackup, or do you mean something else?


PITR is a recovery technique, allows you to restore the database to an
arbitrary point in time, not neccessarily the latest (so, for instance,
you can recover to just before your overzealous assistant adminstrator
made a total mess of your accounting system).

to utilize PITR, you need A) a base backup, and B) *all* the WAL
archives since that base backup was taken up to the point at which you
wish to recover.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

On Mon, Oct 15, 2012 at 11:28 PM, John R Pierce <pierce@hogranch.com> wrote:
> On 10/15/12 2:06 PM, Daniel Serodio (lists) wrote:
>>
>> I'm sorry, I don't understand what you mean by "based off PITR". Do I need
>> PITR enabled in order to use pg_basebackup, or do you mean that I won't lose
>> the ability to use PITR after restoring from a backup created with
>> pg_basebackup, or do you mean something else?
>
>
>
> PITR is a recovery technique, allows you to restore the database to an
> arbitrary point in time, not neccessarily the latest (so, for instance, you
> can recover to just before your overzealous assistant adminstrator made a
> total mess of your accounting system).
>
> to utilize PITR, you need A) a base backup, and B) *all* the WAL archives
> since that base backup was taken up to the point at which you wish to
> recover.

You can also use pg_basebackup in -x mode in which case you don't need
a WAL archive - the required WAL will be included in the base backup.
This will not allow PITR though, but it will use the PITR technology
to do a one-off backup.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Take a look at the -x option - this solved an issue for me.
Quoting from 9.1:
"Includes the required transaction log files (WAL files) in the
backup. This will include all transaction logs generated during the
backup. If this option is specified, it is possible to start a
postmaster directly in the extracted directory without the need to
consult the log archive, thus making this a completely standalone
backup."

-tom

On Mon, Oct 15, 2012 at 4:06 PM, Daniel Serodio (lists)
<daniel.lists@mandic.com.br> wrote:
> Magnus Hagander wrote:
>
> On Mon, Oct 15, 2012 at 10:15 PM, Daniel Serodio (lists)
> <daniel.lists@mandic.com.br> wrote:
>
> I was reading the documentation for pg_basebackup and it states that
> resulting backups "can be used both for point-in-time recovery and as the
> starting point for a log shipping or streaming replication standby servers".
>
> Should pg_basebackup also be used for "regular" backups, or only for
> PITR/streaming replication?
>
> It's for "regular backups", based off PITR.
>
> I'm sorry, I don't understand what you mean by "based off PITR". Do I need
> PITR enabled in order to use pg_basebackup, or do you mean that I won't lose
> the ability to use PITR after restoring from a backup created with
> pg_basebackup, or do you mean something else?
>
> Regards,
> Daniel Serodio