From: Rajesh Kumar Mallah <mallah@trade-india.com>
Organization: Infocom Network Limited
To: Bruce Momjian <pgman@candle.pha.pa.us>
Subject: Re: point-in-time recovery
Date: Fri, 25 Apr 2003 20:15:15 +0530
User-Agent: KMail/1.5
Cc: pgsql-admin@postgresql.org
References: <200304251417.h3PEHBo06807@candle.pha.pa.us>
In-Reply-To: <200304251417.h3PEHBo06807@candle.pha.pa.us>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200304252015.15089.mallah@trade-india.com>


Thanks for responding , but i still have
more to discuss.

On Friday 25 Apr 2003 7:47 pm, Bruce Momjian wrote:
> Rajesh Kumar Mallah wrote:
> > What is this PITR anyway ?
> >
> > when it comes will i be able to
> >
> > 1. reduce by pg_dump times ?
> > 2. can afford to run pg_dump less frequently ?
> > 3. Will be able to rollback committed transactions of past 5 mins?
>
> You can do a dump,

Do u mean pg_dump here, or some special command
thats doing a quick snapshot dump?

 then do continuous logging of all database changes
is this logging happening automatically for i have to give some
special command to start logging?

> until the next backup.  If you crash in the middle of the day, you can
> recover up to the point of the crash.

say i do not crash but do a 

psql> DELETE from  TABLE_NAME ;
DELETE 1021
psql> Ooops what did i do , damn my last backup is 6 hrs old  ??

does PITR help me here?


And Sorry if its too early to ask 


Regds
Mallah.


-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.