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@agliodbs.com]
Sent: Monday, February 11, 2002 2:38 PM
To: Pam Wampler; pgsql-novice@postgresql.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