X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AB71152800 for ; Wed, 15 Jun 2005 12:27:24 -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 26083-04 for ; Wed, 15 Jun 2005 15:27:18 +0000 (GMT) Received: from web33311.mail.mud.yahoo.com (web33311.mail.mud.yahoo.com [68.142.206.126]) by svr1.postgresql.org (Postfix) with SMTP id 185F3528E0 for ; Wed, 15 Jun 2005 12:27:17 -0300 (ADT) Received: (qmail 84368 invoked by uid 60001); 15 Jun 2005 15:27:16 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=yfjEQDi3fhKEPPaorOY1GSN96KG4R2N2O3U9DdDC9c8kRd/tVb0XL1HqZLhhRbjaPo29HJOUyDX8nZiguCsZZ0FuR81gqmp6Nq+j3PoYVuMfGUoW9hH6M4fynxAXDoi3fXgqscW2l2ZR0rna6sBKR5RXDyDofbEEzPcSXVeNHx0= ; Message-ID: <20050615152716.84366.qmail@web33311.mail.mud.yahoo.com> Received: from [12.9.179.126] by web33311.mail.mud.yahoo.com via HTTP; Wed, 15 Jun 2005 08:27:16 PDT Date: Wed, 15 Jun 2005 08:27:16 -0700 (PDT) From: Subject: Re: pg_dump To: "pgsql-php@postgresql.org" In-Reply-To: <42AF8333.7060205@familyhealth.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.745 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_YAHOO_RCVD, NO_REAL_NAME, TO_ADDRESS_EQ_REAL X-Spam-Level: ** X-Archive-Number: 200506/10 X-Sequence-Number: 3169 i read that you can copy the contents of pgsql's data directory to create a backup, too. in order to restore the db, you clean out the data directory and then copy the "backed up" files back in to the data directory. i have no experience using this method, but i thought i'd mention it to see if anyone else has done this. --- Christopher Kings-Lynne wrote: > pg_dumpall > backup.sql > > Chris > > enzo venegas palacios wrote: > > hi, i don't know use the pg_dump instruccion and i > need create a backup, > > please someone has an example. > > thanks > > enzo > > > --------------------------------------------------------- > > > > Imagina tus vacaciones perfectas... y hazlas > realidad. Juega en http://sorteos.ya.com > > ADSL + Llamadas 24 horas: desde 28,95 €/mes + IVA. > Navega y habla de forma ilimitada. Sin compromiso de > permanencia. http://acceso.ya.com/ADSLllamadas/ > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 9: the planner will ignore your desire to > choose an index scan if your > > joining column's datatypes do not match > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the > unregister command > (send "unregister YourEmailAddressHere" to > majordomo@postgresql.org) > __________________________________ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail