pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Carlos Moreno <moreno@mochima.com>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Having trouble with backups (was: Re: Crash Recovery)
Date: Fri, 24 Jan 2003 10:16:42 -0500
Message-ID: <3E3158DA.7080807@mochima.com> (raw)
References: <2147483647.1043361178@[10.0.1.133]>
	<1043416377.29437.70.camel@haggis>


Speaking about daily backups...  We are running into some serious
trouble with our backup policy.

First (and less important), the size of our backups is increasing
a lot;  yet information is not changing, only being added;  so, the
obvious question:  is there a way to make incremental backup?

And the second (and intriguing) problem:  whenever I run pg_dump,
my system *freezes* until pg_dump finishes.  When I say "system",
I mean the software that is running and sending data to the PG
database.  It just freezes, users are unable to connect during
several minutes, and the ones already connected think the server
died, so they end up disconnecting after one or two minutes
seeing that the server does not respond.

Is this normal?  Is there any way to avoid it?  (I guess if I
have a solution to the first problem -- i.e., doing incremental
backups -- then that would solve this one, since it would only
"freeze" the system for a few seconds, which wouldn't be that
bad...)

Thanks for any comments!

Carlos
--





view thread (13+ messages)  latest in thread

Message-ID: <3E3158DA.7080807@mochima.com>
Permalink:  ../3E3158DA.7080807@mochima.com/
Also on:    postgresql.org/message-id/3E3158DA.7080807@mochima.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: moreno@mochima.com
  Subject: Re: Having trouble with backups (was: Re: Crash Recovery)
  In-Reply-To: <3E3158DA.7080807@mochima.com>
  References: <2147483647.1043361178@[10.0.1.133]> <1043416377.29437.70.camel@haggis> <3E3158DA.7080807@mochima.com>

* 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