Re: [GENERAL] Backup WAL Replication Server

2014-03-20 Thread Sergey Konoplev
On Thu, Mar 20, 2014 at 5:48 AM, basti wrote: > at the moment we use a Postgres Server as Master and one as Hot-Standby. > The Database is around 50GB and will massive grow next time. > > Backup and Restore with pg_dump take several hours, is there a faster > way to do this? Where does pg_backup

Re: [GENERAL] Backup WAL Replication Server

2014-03-20 Thread Michael Paquier
On Thu, Mar 20, 2014 at 9:48 PM, basti wrote: > at the moment we use a Postgres Server as Master and one as Hot-Standby. > The Database is around 50GB and will massive grow next time. > > Backup and Restore with pg_dump take several hours, is there a faster > way to do this? Everything is here: ht

[GENERAL] Backup WAL Replication Server

2014-03-20 Thread basti
Hello, at the moment we use a Postgres Server as Master and one as Hot-Standby. The Database is around 50GB and will massive grow next time. Backup and Restore with pg_dump take several hours, is there a faster way to do this? Regards, Basti -- Sent via pgsql-general mailing list (pgsql-genera