From: Marcin Giedz <marcin.giedz@eulerhermes.pl>
To: pgsql-admin@postgresql.org
Subject: Backup issue
Date: Sat, 17 Sep 2005 09:49:52 +0200
Message-ID: <432BCAA0.6020902@eulerhermes.pl> (raw)
Hello...
This is what I have now: postgresql 8.0.1 - database weights about 60GB
and increases about 2GB per week. Nowadays I do backup every day -
according to simple procedure (pg_start_backup:rsync
data:pg_stop_backup:save wals produced during backup). On 1Gb internal
network it usually takes me about 1h to perform this procedure.
But what if my database has ~200GB and more (I know this is a future
:D)? From my point of view it won't be good idea to copy entire database
to backup array. I would like to here opinions about this case - what do
you propose? Maybe some of you already do something like this?
Regards,
Marcin Giedz
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: marcin.giedz@eulerhermes.pl
Subject: Re: Backup issue
In-Reply-To: <432BCAA0.6020902@eulerhermes.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox