Received: from primus.vsservices.com (primus.vsservices.com [63.66.136.75]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBIEe8m86897 for ; Tue, 18 Dec 2001 09:40:08 -0500 (EST) (envelope-from gclarkii@vsservices.com) Received: from prime.vsservices.com (conr-adsl-dhcp-26-38.txucom.net [209.34.26.38]) by primus.vsservices.com (8.11.3/8.11.3) with SMTP id fBIEdtC30886; Tue, 18 Dec 2001 06:39:56 -0800 (PST) (envelope-from gclarkii@vsservices.com) Content-Type: text/plain; charset="iso-8859-1" From: GB Clark II To: Johnny =?iso-8859-1?q?J=F8rgensen?= , pgsql-sql@postgresql.org Subject: Re: Constructing a backup routine Date: Tue, 18 Dec 2001 08:39:57 -0600 X-Mailer: KMail [version 1.2] References: <20011218125019.BFA2.PGSQL@halfahead.dk> In-Reply-To: <20011218125019.BFA2.PGSQL@halfahead.dk> MIME-Version: 1.0 Message-Id: <01121808395705.65128@prime.vsservices.com> Content-Transfer-Encoding: 8bit X-Archive-Number: 200112/199 X-Sequence-Number: 6022 On Tuesday 18 December 2001 05:50, Johnny Jørgensen wrote: > 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, Hi, I ran into the same problem and the only way I could get pg_dump to work was to dump the entire database instead of just the tables. GB -- GB Clark II | Roaming FreeBSD Admin gclarkii@VSServices.COM | General Geek CTHULU for President - Why choose the lesser of two evils?