| From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
|---|---|
| To: | basti <mailinglist(at)unix-solution(dot)de> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Backup WAL Replication Server |
| Date: | 2014-03-20 15:35:56 |
| Message-ID: | CAL_0b1sLh0eerXjf=f-8k0TOBFXTty-rTEqGhvofvrRxC5UBJg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Mar 20, 2014 at 5:48 AM, basti <mailinglist(at)unix-solution(dot)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(dot)ru(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenneth Buckler | 2014-03-20 15:54:13 | Re: High Level Committers Wanted |
| Previous Message | basti | 2014-03-20 14:37:05 | WAL Replication Server + repmgr + Slony |