Re: "Hot Backups"

Yes -- but what happens if the database crashes and you have to restore up
to
a point in time -- Can you restore using your last pg_dump file & then is
there ** some** way to bring forth your **log** information so that there is
no data lost. Example: 7pm you do a pg_dump 7am the next morning, the
database
crashes. You restore using the 7pm dump -- how do you recover the data from
7pm to 7am?

Thanks
Pam Wampler

-----Original Message-----
From: Josh Berkus [mailto:josh(at)agliodbs(dot)com]
Sent: Monday, February 11, 2002 2:38 PM
To: Pam Wampler; pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] "Hot Backups"

Pam,

> I am new to postgresql -- coming from Oracle --
> Is there an equivalent "Hot" Backup in postgresql --
> or is the only backup utility available pg_dump & pg_dumpall.
> thanks

pg_dump and pg_dumpall may be run while the database is in use without
difficulty. Is this what you mean by "hot" backup?

-Josh