Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8462B2E002F for ; Thu, 14 Feb 2008 18:41:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 16700-06 for ; Thu, 14 Feb 2008 18:41:14 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.181]) by postgresql.org (Postfix) with ESMTP id 663672E0032 for ; Thu, 14 Feb 2008 18:41:19 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d37so840239pye.29 for ; Thu, 14 Feb 2008 14:41:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=4BjYRoCT3FsrKOu5EeONJ5BkPpIvyCYA1MsOHL8VXRs=; b=txY2d9/uuma0UDSIVash/aZOd8PfbOS30MOyuk6lIhpslzEH2kAF1VSXAeX73ReogSkmJfV/Dxz/wDrNvFJ9Id/ZXoUEY8hdulgw2TNC8ujPUZQC/aquAzWIQOQpUEFORD379QpBERJR9d3SYi4l7ckbyYKvvKHjuWHpvm9JR9Q= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=WjTLxqkNl7wS5B4cqopo+FS2xOkLN3Lj7cSjoLtFej4zDfXUxU475+lCXdElfZ8QEQwIzUzs+BaPspIaNEuWSSCneIDO3j9h4yohuWOSNLxVEWqEOwItZPfuhS/VxAyMsIjw8shragIIKCzXpJsGwShdBA1twvp1dYDvYL5ajCs= Received: by 10.65.204.7 with SMTP id g7mr2316443qbq.73.1203028878174; Thu, 14 Feb 2008 14:41:18 -0800 (PST) Received: by 10.65.222.17 with HTTP; Thu, 14 Feb 2008 14:41:18 -0800 (PST) Message-ID: <9abe84da0802141441t245c9322qd3dfe9a90150db1a@mail.gmail.com> Date: Thu, 14 Feb 2008 17:41:18 -0500 From: "libra dba" To: pgsql-admin@postgresql.org Subject: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3451_28336510.1203028878167" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/187 X-Sequence-Number: 28261 ------=_Part_3451_28336510.1203028878167 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello all, I am new to postgresql. i am working on the PITR replication system. I have successfully implemented the standby database. I have tested the log shipment and the recovery process on the standby. everything is workign fine. Please guide me how to bring the standby database in open mode (failover). Also it would be great if you could provide a sample trigger file. thanks ------=_Part_3451_28336510.1203028878167 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hello all,
 
I am new to postgresql. i am working on the PITR replication system. I have successfully implemented the standby database. I have tested the log shipment and the recovery process on the standby. everything is workign fine.
 
Please guide me how to bring the standby database in open mode (failover). Also it would be great if you could provide a sample trigger file.
 
thanks
------=_Part_3451_28336510.1203028878167--