Received: from arcamax.com (arcamax.com [206.246.240.138]) by hub.org (8.9.2/8.9.1) with ESMTP id QAA07095 for ; Thu, 28 Jan 1999 16:48:47 -0500 (EST) (envelope-from bryan@arcamax.com) Received: from bryan.arcamax.com (bryan [206.246.240.163]) by arcamax.com (8.8.7/8.8.7) with SMTP id QAA14090; Thu, 28 Jan 1999 16:48:21 -0500 Message-ID: <000f01be4b07$ee6b0d40$a3f0f6ce@bryan.arcamax.com> From: "Bryan White" To: , "Brian" , Subject: Re: [SQL] Auto-Vacuum? Date: Thu, 28 Jan 1999 16:48:20 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 >What does the "dump" do? I have been just tarring the >/usr/local/pgsql/data/base/ directory and burning that onto a CD... pg_dump writes to stdout the sql code needed to recreate the database. As I remember there are a couple of catches (it does not recreate views?...). To restore the database, start with a blank database and do: psql dbname < mydatabase.db