From: | <lnd(at)hnit(dot)is> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: tablespaces a priority for 7.5? |
Date: | 2004-01-22 15:23:26 |
Message-ID: | 0A5B2E3C3A64CA4AB14F76DBCA76DDA44EF9A7@seifur.hnit.is |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Incremental pg_dumps would be a huge step in the right direction!
For big people (meaning bid databases) - not shure if pg_dump is the right
direction. Pg_dump must be quite slow also compact. Raw file copy is the way
to go: quick and simple, virtually no configuration is required, no possible
pg_dump bugs - the latest quite important(of course, no DB version and OS
changes are possible, but not really needed - this is recovery, not
migration).
> However, unless I am mistaken, a baseline backup would need
> to be taken cold because you cannot take a consistent online
> backup of the data files without using file system snapshots
> or split mirrors, and even that's questionable.
That's doable: depends what you have in WAL logs.
In short: a baseline full hot database backup is taken while database is
running, then when recovering WAL logs are put on top of this baseline
backup. WAL logs must actually account for a lot: table, index changes, etc.
>From my understanding, this is done not at SQL level, but at pages level. as
far as I remember the method - a full hot database backup must be taken at
page level as well, i.e. simple OS file copy-utility may not suite for the
purpose.
Regards, Laimis
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Cott Lang
> Sent: 22. janúar 2004 15:00
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] tablespaces a priority for 7.5?
>
>
> On Thu, 2004-01-22 at 07:38, lnd(at)hnit(dot)is wrote:
>
> > Meaning incremental (hot)-backups?
> > Or as protection against DROP/TRUNCATE/DELETE ALL
> > TABLE/SCHEMA/DATABASE?
> >
> > With a WAL it should be doable in some 7.x version, all ingredients
> > are there.
> >
> > Possibly someone suceeded in doing it already? Having a baseline
> > backup and saved WAL logs, shouldn't it be possible to recover?
>
> Incremental pg_dumps would be a huge step in the right direction!
>
> However, unless I am mistaken, a baseline backup would need
> to be taken cold because you cannot take a consistent online
> backup of the data files without using file system snapshots
> or split mirrors, and even that's questionable.
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-01-22 15:35:58 | Re: Lost plpgsql function |
Previous Message | Henk van Lingen | 2004-01-22 15:07:40 | Re: trust auth in 7.4 |