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 CB020528D0 for ; Wed, 15 Jun 2005 12:48:34 -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 29207-10 for ; Wed, 15 Jun 2005 15:48:29 +0000 (GMT) Received: from vscan01.westnet.com.au (vscan01.westnet.com.au [203.10.1.131]) by svr1.postgresql.org (Postfix) with ESMTP id 7B42F52881 for ; Wed, 15 Jun 2005 12:48:25 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by localhost (Postfix) with ESMTP id 764707602C9; Wed, 15 Jun 2005 23:48:23 +0800 (WST) Received: from vscan01.westnet.com.au ([127.0.0.1]) by localhost (vscan01.westnet.com.au [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12699-04; Wed, 15 Jun 2005 23:48:23 +0800 (WST) Received: from [202.72.133.22] (dsl-202-72-133-22.wa.westnet.com.au [202.72.133.22]) by vscan01.westnet.com.au (Postfix) with ESMTP id DA45E760167; Wed, 15 Jun 2005 23:48:22 +0800 (WST) Message-ID: <42B04DC6.2090708@familyhealth.com.au> Date: Wed, 15 Jun 2005 23:48:22 +0800 From: Christopher Kings-Lynne User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: operationsengineer1@yahoo.com Cc: "pgsql-php@postgresql.org" Subject: Re: pg_dump References: <20050615152716.84366.qmail@web33311.mail.mud.yahoo.com> In-Reply-To: <20050615152716.84366.qmail@web33311.mail.mud.yahoo.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/11 X-Sequence-Number: 3170 Only problem is you need to stop PostgreSQL from running to do it... operationsengineer1@yahoo.com wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)