I'm wanted to find out why is it recommended or even an option to lock tables during a backup of a database? I've never experimented with database backups so I'm only guessing it locks / freezes the data so no changes can be made while the backup is in process, correct? Just curious and wasn't able to find an answer online. My next question is more complex but more of a recommendations. I'm looking to see how do you guys backup your databases? Do you simply cron 'pg_dump' command line or do you have a script that gets called in cron using 'pg_dump' / 'pg_dumpall'? Just looking for ideas / recommendations for a simple / quick way to back up 5 small databases on my server. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
