Received: from gamma.dou.dk (gamma.dou.dk [130.225.156.12]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBIBhGm73154 for ; Tue, 18 Dec 2001 06:43:17 -0500 (EST) (envelope-from pgsql@halfahead.dk) Received: from aggie ([130.226.84.71]) by gamma.dou.dk (8.9.3/8.9.3) with ESMTP id MAA11970 for ; Tue, 18 Dec 2001 12:43:09 +0100 (MET) Date: Tue, 18 Dec 2001 12:50:21 +0100 From: Johnny =?ISO-8859-1?Q?J=F8rgensen?= To: pgsql-sql@postgresql.org Subject: Constructing a backup routine Message-Id: <20011218125019.BFA2.PGSQL@halfahead.dk> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" X-Mailer: Becky! ver. 2.00.07 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id fBIC27L74392 X-Archive-Number: 200112/195 X-Sequence-Number: 6018 I've been over the docs, Bruce's book, and a good part of the web, where there are plenty documentation on COPY, \copy and pgdump, but I have yet to make a working backup (and the system goes into production state in 3 weeks..). The problem is, i get my data moved out & in fine, but sequences are reset? This is, of course, something of a problem, since it breaks new inserts into unique colums from sequences after a restore. Also, I've been putting a lot of work into some plpgsql functions, that I have to load manually - there's only a handful, so it isn't too big a problem, but all in all, to get a near-workable backup, takes me an hour or so by hand.. What way do you big folks handle backing up your systems? regards, -- Johnny Jørgensen