IC.. However, my application is critical. So is it possible to backup those
20 user's transactions from log? Oracle and MS SQL can recover to the
failure point. Does PostgreSQL support that also? I mean recover from a
transaction log and where is the transaction log?
Thanks!
----- Original Message -----
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: "Terence Chang" <TChang@nqueue.com>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, July 17, 2003 7:35 AM
Subject: Re: [GENERAL] Where is the physical files of database that I just
> On Wed, 16 Jul 2003, Terence Chang wrote:
>
> > Great! That is easier than Oracle! Now! I have no excuse not to use
> > PostgreSQL. :-)
> >
> > I got one more question! Is there a way that I can shut down only one
> > database for "Cold Backup" while other database are running like Oracle
> > does?
>
> There's really no need to shut down and do a cold backup. pg_backup backs
> up databases hot as if they were cold (i.e. it uses a snapshot system).
> So, if you connect and start pg_dump, and 20 users initiate transactions
> after that, you see none of those later transactions or any part of them
> in your backup.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings