Re: Where is the physical files of database that I just

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(dot)marlowe(at)ihs(dot)com>
To: "Terence Chang" <TChang(at)nqueue(dot)com>
Cc: <pgsql-general(at)postgresql(dot)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