Backup WAL Replication Server
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-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Mar 20, 2014 at 9:48 PM, basti <mailinglist@unix-solution.de> 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:
http://www.postgresql.org/docs/devel/static/backup.html
Roughly, taking periodic base backups and maintaining WAL archives is
the way to go.
Regards
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Mar 20, 2014 at 5:48 AM, basti <mailinglist@unix-solution.de> 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 create an output file? (the same server/file
system, network partition, the same and then scp to another server,
something else)
What is the file system utilization for the partition where you keep
your data with and without pg_backup? (iostat -xk 10)
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray.ru@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general