pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedIncremental Backup of a particular database
15+ messages / 8 participants
[nested] [flat]
* Incremental Backup of a particular database
@ 2007-01-17 13:48 Yogvinder Singh <yogvinder@newgen.co.in>
0 siblings, 1 reply; 15+ messages in thread
From: Yogvinder Singh @ 2007-01-17 13:48 UTC (permalink / raw)
To: pgsql-admin
Hi Ppl,
I have Two PostgreSQL Database Servers. The situation is like this:-
1) On first database server ball the operations (i.e live server) will be done. This server may contain n number of databases.
2) On the second database server, i want to keep one particular database (from the first database server ) and keep it updated to the latest from the First Database Server. I just want to be able to take some sort of incremental backup from the first server and restore it to the second server.
Is this situation feasible. How can i take an incremental backup of a particular database out of many databases? On which version this is supported? IF not supported, is there any alternative way to handle this situatio.
Regards,
Yogvinder Singh,
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-17 14:47 Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
parent: Yogvinder Singh <yogvinder@newgen.co.in>
0 siblings, 2 replies; 15+ messages in thread
From: Andy Shellam (Mailing Lists) @ 2007-01-17 14:47 UTC (permalink / raw)
To: Yogvinder Singh <yogvinder@newgen.co.in>; +Cc: pgsql-admin
I believe the option for a "warm standby" (which sounds like it is what
you need) was made available in 8.2.0.
You'd have to look at the manual though, I haven't had time to
investigate, and I'm not sure whether it's cluster-wide, or
database-specific.
Yogvinder Singh wrote:
> Hi Ppl,
>
> I have Two PostgreSQL Database Servers. The situation is like this:-
> 1) On first database server ball the operations (i.e live server) will
> be done. This server may contain n number of databases.
>
> 2) On the second database server, i want to keep one particular
> database (from the first database server ) and keep it updated to the
> latest from the First Database Server. I just want to be able to take
> some sort of incremental backup from the first server and restore it
> to the second server.
>
> Is this situation feasible. How can i take an incremental backup of a
> particular database out of many databases? On which version this is
> supported? IF not supported, is there any alternative way to handle
> this situatio.
>
> Regards,
> Yogvinder Singh,
> !DSPAM:37,45ae2b2f137105304223843! Disclaimer :- This e-mail message
> including any attachment may contain confidential, proprietary or
> legally privileged information. It should not be used by who is not
> the original intended recipient. If you have erroneously received this
> message, you are notified that you are strictly prohibited from using,
> copying, altering or disclosing the content of this message. Please
> delete it immediately and notify the sender. Newgen Software
> Technologies Ltd and / or its subsidiary Companies accept no
> responsibility for loss or damage arising from the use of the
> information transmitted by this email including damage from virus and
> further acknowledges that any views expressed in this message are
> those of the individual sender and no binding nature of the message
> shall be implied or assumed unless the sender does so expressly with
> due authority of Newgen Software Technologies Ltd and / or its
> subsidiary Companies, as applicable.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-17 15:04 Shoaib Mir <shoaibmir@gmail.com>
parent: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
1 sibling, 1 reply; 15+ messages in thread
From: Shoaib Mir @ 2007-01-17 15:04 UTC (permalink / raw)
To: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>; +Cc: Yogvinder Singh <yogvinder@newgen.co.in>; pgsql-admin
Even with ver 8.1 you can use WAL archive backups (PITR) to implement an
incremental backup strategy.
-------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/17/07, Andy Shellam (Mailing Lists) <
andy.shellam-lists@mailnetwork.co.uk> wrote:
>
> I believe the option for a "warm standby" (which sounds like it is what
> you need) was made available in 8.2.0.
> You'd have to look at the manual though, I haven't had time to
> investigate, and I'm not sure whether it's cluster-wide, or
> database-specific.
>
>
> Yogvinder Singh wrote:
> > Hi Ppl,
> >
> > I have Two PostgreSQL Database Servers. The situation is like this:-
> > 1) On first database server ball the operations (i.e live server) will
> > be done. This server may contain n number of databases.
> >
> > 2) On the second database server, i want to keep one particular
> > database (from the first database server ) and keep it updated to the
> > latest from the First Database Server. I just want to be able to take
> > some sort of incremental backup from the first server and restore it
> > to the second server.
> >
> > Is this situation feasible. How can i take an incremental backup of a
> > particular database out of many databases? On which version this is
> > supported? IF not supported, is there any alternative way to handle
> > this situatio.
> >
> > Regards,
> > Yogvinder Singh,
> > !DSPAM:37,45ae2b2f137105304223843! Disclaimer :- This e-mail message
> > including any attachment may contain confidential, proprietary or
> > legally privileged information. It should not be used by who is not
> > the original intended recipient. If you have erroneously received this
> > message, you are notified that you are strictly prohibited from using,
> > copying, altering or disclosing the content of this message. Please
> > delete it immediately and notify the sender. Newgen Software
> > Technologies Ltd and / or its subsidiary Companies accept no
> > responsibility for loss or damage arising from the use of the
> > information transmitted by this email including damage from virus and
> > further acknowledges that any views expressed in this message are
> > those of the individual sender and no binding nature of the message
> > shall be implied or assumed unless the sender does so expressly with
> > due authority of Newgen Software Technologies Ltd and / or its
> > subsidiary Companies, as applicable.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-17 15:15 Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
parent: Shoaib Mir <shoaibmir@gmail.com>
0 siblings, 1 reply; 15+ messages in thread
From: Andy Shellam (Mailing Lists) @ 2007-01-17 15:15 UTC (permalink / raw)
To: Shoaib Mir <shoaibmir@gmail.com>; +Cc: Yogvinder Singh <yogvinder@newgen.co.in>; pgsql-admin
Shoaib Mir wrote:
> Even with ver 8.1 you can use WAL archive backups (PITR) to implement
> an incremental backup strategy.
Yes, true, but it's harder with 8.1 as you always have to start from a
base backup and roll WAL logs forward - without a custom script you
cannot "wait" for new WAL logs to arrive and apply them on top of a base
backup.
There is a project in PgFoundry to allow for warm-standby in the 8.0 and
8.1 series, however this is reportedly built-in to 8.2 now.
>
> -------------
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com <http://www.enterprisedb.com;)
>
> On 1/17/07, *Andy Shellam (Mailing Lists)*
> <andy.shellam-lists@mailnetwork.co.uk
> <mailto:andy.shellam-lists@mailnetwork.co.uk>> wrote:
>
> I believe the option for a "warm standby" (which sounds like it is
> what
> you need) was made available in 8.2.0.
> You'd have to look at the manual though, I haven't had time to
> investigate, and I'm not sure whether it's cluster-wide, or
> database-specific.
>
>
> Yogvinder Singh wrote:
> > Hi Ppl,
> >
> > I have Two PostgreSQL Database Servers. The situation is like this:-
> > 1) On first database server ball the operations (i.e live
> server) will
> > be done. This server may contain n number of databases.
> >
> > 2) On the second database server, i want to keep one particular
> > database (from the first database server ) and keep it updated
> to the
> > latest from the First Database Server. I just want to be able to
> take
> > some sort of incremental backup from the first server and restore it
> > to the second server.
> >
> > Is this situation feasible. How can i take an incremental backup
> of a
> > particular database out of many databases? On which version this is
> > supported? IF not supported, is there any alternative way to handle
> > this situatio.
> >
> > Regards,
> > Yogvinder Singh,
> > Disclaimer :- This e-mail message
> > including any attachment may contain confidential, proprietary or
> > legally privileged information. It should not be used by who is not
> > the original intended recipient. If you have erroneously
> received this
> > message, you are notified that you are strictly prohibited from
> using,
> > copying, altering or disclosing the content of this message. Please
> > delete it immediately and notify the sender. Newgen Software
> > Technologies Ltd and / or its subsidiary Companies accept no
> > responsibility for loss or damage arising from the use of the
> > information transmitted by this email including damage from
> virus and
> > further acknowledges that any views expressed in this message are
> > those of the individual sender and no binding nature of the message
> > shall be implied or assumed unless the sender does so expressly
> with
> > due authority of Newgen Software Technologies Ltd and / or its
> > subsidiary Companies, as applicable.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
> !DSPAM:37,45ae3b61137103926781350!
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-17 15:23 Shoaib Mir <shoaibmir@gmail.com>
parent: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
0 siblings, 1 reply; 15+ messages in thread
From: Shoaib Mir @ 2007-01-17 15:23 UTC (permalink / raw)
To: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>; +Cc: Yogvinder Singh <yogvinder@newgen.co.in>; pgsql-admin
Yes, I guess that is true with 8.2 but with a few configurations for WAL
copying scripts.
Saw the following in documentation that specifies a good flow for doing it
--> http://www.postgresql.org/docs/8.2/static/warm-standby.html
---------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/17/07, Andy Shellam (Mailing Lists) <
andy.shellam-lists@mailnetwork.co.uk> wrote:
>
> Shoaib Mir wrote:
> > Even with ver 8.1 you can use WAL archive backups (PITR) to implement
> > an incremental backup strategy.
> Yes, true, but it's harder with 8.1 as you always have to start from a
> base backup and roll WAL logs forward - without a custom script you
> cannot "wait" for new WAL logs to arrive and apply them on top of a base
> backup.
> There is a project in PgFoundry to allow for warm-standby in the 8.0 and
> 8.1 series, however this is reportedly built-in to 8.2 now.
> >
> > -------------
> > Shoaib Mir
> > EnterpriseDB (www.enterprisedb.com <http://www.enterprisedb.com;)
> >
> > On 1/17/07, *Andy Shellam (Mailing Lists)*
> > <andy.shellam-lists@mailnetwork.co.uk
> > <mailto:andy.shellam-lists@mailnetwork.co.uk>> wrote:
> >
> > I believe the option for a "warm standby" (which sounds like it is
> > what
> > you need) was made available in 8.2.0.
> > You'd have to look at the manual though, I haven't had time to
> > investigate, and I'm not sure whether it's cluster-wide, or
> > database-specific.
> >
> >
> > Yogvinder Singh wrote:
> > > Hi Ppl,
> > >
> > > I have Two PostgreSQL Database Servers. The situation is like
> this:-
> > > 1) On first database server ball the operations (i.e live
> > server) will
> > > be done. This server may contain n number of databases.
> > >
> > > 2) On the second database server, i want to keep one particular
> > > database (from the first database server ) and keep it updated
> > to the
> > > latest from the First Database Server. I just want to be able to
> > take
> > > some sort of incremental backup from the first server and restore
> it
> > > to the second server.
> > >
> > > Is this situation feasible. How can i take an incremental backup
> > of a
> > > particular database out of many databases? On which version this
> is
> > > supported? IF not supported, is there any alternative way to
> handle
> > > this situatio.
> > >
> > > Regards,
> > > Yogvinder Singh,
> > > Disclaimer :- This e-mail message
> > > including any attachment may contain confidential, proprietary or
> > > legally privileged information. It should not be used by who is
> not
> > > the original intended recipient. If you have erroneously
> > received this
> > > message, you are notified that you are strictly prohibited from
> > using,
> > > copying, altering or disclosing the content of this message.
> Please
> > > delete it immediately and notify the sender. Newgen Software
> > > Technologies Ltd and / or its subsidiary Companies accept no
> > > responsibility for loss or damage arising from the use of the
> > > information transmitted by this email including damage from
> > virus and
> > > further acknowledges that any views expressed in this message are
> > > those of the individual sender and no binding nature of the
> message
> > > shall be implied or assumed unless the sender does so expressly
> > with
> > > due authority of Newgen Software Technologies Ltd and / or its
> > > subsidiary Companies, as applicable.
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
> >
> >
> > !DSPAM:37,45ae3b61137103926781350!
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-18 04:09 Eduardo J. Ortega <ejortegau@cable.net.co>
parent: Shoaib Mir <shoaibmir@gmail.com>
0 siblings, 1 reply; 15+ messages in thread
From: Eduardo J. Ortega @ 2007-01-18 04:09 UTC (permalink / raw)
To: pgsql-admin
Not sure, but i think WAL based incremental backup is for the whole database
cluster, and not for an specific database, so don't think this is going to
work for you. Is yoor database too large? If not, you could stick to the old
fashioned pg_dump output.
On Wednesday 17 January 2007 10:23, Shoaib Mir wrote:
> Yes, I guess that is true with 8.2 but with a few configurations for WAL
> copying scripts.
>
> Saw the following in documentation that specifies a good flow for doing it
> --> http://www.postgresql.org/docs/8.2/static/warm-standby.html
>
> ---------------
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 1/17/07, Andy Shellam (Mailing Lists) <
>
> andy.shellam-lists@mailnetwork.co.uk> wrote:
> > Shoaib Mir wrote:
> > > Even with ver 8.1 you can use WAL archive backups (PITR) to implement
> > > an incremental backup strategy.
> >
> > Yes, true, but it's harder with 8.1 as you always have to start from a
> > base backup and roll WAL logs forward - without a custom script you
> > cannot "wait" for new WAL logs to arrive and apply them on top of a base
> > backup.
> > There is a project in PgFoundry to allow for warm-standby in the 8.0 and
> > 8.1 series, however this is reportedly built-in to 8.2 now.
> >
> > > -------------
> > > Shoaib Mir
> > > EnterpriseDB (www.enterprisedb.com <http://www.enterprisedb.com;)
> > >
> > > On 1/17/07, *Andy Shellam (Mailing Lists)*
> > > <andy.shellam-lists@mailnetwork.co.uk
> > > <mailto:andy.shellam-lists@mailnetwork.co.uk>> wrote:
> > >
> > > I believe the option for a "warm standby" (which sounds like it is
> > > what
> > > you need) was made available in 8.2.0.
> > > You'd have to look at the manual though, I haven't had time to
> > > investigate, and I'm not sure whether it's cluster-wide, or
> > > database-specific.
> > >
> > > Yogvinder Singh wrote:
> > > > Hi Ppl,
> > > >
> > > > I have Two PostgreSQL Database Servers. The situation is like
> >
> > this:-
> >
> > > > 1) On first database server ball the operations (i.e live
> > >
> > > server) will
> > >
> > > > be done. This server may contain n number of databases.
> > > >
> > > > 2) On the second database server, i want to keep one particular
> > > > database (from the first database server ) and keep it updated
> > >
> > > to the
> > >
> > > > latest from the First Database Server. I just want to be able to
> > >
> > > take
> > >
> > > > some sort of incremental backup from the first server and restore
> >
> > it
> >
> > > > to the second server.
> > > >
> > > > Is this situation feasible. How can i take an incremental backup
> > >
> > > of a
> > >
> > > > particular database out of many databases? On which version this
> >
> > is
> >
> > > > supported? IF not supported, is there any alternative way to
> >
> > handle
> >
> > > > this situatio.
> > > >
> > > > Regards,
> > > > Yogvinder Singh,
> > > > Disclaimer :- This e-mail message
> > > > including any attachment may contain confidential, proprietary or
> > > > legally privileged information. It should not be used by who is
> >
> > not
> >
> > > > the original intended recipient. If you have erroneously
> > >
> > > received this
> > >
> > > > message, you are notified that you are strictly prohibited from
> > >
> > > using,
> > >
> > > > copying, altering or disclosing the content of this message.
> >
> > Please
> >
> > > > delete it immediately and notify the sender. Newgen Software
> > > > Technologies Ltd and / or its subsidiary Companies accept no
> > > > responsibility for loss or damage arising from the use of the
> > > > information transmitted by this email including damage from
> > >
> > > virus and
> > >
> > > > further acknowledges that any views expressed in this message are
> > > > those of the individual sender and no binding nature of the
> >
> > message
> >
> > > > shall be implied or assumed unless the sender does so expressly
> > >
> > > with
> > >
> > > > due authority of Newgen Software Technologies Ltd and / or its
> > > > subsidiary Companies, as applicable.
> > >
> > > ---------------------------(end of
> > > broadcast)---------------------------
> > > TIP 3: Have you checked our extensive FAQ?
> > >
> > > http://www.postgresql.org/docs/faq
> > >
> > >
> > > !DSPAM:37,45ae3b61137103926781350!
--
Eduardo J. Ortega - Linux user #222873
"No fake - I'm a big fan of konqueror, and I use it for everything." -- Linus
Torvalds
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-18 05:14 Yogvinder Singh <yogvinder@newgen.co.in>
parent: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
1 sibling, 1 reply; 15+ messages in thread
From: Yogvinder Singh @ 2007-01-18 05:14 UTC (permalink / raw)
To: Andy Shellam \(Mailing Lists\) <andy.shellam-lists@mailnetwork.co.uk>; +Cc: pgsql-admin
I only want one of many databases to be restored to the other server
incrementally.
Is this possible?
If yes, Wht are the steps??
Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
Tel no 26815467 Ext 143
----- Original Message -----
From: "Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>
To: "Yogvinder Singh" <yogvinder@newgen.co.in>
Cc: <pgsql-admin@postgresql.org>
Sent: Wednesday, January 17, 2007 8:17 PM
Subject: Re: [ADMIN] Incremental Backup of a particular database
> I believe the option for a "warm standby" (which sounds like it is what
> you need) was made available in 8.2.0.
> You'd have to look at the manual though, I haven't had time to
> investigate, and I'm not sure whether it's cluster-wide, or
> database-specific.
>
>
> Yogvinder Singh wrote:
> > Hi Ppl,
> >
> > I have Two PostgreSQL Database Servers. The situation is like this:-
> > 1) On first database server ball the operations (i.e live server) will
> > be done. This server may contain n number of databases.
> >
> > 2) On the second database server, i want to keep one particular
> > database (from the first database server ) and keep it updated to the
> > latest from the First Database Server. I just want to be able to take
> > some sort of incremental backup from the first server and restore it
> > to the second server.
> >
> > Is this situation feasible. How can i take an incremental backup of a
> > particular database out of many databases? On which version this is
> > supported? IF not supported, is there any alternative way to handle
> > this situatio.
> >
> > Regards,
> > Yogvinder Singh,
> > !DSPAM:37,45ae2b2f137105304223843! Disclaimer :- This e-mail message
> > including any attachment may contain confidential, proprietary or
> > legally privileged information. It should not be used by who is not
> > the original intended recipient. If you have erroneously received this
> > message, you are notified that you are strictly prohibited from using,
> > copying, altering or disclosing the content of this message. Please
> > delete it immediately and notify the sender. Newgen Software
> > Technologies Ltd and / or its subsidiary Companies accept no
> > responsibility for loss or damage arising from the use of the
> > information transmitted by this email including damage from virus and
> > further acknowledges that any views expressed in this message are
> > those of the individual sender and no binding nature of the message
> > shall be implied or assumed unless the sender does so expressly with
> > due authority of Newgen Software Technologies Ltd and / or its
> > subsidiary Companies, as applicable.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-18 05:30 Yogvinder Singh <yogvinder@newgen.co.in>
parent: Eduardo J. Ortega <ejortegau@cable.net.co>
0 siblings, 0 replies; 15+ messages in thread
From: Yogvinder Singh @ 2007-01-18 05:30 UTC (permalink / raw)
To: Eduardo J. Ortega <ejortegau@cable.net.co>; pgsql-admin
Yes Database size is going to grow very large over time. The situation is
going to be like this that ther is one central server where n nr of
databases are there.
I want one of these databases to be restored to the Other database Server.
What i have found so far implies tht the whole of database server will be
restored not one particular database.
Any light on this ??
Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
Tel no 26815467 Ext 143
----- Original Message -----
From: "Eduardo J. Ortega" <ejortegau@cable.net.co>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, January 18, 2007 9:39 AM
Subject: Re: [ADMIN] Incremental Backup of a particular database
> Not sure, but i think WAL based incremental backup is for the whole
database
> cluster, and not for an specific database, so don't think this is going to
> work for you. Is yoor database too large? If not, you could stick to the
old
> fashioned pg_dump output.
>
> On Wednesday 17 January 2007 10:23, Shoaib Mir wrote:
> > Yes, I guess that is true with 8.2 but with a few configurations for WAL
> > copying scripts.
> >
> > Saw the following in documentation that specifies a good flow for doing
it
> > --> http://www.postgresql.org/docs/8.2/static/warm-standby.html
> >
> > ---------------
> > Shoaib Mir
> > EnterpriseDB (www.enterprisedb.com)
> >
> > On 1/17/07, Andy Shellam (Mailing Lists) <
> >
> > andy.shellam-lists@mailnetwork.co.uk> wrote:
> > > Shoaib Mir wrote:
> > > > Even with ver 8.1 you can use WAL archive backups (PITR) to
implement
> > > > an incremental backup strategy.
> > >
> > > Yes, true, but it's harder with 8.1 as you always have to start from a
> > > base backup and roll WAL logs forward - without a custom script you
> > > cannot "wait" for new WAL logs to arrive and apply them on top of a
base
> > > backup.
> > > There is a project in PgFoundry to allow for warm-standby in the 8.0
and
> > > 8.1 series, however this is reportedly built-in to 8.2 now.
> > >
> > > > -------------
> > > > Shoaib Mir
> > > > EnterpriseDB (www.enterprisedb.com <http://www.enterprisedb.com;)
> > > >
> > > > On 1/17/07, *Andy Shellam (Mailing Lists)*
> > > > <andy.shellam-lists@mailnetwork.co.uk
> > > > <mailto:andy.shellam-lists@mailnetwork.co.uk>> wrote:
> > > >
> > > > I believe the option for a "warm standby" (which sounds like it
is
> > > > what
> > > > you need) was made available in 8.2.0.
> > > > You'd have to look at the manual though, I haven't had time to
> > > > investigate, and I'm not sure whether it's cluster-wide, or
> > > > database-specific.
> > > >
> > > > Yogvinder Singh wrote:
> > > > > Hi Ppl,
> > > > >
> > > > > I have Two PostgreSQL Database Servers. The situation is like
> > >
> > > this:-
> > >
> > > > > 1) On first database server ball the operations (i.e live
> > > >
> > > > server) will
> > > >
> > > > > be done. This server may contain n number of databases.
> > > > >
> > > > > 2) On the second database server, i want to keep one
particular
> > > > > database (from the first database server ) and keep it
updated
> > > >
> > > > to the
> > > >
> > > > > latest from the First Database Server. I just want to be able
to
> > > >
> > > > take
> > > >
> > > > > some sort of incremental backup from the first server and
restore
> > >
> > > it
> > >
> > > > > to the second server.
> > > > >
> > > > > Is this situation feasible. How can i take an incremental
backup
> > > >
> > > > of a
> > > >
> > > > > particular database out of many databases? On which version
this
> > >
> > > is
> > >
> > > > > supported? IF not supported, is there any alternative way to
> > >
> > > handle
> > >
> > > > > this situatio.
> > > > >
> > > > > Regards,
> > > > > Yogvinder Singh,
> > > > > Disclaimer :- This e-mail message
> > > > > including any attachment may contain confidential, proprietary
or
> > > > > legally privileged information. It should not be used by who
is
> > >
> > > not
> > >
> > > > > the original intended recipient. If you have erroneously
> > > >
> > > > received this
> > > >
> > > > > message, you are notified that you are strictly prohibited
from
> > > >
> > > > using,
> > > >
> > > > > copying, altering or disclosing the content of this message.
> > >
> > > Please
> > >
> > > > > delete it immediately and notify the sender. Newgen Software
> > > > > Technologies Ltd and / or its subsidiary Companies accept no
> > > > > responsibility for loss or damage arising from the use of the
> > > > > information transmitted by this email including damage from
> > > >
> > > > virus and
> > > >
> > > > > further acknowledges that any views expressed in this message
are
> > > > > those of the individual sender and no binding nature of the
> > >
> > > message
> > >
> > > > > shall be implied or assumed unless the sender does so
expressly
> > > >
> > > > with
> > > >
> > > > > due authority of Newgen Software Technologies Ltd and / or its
> > > > > subsidiary Companies, as applicable.
> > > >
> > > > ---------------------------(end of
> > > > broadcast)---------------------------
> > > > TIP 3: Have you checked our extensive FAQ?
> > > >
> > > > http://www.postgresql.org/docs/faq
> > > >
> > > >
> > > > !DSPAM:37,45ae3b61137103926781350!
>
> --
> Eduardo J. Ortega - Linux user #222873
> "No fake - I'm a big fan of konqueror, and I use it for everything." --
Linus
> Torvalds
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-18 05:59 Yogvinder Singh <yogvinder@newgen.co.in>
parent: Yogvinder Singh <yogvinder@newgen.co.in>
0 siblings, 2 replies; 15+ messages in thread
From: Yogvinder Singh @ 2007-01-18 05:59 UTC (permalink / raw)
To: pgsql-admin
pg_dump is a utility for saving a PostgreSQL database into a script or an
archive file. The script files are in plain-text format and contain the SQL
commands required to reconstruct the database to the state it was in
at the time it was saved.
"At the time it was saved" What is the meaning of this statement?
Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
New Delhi
Tel no 26815467 Ext 143
----- Original Message -----
From: "Yogvinder Singh" <yogvinder@newgen.co.in>
To: "Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>
Cc: <pgsql-admin@postgresql.org>
Sent: Thursday, January 18, 2007 10:44 AM
Subject: Re: [ADMIN] Incremental Backup of a particular database
> I only want one of many databases to be restored to the other server
> incrementally.
> Is this possible?
> If yes, Wht are the steps??
>
> Regards,
> Yogvinder Singh,
> Software Engineer, E-WorkStyle Group,
> Newgen Software Technologies Ltd.
> D-152, Okhla Phase - 1
> Tel no 26815467 Ext 143
>
>
> ----- Original Message -----
> From: "Andy Shellam (Mailing Lists)"
<andy.shellam-lists@mailnetwork.co.uk>
> To: "Yogvinder Singh" <yogvinder@newgen.co.in>
> Cc: <pgsql-admin@postgresql.org>
> Sent: Wednesday, January 17, 2007 8:17 PM
> Subject: Re: [ADMIN] Incremental Backup of a particular database
>
>
> > I believe the option for a "warm standby" (which sounds like it is what
> > you need) was made available in 8.2.0.
> > You'd have to look at the manual though, I haven't had time to
> > investigate, and I'm not sure whether it's cluster-wide, or
> > database-specific.
> >
> >
> > Yogvinder Singh wrote:
> > > Hi Ppl,
> > >
> > > I have Two PostgreSQL Database Servers. The situation is like this:-
> > > 1) On first database server ball the operations (i.e live server) will
> > > be done. This server may contain n number of databases.
> > >
> > > 2) On the second database server, i want to keep one particular
> > > database (from the first database server ) and keep it updated to the
> > > latest from the First Database Server. I just want to be able to take
> > > some sort of incremental backup from the first server and restore it
> > > to the second server.
> > >
> > > Is this situation feasible. How can i take an incremental backup of a
> > > particular database out of many databases? On which version this is
> > > supported? IF not supported, is there any alternative way to handle
> > > this situatio.
> > >
> > > Regards,
> > > Yogvinder Singh,
> > > !DSPAM:37,45ae2b2f137105304223843! Disclaimer :- This e-mail message
> > > including any attachment may contain confidential, proprietary or
> > > legally privileged information. It should not be used by who is not
> > > the original intended recipient. If you have erroneously received this
> > > message, you are notified that you are strictly prohibited from using,
> > > copying, altering or disclosing the content of this message. Please
> > > delete it immediately and notify the sender. Newgen Software
> > > Technologies Ltd and / or its subsidiary Companies accept no
> > > responsibility for loss or damage arising from the use of the
> > > information transmitted by this email including damage from virus and
> > > further acknowledges that any views expressed in this message are
> > > those of the individual sender and no binding nature of the message
> > > shall be implied or assumed unless the sender does so expressly with
> > > due authority of Newgen Software Technologies Ltd and / or its
> > > subsidiary Companies, as applicable.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
> >
>
>
>
> Disclaimer :- This e-mail message including any attachment may contain
confidential, proprietary or legally privileged information. It should not
be used by who is not the original intended recipient. If you have
erroneously received this message, you are notified that you are strictly
prohibited from using, copying, altering or disclosing the content of this
message. Please delete it immediately and notify the sender. Newgen Software
Technologies Ltd and / or its subsidiary Companies accept no responsibility
for loss or damage arising from the use of the information transmitted by
this email including damage from virus and further acknowledges that any
views expressed in this message are those of the individual sender and no
binding nature of the message shall be implied or assumed unless the sender
does so expressly with due authority of Newgen Software Technologies Ltd and
/ or its subsidiary Companies, as applicable.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-18 10:37 Shoaib Mir <shoaibmir@gmail.com>
parent: Yogvinder Singh <yogvinder@newgen.co.in>
1 sibling, 1 reply; 15+ messages in thread
From: Shoaib Mir @ 2007-01-18 10:37 UTC (permalink / raw)
To: Yogvinder Singh <yogvinder@newgen.co.in>; +Cc: pgsql-admin
When the pg_dump process starts it takes one point and then makes a backup
for that specific time even if more updates on the database are happening
during the pg_dump process. So when you restore on the other machine it will
restore to that specific time when the pg_dump process started.
----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/18/07, Yogvinder Singh <yogvinder@newgen.co.in> wrote:
>
> pg_dump is a utility for saving a PostgreSQL database into a script or an
> archive file. The script files are in plain-text format and contain the
> SQL
> commands required to reconstruct the database to the state it
> was in
> at the time it was saved.
>
> "At the time it was saved" What is the meaning of this statement?
>
>
> Regards,
> Yogvinder Singh,
> Software Engineer, E-WorkStyle Group,
> Newgen Software Technologies Ltd.
> D-152, Okhla Phase - 1
> New Delhi
> Tel no 26815467 Ext 143
>
>
> ----- Original Message -----
> From: "Yogvinder Singh" <yogvinder@newgen.co.in>
> To: "Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>
> Cc: <pgsql-admin@postgresql.org>
> Sent: Thursday, January 18, 2007 10:44 AM
> Subject: Re: [ADMIN] Incremental Backup of a particular database
>
>
> > I only want one of many databases to be restored to the other server
> > incrementally.
> > Is this possible?
> > If yes, Wht are the steps??
> >
> > Regards,
> > Yogvinder Singh,
> > Software Engineer, E-WorkStyle Group,
> > Newgen Software Technologies Ltd.
> > D-152, Okhla Phase - 1
> > Tel no 26815467 Ext 143
> >
> >
> > ----- Original Message -----
> > From: "Andy Shellam (Mailing Lists)"
> <andy.shellam-lists@mailnetwork.co.uk>
> > To: "Yogvinder Singh" <yogvinder@newgen.co.in>
> > Cc: <pgsql-admin@postgresql.org>
> > Sent: Wednesday, January 17, 2007 8:17 PM
> > Subject: Re: [ADMIN] Incremental Backup of a particular database
> >
> >
> > > I believe the option for a "warm standby" (which sounds like it is
> what
> > > you need) was made available in 8.2.0.
> > > You'd have to look at the manual though, I haven't had time to
> > > investigate, and I'm not sure whether it's cluster-wide, or
> > > database-specific.
> > >
> > >
> > > Yogvinder Singh wrote:
> > > > Hi Ppl,
> > > >
> > > > I have Two PostgreSQL Database Servers. The situation is like this:-
> > > > 1) On first database server ball the operations (i.e live server)
> will
> > > > be done. This server may contain n number of databases.
> > > >
> > > > 2) On the second database server, i want to keep one particular
> > > > database (from the first database server ) and keep it updated to
> the
> > > > latest from the First Database Server. I just want to be able to
> take
> > > > some sort of incremental backup from the first server and restore it
> > > > to the second server.
> > > >
> > > > Is this situation feasible. How can i take an incremental backup of
> a
> > > > particular database out of many databases? On which version this is
> > > > supported? IF not supported, is there any alternative way to handle
> > > > this situatio.
> > > >
> > > > Regards,
> > > > Yogvinder Singh,
> > > > !DSPAM:37,45ae2b2f137105304223843! Disclaimer :- This e-mail message
> > > > including any attachment may contain confidential, proprietary or
> > > > legally privileged information. It should not be used by who is not
> > > > the original intended recipient. If you have erroneously received
> this
> > > > message, you are notified that you are strictly prohibited from
> using,
> > > > copying, altering or disclosing the content of this message. Please
> > > > delete it immediately and notify the sender. Newgen Software
> > > > Technologies Ltd and / or its subsidiary Companies accept no
> > > > responsibility for loss or damage arising from the use of the
> > > > information transmitted by this email including damage from virus
> and
> > > > further acknowledges that any views expressed in this message are
> > > > those of the individual sender and no binding nature of the message
> > > > shall be implied or assumed unless the sender does so expressly with
> > > > due authority of Newgen Software Technologies Ltd and / or its
> > > > subsidiary Companies, as applicable.
> > >
> > > ---------------------------(end of
> broadcast)---------------------------
> > > TIP 3: Have you checked our extensive FAQ?
> > >
> > > http://www.postgresql.org/docs/faq
> > >
> >
> >
> >
> > Disclaimer :- This e-mail message including any attachment may contain
> confidential, proprietary or legally privileged information. It should not
> be used by who is not the original intended recipient. If you have
> erroneously received this message, you are notified that you are strictly
> prohibited from using, copying, altering or disclosing the content of this
> message. Please delete it immediately and notify the sender. Newgen
> Software
> Technologies Ltd and / or its subsidiary Companies accept no
> responsibility
> for loss or damage arising from the use of the information transmitted by
> this email including damage from virus and further acknowledges that any
> views expressed in this message are those of the individual sender and no
> binding nature of the message shall be implied or assumed unless the
> sender
> does so expressly with due authority of Newgen Software Technologies Ltd
> and
> / or its subsidiary Companies, as applicable.
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: explain analyze is your friend
> >
>
>
>
> Disclaimer :- This e-mail message including any attachment may contain
> confidential, proprietary or legally privileged information. It should not
> be used by who is not the original intended recipient. If you have
> erroneously received this message, you are notified that you are strictly
> prohibited from using, copying, altering or disclosing the content of this
> message. Please delete it immediately and notify the sender. Newgen Software
> Technologies Ltd and / or its subsidiary Companies accept no responsibility
> for loss or damage arising from the use of the information transmitted by
> this email including damage from virus and further acknowledges that any
> views expressed in this message are those of the individual sender and no
> binding nature of the message shall be implied or assumed unless the sender
> does so expressly with due authority of Newgen Software Technologies Ltd and
> / or its subsidiary Companies, as applicable.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-18 11:23 Yogvinder Singh <yogvinder@newgen.co.in>
parent: Shoaib Mir <shoaibmir@gmail.com>
0 siblings, 2 replies; 15+ messages in thread
From: Yogvinder Singh @ 2007-01-18 11:23 UTC (permalink / raw)
To: Shoaib Mir <shoaibmir@gmail.com>; +Cc: pgsql-admin
So it means there is no way i can take incremental backup of one of the databases from a postgresql database server??
Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
New Delhi
Tel no 26815467 Ext 143
----- Original Message -----
From: Shoaib Mir
To: Yogvinder Singh
Cc: pgsql-admin@postgresql.org
Sent: Thursday, January 18, 2007 4:07 PM
Subject: Re: [ADMIN] Incremental Backup of a particular database
When the pg_dump process starts it takes one point and then makes a backup for that specific time even if more updates on the database are happening during the pg_dump process. So when you restore on the other machine it will restore to that specific time when the pg_dump process started.
----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/18/07, Yogvinder Singh < yogvinder@newgen.co.in> wrote:
pg_dump is a utility for saving a PostgreSQL database into a script or an
archive file. The script files are in plain-text format and contain the SQL
commands required to reconstruct the database to the state it was in
at the time it was saved.
"At the time it was saved" What is the meaning of this statement?
Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
New Delhi
Tel no 26815467 Ext 143
----- Original Message -----
From: "Yogvinder Singh" <yogvinder@newgen.co.in>
To: "Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk >
Cc: <pgsql-admin@postgresql.org>
Sent: Thursday, January 18, 2007 10:44 AM
Subject: Re: [ADMIN] Incremental Backup of a particular database
> I only want one of many databases to be restored to the other server
> incrementally.
> Is this possible?
> If yes, Wht are the steps??
>
> Regards,
> Yogvinder Singh,
> Software Engineer, E-WorkStyle Group,
> Newgen Software Technologies Ltd.
> D-152, Okhla Phase - 1
> Tel no 26815467 Ext 143
>
>
> ----- Original Message -----
> From: "Andy Shellam (Mailing Lists)"
< andy.shellam-lists@mailnetwork.co.uk>
> To: "Yogvinder Singh" <yogvinder@newgen.co.in>
> Cc: < pgsql-admin@postgresql.org>
> Sent: Wednesday, January 17, 2007 8:17 PM
> Subject: Re: [ADMIN] Incremental Backup of a particular database
>
>
> > I believe the option for a "warm standby" (which sounds like it is what
> > you need) was made available in 8.2.0.
> > You'd have to look at the manual though, I haven't had time to
> > investigate, and I'm not sure whether it's cluster-wide, or
> > database-specific.
> >
> >
> > Yogvinder Singh wrote:
> > > Hi Ppl,
> > >
> > > I have Two PostgreSQL Database Servers. The situation is like this:-
> > > 1) On first database server ball the operations (i.e live server) will
> > > be done. This server may contain n number of databases.
> > >
> > > 2) On the second database server, i want to keep one particular
> > > database (from the first database server ) and keep it updated to the
> > > latest from the First Database Server. I just want to be able to take
> > > some sort of incremental backup from the first server and restore it
> > > to the second server.
> > >
> > > Is this situation feasible. How can i take an incremental backup of a
> > > particular database out of many databases? On which version this is
> > > supported? IF not supported, is there any alternative way to handle
> > > this situatio.
> > >
> > > Regards,
> > > Yogvinder Singh,
> > > !DSPAM:37,45ae2b2f137105304223843! Disclaimer :- This e-mail message
> > > including any attachment may contain confidential, proprietary or
> > > legally privileged information. It should not be used by who is not
> > > the original intended recipient. If you have erroneously received this
> > > message, you are notified that you are strictly prohibited from using,
> > > copying, altering or disclosing the content of this message. Please
> > > delete it immediately and notify the sender. Newgen Software
> > > Technologies Ltd and / or its subsidiary Companies accept no
> > > responsibility for loss or damage arising from the use of the
> > > information transmitted by this email including damage from virus and
> > > further acknowledges that any views expressed in this message are
> > > those of the individual sender and no binding nature of the message
> > > shall be implied or assumed unless the sender does so expressly with
> > > due authority of Newgen Software Technologies Ltd and / or its
> > > subsidiary Companies, as applicable.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
> >
>
>
>
> Disclaimer :- This e-mail message including any attachment may contain
confidential, proprietary or legally privileged information. It should not
be used by who is not the original intended recipient. If you have
erroneously received this message, you are notified that you are strictly
prohibited from using, copying, altering or disclosing the content of this
message. Please delete it immediately and notify the sender. Newgen Software
Technologies Ltd and / or its subsidiary Companies accept no responsibility
for loss or damage arising from the use of the information transmitted by
this email including damage from virus and further acknowledges that any
views expressed in this message are those of the individual sender and no
binding nature of the message shall be implied or assumed unless the sender
does so expressly with due authority of Newgen Software Technologies Ltd and
/ or its subsidiary Companies, as applicable.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-18 14:21 Samuel B. Quiring <sbq@cayuse.com>
parent: Yogvinder Singh <yogvinder@newgen.co.in>
1 sibling, 0 replies; 15+ messages in thread
From: Samuel B. Quiring @ 2007-01-18 14:21 UTC (permalink / raw)
To: Yogvinder Singh <yogvinder@newgen.co.in>; pgsql-admin
You can use pg_dump while the application(s) that use the database are
active. pg_dump saves that database at a point in time. If the
application(s)
continue to modify the database after you use pg_dump, the script/archive
file created by pg_dump will not contain those modifications.
----- Original Message -----
From: "Yogvinder Singh" <yogvinder@newgen.co.in>
To: <pgsql-admin@postgresql.org>
Sent: Wednesday, January 17, 2007 9:59 PM
Subject: Re: [ADMIN] Incremental Backup of a particular database
> pg_dump is a utility for saving a PostgreSQL database into a script or an
> archive file. The script files are in plain-text format and contain the
> SQL
> commands required to reconstruct the database to the state it was
> in
> at the time it was saved.
>
> "At the time it was saved" What is the meaning of this statement?
>
>
> Regards,
> Yogvinder Singh,
> Software Engineer, E-WorkStyle Group,
> Newgen Software Technologies Ltd.
> D-152, Okhla Phase - 1
> New Delhi
> Tel no 26815467 Ext 143
>
>
> ----- Original Message -----
> From: "Yogvinder Singh" <yogvinder@newgen.co.in>
> To: "Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>
> Cc: <pgsql-admin@postgresql.org>
> Sent: Thursday, January 18, 2007 10:44 AM
> Subject: Re: [ADMIN] Incremental Backup of a particular database
>
>
>> I only want one of many databases to be restored to the other server
>> incrementally.
>> Is this possible?
>> If yes, Wht are the steps??
>>
>> Regards,
>> Yogvinder Singh,
>> Software Engineer, E-WorkStyle Group,
>> Newgen Software Technologies Ltd.
>> D-152, Okhla Phase - 1
>> Tel no 26815467 Ext 143
>>
>>
>> ----- Original Message -----
>> From: "Andy Shellam (Mailing Lists)"
> <andy.shellam-lists@mailnetwork.co.uk>
>> To: "Yogvinder Singh" <yogvinder@newgen.co.in>
>> Cc: <pgsql-admin@postgresql.org>
>> Sent: Wednesday, January 17, 2007 8:17 PM
>> Subject: Re: [ADMIN] Incremental Backup of a particular database
>>
>>
>> > I believe the option for a "warm standby" (which sounds like it is what
>> > you need) was made available in 8.2.0.
>> > You'd have to look at the manual though, I haven't had time to
>> > investigate, and I'm not sure whether it's cluster-wide, or
>> > database-specific.
>> >
>> >
>> > Yogvinder Singh wrote:
>> > > Hi Ppl,
>> > >
>> > > I have Two PostgreSQL Database Servers. The situation is like this:-
>> > > 1) On first database server ball the operations (i.e live server)
>> > > will
>> > > be done. This server may contain n number of databases.
>> > >
>> > > 2) On the second database server, i want to keep one particular
>> > > database (from the first database server ) and keep it updated to
>> > > the
>> > > latest from the First Database Server. I just want to be able to take
>> > > some sort of incremental backup from the first server and restore it
>> > > to the second server.
>> > >
>> > > Is this situation feasible. How can i take an incremental backup of a
>> > > particular database out of many databases? On which version this is
>> > > supported? IF not supported, is there any alternative way to handle
>> > > this situatio.
>> > >
>> > > Regards,
>> > > Yogvinder Singh,
>> > > !DSPAM:37,45ae2b2f137105304223843! Disclaimer :- This e-mail message
>> > > including any attachment may contain confidential, proprietary or
>> > > legally privileged information. It should not be used by who is not
>> > > the original intended recipient. If you have erroneously received
>> > > this
>> > > message, you are notified that you are strictly prohibited from
>> > > using,
>> > > copying, altering or disclosing the content of this message. Please
>> > > delete it immediately and notify the sender. Newgen Software
>> > > Technologies Ltd and / or its subsidiary Companies accept no
>> > > responsibility for loss or damage arising from the use of the
>> > > information transmitted by this email including damage from virus and
>> > > further acknowledges that any views expressed in this message are
>> > > those of the individual sender and no binding nature of the message
>> > > shall be implied or assumed unless the sender does so expressly with
>> > > due authority of Newgen Software Technologies Ltd and / or its
>> > > subsidiary Companies, as applicable.
>> >
>> > ---------------------------(end of
>> > broadcast)---------------------------
>> > TIP 3: Have you checked our extensive FAQ?
>> >
>> > http://www.postgresql.org/docs/faq
>> >
>>
>>
>>
>> Disclaimer :- This e-mail message including any attachment may contain
> confidential, proprietary or legally privileged information. It should not
> be used by who is not the original intended recipient. If you have
> erroneously received this message, you are notified that you are strictly
> prohibited from using, copying, altering or disclosing the content of this
> message. Please delete it immediately and notify the sender. Newgen
> Software
> Technologies Ltd and / or its subsidiary Companies accept no
> responsibility
> for loss or damage arising from the use of the information transmitted by
> this email including damage from virus and further acknowledges that any
> views expressed in this message are those of the individual sender and no
> binding nature of the message shall be implied or assumed unless the
> sender
> does so expressly with due authority of Newgen Software Technologies Ltd
> and
> / or its subsidiary Companies, as applicable.
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>>
>
>
>
> Disclaimer :- This e-mail message including any attachment may contain
> confidential, proprietary or legally privileged information. It should not
> be used by who is not the original intended recipient. If you have
> erroneously received this message, you are notified that you are strictly
> prohibited from using, copying, altering or disclosing the content of this
> message. Please delete it immediately and notify the sender. Newgen
> Software Technologies Ltd and / or its subsidiary Companies accept no
> responsibility for loss or damage arising from the use of the information
> transmitted by this email including damage from virus and further
> acknowledges that any views expressed in this message are those of the
> individual sender and no binding nature of the message shall be implied or
> assumed unless the sender does so expressly with due authority of Newgen
> Software Technologies Ltd and / or its subsidiary Companies, as
> applicable.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-18 16:02 Jason Minion <jason.minion@sigler.com>
parent: Yogvinder Singh <yogvinder@newgen.co.in>
1 sibling, 1 reply; 15+ messages in thread
From: Jason Minion @ 2007-01-18 16:02 UTC (permalink / raw)
To: Yogvinder Singh <yogvinder@newgen.co.in>; Shoaib Mir <shoaibmir@gmail.com>; +Cc: pgsql-admin
There is no incremental backup process that focuses on an individual
database for PostgreSQL. Anything that has to do with PITR on a
PostgreSQL installation is system-wide, and cannot be configured to
support a single database out of many in an installation. If you need to
support PITR with a single database, you will need to initdb another
directory and set up another PostgreSQL postmaster to manage that
installation separate from your primary installation (and on a different
port, etc), or set up PostgreSQL for that specific database on another
server.
Also, there really are no incremental backup tools for PostgreSQL,
assuming you are looking at an incremental backup in the way that the
Progress database system takes an incremental backup (copy of all of the
blocks changed since the last full or incremental backup). PostgreSQL
has PITR, which is a roll-forward system using log data from a full
point-in-time backup, as well as pg_dump. One could say that the log
files are the incremental backups. However, many commercial database
systems (that many are migrating to PostgreSQL from) provide both an
"incremental" backup option (very fast recovery) as well as a "log based
recovery" option (slow recovery), and of the two, PostgreSQL supports
only the log based recovery through PITR.
Please correct me where possible guys, I enjoy the stability and
useability of my PostgreSQL very much, but I have to admit that I lose a
bit more sleep over it than some other db's with regards to recovery
time in a DR scenario. I am very eager to see where we go in the future.
Jason Minion
jason.minion@sigler.com
________________________________
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Yogvinder Singh
Sent: Thursday, January 18, 2007 5:23 AM
To: Shoaib Mir
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Incremental Backup of a particular database
So it means there is no way i can take incremental backup of one of the
databases from a postgresql database server??
Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
New Delhi
Tel no 26815467 Ext 143
----- Original Message -----
From: Shoaib Mir <mailto:shoaibmir@gmail.com>
To: Yogvinder Singh <mailto:yogvinder@newgen.co.in>
Cc: pgsql-admin@postgresql.org
Sent: Thursday, January 18, 2007 4:07 PM
Subject: Re: [ADMIN] Incremental Backup of a particular database
When the pg_dump process starts it takes one point and then
makes a backup for that specific time even if more updates on the
database are happening during the pg_dump process. So when you restore
on the other machine it will restore to that specific time when the
pg_dump process started.
----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/18/07, Yogvinder Singh < yogvinder@newgen.co.in> wrote:
pg_dump is a utility for saving a PostgreSQL database
into a script or an
archive file. The script files are in plain-text format
and contain the SQL
commands required to reconstruct the database to the
state it was in
at the time it was saved.
"At the time it was saved" What is the meaning of this
statement?
Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
New Delhi
Tel no 26815467 Ext 143
----- Original Message -----
From: "Yogvinder Singh" <yogvinder@newgen.co.in>
To: "Andy Shellam (Mailing Lists)"
<andy.shellam-lists@mailnetwork.co.uk >
Cc: <pgsql-admin@postgresql.org>
Sent: Thursday, January 18, 2007 10:44 AM
Subject: Re: [ADMIN] Incremental Backup of a particular
database
> I only want one of many databases to be restored to
the other server
> incrementally.
> Is this possible?
> If yes, Wht are the steps??
>
> Regards,
> Yogvinder Singh,
> Software Engineer, E-WorkStyle Group,
> Newgen Software Technologies Ltd.
> D-152, Okhla Phase - 1
> Tel no 26815467 Ext 143
>
>
> ----- Original Message -----
> From: "Andy Shellam (Mailing Lists)"
< andy.shellam-lists@mailnetwork.co.uk>
> To: "Yogvinder Singh" <yogvinder@newgen.co.in>
> Cc: < pgsql-admin@postgresql.org>
> Sent: Wednesday, January 17, 2007 8:17 PM
> Subject: Re: [ADMIN] Incremental Backup of a
particular database
>
>
> > I believe the option for a "warm standby" (which
sounds like it is what
> > you need) was made available in 8.2.0.
> > You'd have to look at the manual though, I haven't
had time to
> > investigate, and I'm not sure whether it's
cluster-wide, or
> > database-specific.
> >
> >
> > Yogvinder Singh wrote:
> > > Hi Ppl,
> > >
> > > I have Two PostgreSQL Database Servers. The
situation is like this:-
> > > 1) On first database server ball the operations
(i.e live server) will
> > > be done. This server may contain n number of
databases.
> > >
> > > 2) On the second database server, i want to keep
one particular
> > > database (from the first database server ) and
keep it updated to the
> > > latest from the First Database Server. I just want
to be able to take
> > > some sort of incremental backup from the first
server and restore it
> > > to the second server.
> > >
> > > Is this situation feasible. How can i take an
incremental backup of a
> > > particular database out of many databases? On
which version this is
> > > supported? IF not supported, is there any
alternative way to handle
> > > this situatio.
> > >
> > > Regards,
> > > Yogvinder Singh,
> > > !DSPAM:37,45ae2b2f137105304223843! Disclaimer :-
This e-mail message
> > > including any attachment may contain confidential,
proprietary or
> > > legally privileged information. It should not be
used by who is not
> > > the original intended recipient. If you have
erroneously received this
> > > message, you are notified that you are strictly
prohibited from using,
> > > copying, altering or disclosing the content of
this message. Please
> > > delete it immediately and notify the sender.
Newgen Software
> > > Technologies Ltd and / or its subsidiary Companies
accept no
> > > responsibility for loss or damage arising from the
use of the
> > > information transmitted by this email including
damage from virus and
> > > further acknowledges that any views expressed in
this message are
> > > those of the individual sender and no binding
nature of the message
> > > shall be implied or assumed unless the sender does
so expressly with
> > > due authority of Newgen Software Technologies Ltd
and / or its
> > > subsidiary Companies, as applicable.
> >
> > ---------------------------(end of
broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
> >
>
>
>
> Disclaimer :- This e-mail message including any
attachment may contain
confidential, proprietary or legally privileged
information. It should not
be used by who is not the original intended recipient.
If you have
erroneously received this message, you are notified that
you are strictly
prohibited from using, copying, altering or disclosing
the content of this
message. Please delete it immediately and notify the
sender. Newgen Software
Technologies Ltd and / or its subsidiary Companies
accept no responsibility
for loss or damage arising from the use of the
information transmitted by
this email including damage from virus and further
acknowledges that any
views expressed in this message are those of the
individual sender and no
binding nature of the message shall be implied or
assumed unless the sender
does so expressly with due authority of Newgen Software
Technologies Ltd and
/ or its subsidiary Companies, as applicable.
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
Disclaimer :- This e-mail message including any
attachment may contain confidential, proprietary or legally privileged
information. It should not be used by who is not the original intended
recipient. If you have erroneously received this message, you are
notified that you are strictly prohibited from using, copying, altering
or disclosing the content of this message. Please delete it immediately
and notify the sender. Newgen Software Technologies Ltd and / or its
subsidiary Companies accept no responsibility for loss or damage arising
from the use of the information transmitted by this email including
damage from virus and further acknowledges that any views expressed in
this message are those of the individual sender and no binding nature of
the message shall be implied or assumed unless the sender does so
expressly with due authority of Newgen Software Technologies Ltd and /
or its subsidiary Companies, as applicable.
---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend
Disclaimer :- This e-mail message including any attachment may contain
confidential, proprietary or legally privileged information. It should
not be used by who is not the original intended recipient. If you have
erroneously received this message, you are notified that you are
strictly prohibited from using, copying, altering or disclosing the
content of this message. Please delete it immediately and notify the
sender. Newgen Software Technologies Ltd and / or its subsidiary
Companies accept no responsibility for loss or damage arising from the
use of the information transmitted by this email including damage from
virus and further acknowledges that any views expressed in this message
are those of the individual sender and no binding nature of the message
shall be implied or assumed unless the sender does so expressly with due
authority of Newgen Software Technologies Ltd and / or its subsidiary
Companies, as applicable.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-18 16:22 Scott Marlowe <smarlowe@g2switchworks.com>
parent: Yogvinder Singh <yogvinder@newgen.co.in>
1 sibling, 0 replies; 15+ messages in thread
From: Scott Marlowe @ 2007-01-18 16:22 UTC (permalink / raw)
To: Yogvinder Singh <yogvinder@newgen.co.in>; +Cc: Shoaib Mir <shoaibmir@gmail.com>; pgsql-admin
On Thu, 2007-01-18 at 05:23, Yogvinder Singh wrote:
> So it means there is no way i can take incremental backup of one of
> the databases from a postgresql database server??
Correct. You could replicate its tables to another server with slony
and then use that to make incrementals with PITR.
Maybe a better definition of what you're trying to do from a higher
level would help.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Incremental Backup of a particular database
@ 2007-01-18 21:23 Naomi Walker <nwalke@eldocomp.com>
parent: Jason Minion <jason.minion@sigler.com>
0 siblings, 0 replies; 15+ messages in thread
From: Naomi Walker @ 2007-01-18 21:23 UTC (permalink / raw)
To: Jason Minion <jason.minion@sigler.com>; +Cc: Yogvinder Singh <yogvinder@newgen.co.in>; Shoaib Mir <shoaibmir@gmail.com>; pgsql-admin
I've been thinking about PITR. Since we have one production instance
and one test instance of Postgres, in order to perform a PITR
on any particular database would require reloading the entire instance
onto another server, and extracting what I needed. Clunky, but
do-able.
^ permalink raw reply [nested|flat] 15+ messages in thread
end of thread, other threads:[~2007-01-18 21:23 UTC | newest]
Thread overview: 15+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-17 13:48 Incremental Backup of a particular database Yogvinder Singh <yogvinder@newgen.co.in>
2007-01-17 14:47 ` Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-01-17 15:04 ` Shoaib Mir <shoaibmir@gmail.com>
2007-01-17 15:15 ` Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-01-17 15:23 ` Shoaib Mir <shoaibmir@gmail.com>
2007-01-18 04:09 ` Eduardo J. Ortega <ejortegau@cable.net.co>
2007-01-18 05:30 ` Yogvinder Singh <yogvinder@newgen.co.in>
2007-01-18 05:14 ` Yogvinder Singh <yogvinder@newgen.co.in>
2007-01-18 05:59 ` Yogvinder Singh <yogvinder@newgen.co.in>
2007-01-18 10:37 ` Shoaib Mir <shoaibmir@gmail.com>
2007-01-18 11:23 ` Yogvinder Singh <yogvinder@newgen.co.in>
2007-01-18 16:02 ` Jason Minion <jason.minion@sigler.com>
2007-01-18 21:23 ` Naomi Walker <nwalke@eldocomp.com>
2007-01-18 16:22 ` Scott Marlowe <smarlowe@g2switchworks.com>
2007-01-18 14:21 ` Samuel B. Quiring <sbq@cayuse.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox