X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E232BD1B298 for ; Sat, 24 Jul 2004 00:26:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54512-04 for ; Sat, 24 Jul 2004 03:26:26 +0000 (GMT) Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [204.127.198.35]) by svr1.postgresql.org (Postfix) with ESMTP id E9628D1B1C7 for ; Sat, 24 Jul 2004 00:26:21 -0300 (ADT) Received: from localhost.localdomain (c-67-162-89-61.client.comcast.net[67.162.89.61]) by comcast.net (rwcrmhc11) with ESMTP id <200407240326260130027j9re>; Sat, 24 Jul 2004 03:26:26 +0000 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.12.11/8.12.11) with ESMTP id i6O3NO2I011497; Fri, 23 Jul 2004 22:23:24 -0500 Received: (from spike@localhost) by localhost.localdomain (8.12.11/8.12.11/Submit) id i6O3NOiE011494; Fri, 23 Jul 2004 22:23:24 -0500 X-Authentication-Warning: localhost.localdomain: spike set sender to mike@thegodshalls.com using -f Subject: Re: Backup From: mike g Reply-To: mike@thegodshalls.com To: "Eduardo S. Fontanetti" Cc: pgsql-admin@postgresql.org In-Reply-To: <20040723122406.26066.qmail@web40708.mail.yahoo.com> References: <20040723122406.26066.qmail@web40708.mail.yahoo.com> Content-Type: text/plain; charset= Content-Transfer-Encoding: quoted-printable Message-Id: <1090639403.11436.4.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Fri, 23 Jul 2004 22:23:23 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/278 X-Sequence-Number: 14346 If you stop the postmaster service before copying the database directory yes. See http://www.postgresql.org/docs/7.4/static/backup-file.html Mike On Fri, 2004-07-23 at 07:24, Eduardo S. Fontanetti wrote: > I have a question. >=20 > I am getting trouble to dump my database with LO > (Large Object), but exactly at restoring. >=20 > Then I ask: If I just copy the data directory from > pgsql directory, I can restore the databases just > copying this directory back from a backup? >=20 > Thanks >=20 > Eduardo >=20 >=20 >=20=09 >=20=09 >=20=09=09 > _______________________________________________________ > Yahoo! Mail agora com 100MB, anti-spam e antiv=C3=ADrus gr=C3=A1tis! > http://br.info.mail.yahoo.com/ >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster