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