Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 25FE0650EB3 for ; Wed, 2 Jul 2008 14:15:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 03957-10 for ; Wed, 2 Jul 2008 14:15:40 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.28]) by postgresql.org (Postfix) with ESMTP id A7BCE650E92 for ; Wed, 2 Jul 2008 14:15:37 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 3so198304ywj.73 for ; Wed, 02 Jul 2008 10:15:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:in-reply-to:references :mime-version:content-type:message-id:cc:content-transfer-encoding :from:subject:date:to:x-mailer; bh=dBeVUUZmn6RgCSTucCV68pvu/nv1kswDkVu6MlC49Ik=; b=TkWGhUdl9m+U6YAuZudgfXEiM9+IEH4KmhK/o8QA+engh6oi7KwovdGdgGGwG868um BRjBths+UjVDJ/wfOSC3QZNoanY4lPnQA21kGhw14B2BP8JcaNFYSx4csg73Iu50NS12 mVQldcJ3KLUnCVXGYUKUd1xtlCGYW8PpQ6Lfw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=in-reply-to:references:mime-version:content-type:message-id:cc :content-transfer-encoding:from:subject:date:to:x-mailer; b=AYOf+KRFkEPC4Zd29hZX2LWusODCFq68WXmM69VCoAnH6pOD47cvVPBDESmmSeEX3H hK/QCFqROb9MsIk//wFeKza5bcCVU56uz+Ytp4IqC7kJM2zYMnbN0zWAuyusiIX9SKlx 9kh9xSBFT25Ul/9yFQEyMrXXKMIBc/Mz9fbXE= Received: by 10.103.40.5 with SMTP id s5mr3685800muj.133.1215018932956; Wed, 02 Jul 2008 10:15:32 -0700 (PDT) Received: from ?192.168.0.24? ( [83.14.243.146]) by mx.google.com with ESMTPS id w5sm35464813mue.11.2008.07.02.10.15.30 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 02 Jul 2008 10:15:31 -0700 (PDT) In-Reply-To: <486894ea.1e018e0a.412a.7ba9@mx.google.com> References: <486894ea.1e018e0a.412a.7ba9@mx.google.com> Mime-Version: 1.0 (Apple Message framework v753.1) Content-Type: text/plain; charset=WINDOWS-1250; delsp=yes; format=flowed Message-Id: Cc: Content-Transfer-Encoding: quoted-printable From: paul socha Subject: Re: queries Date: Wed, 2 Jul 2008 19:15:25 +0200 To: "kartik" X-Mailer: Apple Mail (2.753.1) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/27 X-Sequence-Number: 29637 On 2008-06-30, at 10:10, kartik wrote: > Hello there, > I was wondering that is there is any clustering available for =20 > postgresql database pgcluser ? ;] > And > > Can anyone tell me how to recover a database as we do in oracle , =20 > we have a command in oracle for recovering =91=92Alter database = recover=94 > Similarly do we have anything for postgresql > > > Yes and no :-) http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html All information about backup and restore ;-) Serdecznie pozdrawiam Pawel Socha pawel.socha@gmail.com programista/administrator perl -le 's**02).4^&-%2,).^9%4^!./4(%2^3,!#+7!2%^53%2&**y%& -;^[%"`-=20 { a%%s%%$_%ee'