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.