On 7/3/15 8:08 AM, howardn...@selestial.com wrote:
Thanks everyone.
I am trying to move away from pg_dump as it is proving too slow. The
size of the database clusters are approaching 1TB (with multiple
individual compressed pg_dumps of around 100GB each, but the pace of
change is relatively
On 07/03/2015 08:08 AM, howardn...@selestial.com wrote:
I am trying to move away from pg_dump as it is proving too slow.
Have you looked into barman?
http://www.pgbarman.org
Also, another potential approach is to setup replication and to do the
backups from the slave.
--
Sent via
Le 3 juil. 2015 12:03 PM, howardn...@selestial.com
howardn...@selestial.com a écrit :
Hi everyone,
I am reaching the point with my database backups where the backups are
taking too long, and starting to interfere with running of the system
during the day. So I am looking for a bit of sage
Hi everyone,
I am reaching the point with my database backups where the backups are
taking too long, and starting to interfere with running of the system
during the day. So I am looking for a bit of sage advice as to how to
proceed.
For a typical server, I have a single database cluster
On 03/07/2015 11:15, Guillaume Lelarge wrote:
pg_dumpall is not more efficient than pg_dump. As far as I can tell,
you're looking for PITR backups.
Thanks Guillame.
In that case is there any recommendation for how often to make base
backups in relation to the size of the cluster and
Le 3 juil. 2015 12:31 PM, howardn...@selestial.com
howardn...@selestial.com a écrit :
On 03/07/2015 11:15, Guillaume Lelarge wrote:
pg_dumpall is not more efficient than pg_dump. As far as I can tell,
you're looking for PITR backups.
Thanks Guillame.
In that case is there any
On 03/07/2015 11:39, Guillaume Lelarge wrote:
In that case is there any recommendation for how often to make base
backups in relation to the size of the cluster and the size of the WAL?
Nope, not really. That depends on a lot of things. Our customers
usually do one per day.
--
Am 2015-07-03 13:00, schrieb howardn...@selestial.com:
On 03/07/2015 11:39, Guillaume Lelarge wrote:
In that case is there any recommendation for how often to make
base backups in relation to the size of the cluster and the size of
the WAL?
Nope, not really. That depends on a lot of
On Fri, 03 Jul 2015 13:16:02 +0200
Jan Lentfer jan.lent...@web.de wrote:
Am 2015-07-03 13:00, schrieb howardn...@selestial.com:
On 03/07/2015 11:39, Guillaume Lelarge wrote:
In that case is there any recommendation for how often to make
base backups in relation to the size of the
On 03/07/2015 12:23, Bill Moran wrote:
On Fri, 03 Jul 2015 13:16:02 +0200
Jan Lentfer jan.lent...@web.de wrote:
Am 2015-07-03 13:00, schrieb howardn...@selestial.com:
On 03/07/2015 11:39, Guillaume Lelarge wrote:
In that case is there any recommendation for how often to make
base backups
På fredag 03. juli 2015 kl. 11:59:49, skrev howardn...@selestial.com
howardn...@selestial.com mailto:howardn...@selestial.com:
Hi everyone,
I am reaching the point with my database backups where the backups are
taking too long, and starting to interfere with running of the system
during the
On Wed, 2006-05-04 at 22:29 +0100, Simon Riggs wrote:
On Wed, 2006-04-05 at 15:42 -0400, Bob Powell wrote:
I have a systems admin that is backing up our Linux computers
(postgres) by backing up the directory structure. This of course
includes all the files that pertain to my postgres
Guy Fraser [EMAIL PROTECTED] writes:
How do you suggest one does PITR ?
It has been a while since I read the Docs, but do not recall
any tools that allow one to do such a thing.
PITR went in to 8.0 (IIRC); the docs for that version will cover it.
-Doug
---(end of
On Thu, 2006-06-04 at 15:21 -0400, Douglas McNaught wrote:
Guy Fraser [EMAIL PROTECTED] writes:
How do you suggest one does PITR ?
It has been a while since I read the Docs, but do not recall
any tools that allow one to do such a thing.
PITR went in to 8.0 (IIRC); the docs for that
Bob Powell [EMAIL PROTECTED] writes:
Hello everyone:
I have a systems admin that is backing up our Linux computers
(postgres) by backing up the directory structure. This of course
includes all the files that pertain to my postgres databases. I
maintain that using pgdump and creating a
Bob Powell wrote:
I have a systems admin that is backing up our Linux computers
(postgres) by backing up the directory structure. This of course
includes all the files that pertain to my postgres databases. I
maintain that using pgdump and creating a file of SQL commands for
restore is a
On Wed, 2006-04-05 at 15:42 -0400, Bob Powell wrote:
I have a systems admin that is backing up our Linux computers
(postgres) by backing up the directory structure. This of course
includes all the files that pertain to my postgres databases. I
maintain that using pgdump and creating a file
Hello everyone:
I have a systems admin that is backing up our Linux computers
(postgres) by backing up the directory structure. This of course
includes all the files that pertain to my postgres databases. I
maintain that using pgdump and creating a file of SQL commands for
restore is a better
18 matches
Mail list logo