Re: Where is the physical files of database that I just - Mailing list pgsql-general

From Joe Conway
Subject Re: Where is the physical files of database that I just
Date
Msg-id 3F15E215.9050900@joeconway.com
Whole thread Raw
In response to Re: Where is the physical files of database that I just drop?  ("Terence Chang" <TChang@nqueue.com>)
List 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


pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: dump_all/restore times?
Next
From: Jim Crate
Date:
Subject: Re: IPv4 addresses, unsigned integers, space