Skip site navigation (1) Skip section navigation (2)

Re: Incremental Backup of a particular database

From: "Yogvinder Singh" <yogvinder(at)newgen(dot)co(dot)in>
To: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Incremental Backup of a particular database
Date: 2007-01-18 11:23:19
Message-ID: 001101c73af3$0f0d43e0$0404a8c0@central.newgen.local (view raw or flat)
Thread:
Lists: 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(at)postgresql(dot)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(at)newgen(dot)co(dot)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(at)newgen(dot)co(dot)in>
    To: "Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk >
    Cc: <pgsql-admin(at)postgresql(dot)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(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
    > To: "Yogvinder Singh" <yogvinder(at)newgen(dot)co(dot)in>
    > Cc: < pgsql-admin(at)postgresql(dot)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


In response to

Responses

pgsql-admin by date

Next:From: Ray StellDate: 2007-01-18 14:17:31
Subject: Re: Upgrade/Installation problem: Version 7.4.9 to version
Previous:From: Shoaib MirDate: 2007-01-18 10:37:56
Subject: Re: Incremental Backup of a particular database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group