Re: Where is the physical files of database that I just
От | Terence Chang |
---|---|
Тема | Re: Where is the physical files of database that I just |
Дата | |
Msg-id | 003e01c34c75$c12ca900$0100a8c0@WINDOWS2000 обсуждение исходный текст |
Ответ на | Re: Where is the physical files of database that I just ("scott.marlowe" <scott.marlowe@ihs.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: