| [Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] |
On 02/15/2012 12:58 PM, Vladimir Rusinov wrote:
pg_dump won't block writes, thanks to MVCC. It may increase bloat and it will block DDL operations (ALTER TABLE/etc), but if your database is relatively small but have high load and you need frequent backups, this may be a way to go. -- Vladimir Rusinov http://greenmice.info/
Thanks Vladimir. Would a simple script with 'pg_start_backup' and 'pg_stop_backup' and an rsync job or tar job in between would work equally well? I thought that was the better way to do it, rather than pg_dump?
-- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite]