Lists: | pgsql-hackers |
---|
From: | Austin Gonyou <austin(at)coremetrics(dot)com> |
---|---|
To: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | 7.4 hot backup capabilities? |
Date: | 2003-11-12 06:46:41 |
Message-ID: | 1068619601.2775.48.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
What facilities are/will be available for hot(online) backups with the
7.4 release? PITR, something else? TIA.
--
Austin Gonyou <austin(at)coremetrics(dot)com>
Coremetrics, Inc.
From: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> |
---|---|
To: | Austin Gonyou <austin(at)coremetrics(dot)com> |
Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 7.4 hot backup capabilities? |
Date: | 2003-11-12 07:00:04 |
Message-ID: | 3FB1DA74.8060007@myrealbox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Austin Gonyou wrote:
> What facilities are/will be available for hot(online) backups with the
> 7.4 release? PITR, something else? TIA.
pg_dump?
Did you mean hot failover or hot backup? Postgresql does hot backup for a long time.
Bye
Shridhar
From: | Austin Gonyou <austin(at)coremetrics(dot)com> |
---|---|
To: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> |
Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 7.4 hot backup capabilities? |
Date: | 2003-11-12 08:52:21 |
Message-ID: | 1068627141.7210.10.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Wed, 2003-11-12 at 01:00, Shridhar Daithankar wrote:
> Austin Gonyou wrote:
>
> > What facilities are/will be available for hot(online) backups with the
> > 7.4 release? PITR, something else? TIA.
>
> pg_dump?
>
> Did you mean hot failover or hot backup? Postgresql does hot backup for a long time.
I was referring primarly to hot backup. We're migrating from Oracle to
pgsql, and we wanted to know more about this. From our current
understanding, pgsql's hot backup is more of an export, than say, a hot
backup with redo-logs type mode.(i.e. oracle rman). Is there a similar
utility? I didn't think that pg_dump did that functionality as an actual
"backup". i.e. keeps track of block changes while IO is going on and
ensures stuff in process gets backed up as well.
> Bye
> Shridhar
--
Austin Gonyou <austin(at)coremetrics(dot)com>
Coremetrics, Inc.
From: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> |
---|---|
To: | Austin Gonyou <austin(at)coremetrics(dot)com> |
Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 7.4 hot backup capabilities? |
Date: | 2003-11-12 09:22:04 |
Message-ID: | 3FB1FBBC.3060705@myrealbox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Austin Gonyou wrote:
> On Wed, 2003-11-12 at 01:00, Shridhar Daithankar wrote:
>
>>Austin Gonyou wrote:
>>
>>
>>>What facilities are/will be available for hot(online) backups with the
>>>7.4 release? PITR, something else? TIA.
>>
>>pg_dump?
>>
>>Did you mean hot failover or hot backup? Postgresql does hot backup for a long time.
>
>
> I was referring primarly to hot backup. We're migrating from Oracle to
> pgsql, and we wanted to know more about this. From our current
> understanding, pgsql's hot backup is more of an export, than say, a hot
> backup with redo-logs type mode.(i.e. oracle rman). Is there a similar
> utility? I didn't think that pg_dump did that functionality as an actual
> "backup". i.e. keeps track of block changes while IO is going on and
> ensures stuff in process gets backed up as well.
pg_dump takes a snapshot while it starts and it saves the snapshot consistently.
Any ongoing transactions that are not yet committed are not visible to pg_dump
anyways.
Furthermore since the snapshot is consistent, pg_dump does not need redo logs etc.
You can look into asynchronous replications if you want incremental backup.
There is a gborg page for replication projects,
http://gborg.postgresql.org/project/pgreplication/projdisplay.php
pg_dump can be selective but I don't think it can be incremental.
I hope I got your point correctly.
HTH
Shridhar
From: | Doug McNaught <doug(at)mcnaught(dot)org> |
---|---|
To: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> |
Cc: | Austin Gonyou <austin(at)coremetrics(dot)com>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 7.4 hot backup capabilities? |
Date: | 2003-11-12 10:53:10 |
Message-ID: | 8765hpyi21.fsf@asmodeus.mcnaught.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> writes:
> pg_dump can be selective but I don't think it can be incremental.
>
> I hope I got your point correctly.
I think he's really talking about PITR, which will not be in 7.4.
-Doug
From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Austin Gonyou <austin(at)coremetrics(dot)com> |
Cc: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 7.4 hot backup capabilities? |
Date: | 2003-11-12 14:05:29 |
Message-ID: | 3FB23E29.3040804@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Austin Gonyou wrote:
> On Wed, 2003-11-12 at 01:00, Shridhar Daithankar wrote:
>> Austin Gonyou wrote:
>>
>> > What facilities are/will be available for hot(online) backups with the
>> > 7.4 release? PITR, something else? TIA.
>>
>> pg_dump?
>>
>> Did you mean hot failover or hot backup? Postgresql does hot backup for a long time.
>
> I was referring primarly to hot backup. We're migrating from Oracle to
> pgsql, and we wanted to know more about this. From our current
> understanding, pgsql's hot backup is more of an export, than say, a hot
> backup with redo-logs type mode.(i.e. oracle rman). Is there a similar
> utility? I didn't think that pg_dump did that functionality as an actual
> "backup". i.e. keeps track of block changes while IO is going on and
> ensures stuff in process gets backed up as well.
You might want to read section 1.5 of my Slony-I proposal
http://developer.postgresql.org/~wieck/slony1.html
It might take 2-3 months until we have the first BETA. I hope that will
fit your migration projects time table.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #