Hai ilya,
Thanks for the respond. The database is estimated over 100gb and the workload
will be high. Can we use a pg_basebackup with pitr to restore based on
transaction time?
Thanks
On Tuesday, 25 March 2014, 15:13, Ilya Kosmodemiansky
ilya.kosmodemian...@postgresql-consulting.com wrote:
Hi gianfranco,
How exactly large is your database and how heavy is a workload on it?
Usually if you have more than ~200Gb, better to use pg_basebackup
because pg_dump will take too long time. And please take in mind, that
pg_dump makes dump, which isĀ actually not the same thing as a backup.
Best regards,
Ilya
On Tue, Mar 25, 2014 at 5:45 AM, gianfranco caca limpc...@yahoo.com wrote:
Hai,
Can anyone tell me the difference and performance between pgdump and
pg_basebackup if I want to backup a large database.
Thanks
--
Ilya Kosmodemiansky,
PostgreSQL-Consulting.com
tel. +14084142500
cell. +4915144336040
i...@postgresql-consulting.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance