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
