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

From: Joe Conway <mail(at)joeconway(dot)com>
To: Terence Chang <TChang(at)nqueue(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Where is the physical files of database that I just
Date: 2003-07-16 23:39:01
Message-ID: 3F15E215.9050900@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Terence Chang wrote:
> 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?

No, but then again, there is no need. pg_dump will give you a consistent
snapshot of the database as it was when you started the command. It is
essentially a "cold" backup that is taken while hot!

Joe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message nolan 2003-07-16 23:39:12 Re: dump_all/restore times?
Previous Message Terence Chang 2003-07-16 23:27:48 Re: Where is the physical files of database that I just drop?