Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 023BD1337B56 for ; Tue, 9 Nov 2010 18:13:08 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 73495-01 for ; Tue, 9 Nov 2010 22:13:00 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nrccenhts1.nrc.ca (nrccenhts2.nrc.ca [132.246.15.89]) by mail.postgresql.org (Postfix) with ESMTP id 81FDC133798E for ; Tue, 9 Nov 2010 18:13:00 -0400 (AST) Received: from NRCWSTHCM1.NRC.CA (132.246.216.66) by nrccenhts2.nrc.ca (132.246.15.89) with Microsoft SMTP Server (TLS) id 8.1.436.0; Tue, 9 Nov 2010 17:12:58 -0500 Received: from [132.246.194.17] (132.246.216.202) by WSTMAIL.NRC.CA (132.246.216.66) with Microsoft SMTP Server (TLS) id 8.1.436.0; Tue, 9 Nov 2010 14:12:57 -0800 Message-ID: <4CD9C768.9060308@nrc-cnrc.gc.ca> Date: Tue, 9 Nov 2010 14:12:56 -0800 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: PG HA solution using DBRD Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.79 tagged_above=-10 required=5 tests=BAYES_05=-0.5, RCVD_IN_DNSWL_MED=-2.3, T_FRT_BELOW2=0.01 X-Spam-Level: X-Archive-Number: 201011/68 X-Sequence-Number: 36034 Hi All, I 'm testing a HA solution for a PG version 9.01 database configured using DBRD for pg_xlog directory and user data /table space partitions.( block disk changes are copied from master to slave ) the archive mode option is off for both master and slaver node, when I power off master without a clean PG shutdown the slave database server will not start. Bellow is the errror, what are my option to increase the checkpoint frequency ? archive_mode is off for both server database system was interrupted; last known up at 2010-11-09 08:27:02 PST 2010-11-09 13:20:03 PST [8505]: [2-1] LOG: could not open file "pg_xlog/00000001000000BC00000006" (log file 188, segment 6): No such file or directory 2010-11-09 13:20:03 PST [8505]: [3-1] LOG: invalid primary checkpoint record 2010-11-09 13:20:03 PST [8505]: [4-1] LOG: could not open file "pg_xlog/00000001000000BC00000006" (log file 188, segment 6): No such file or directory 2010-11-09 13:20:03 PST [8505]: [5-1] LOG: invalid secondary checkpoint record 2010-11-09 13:20:03 PST [8505]: [6-1] PANIC: could not locate a valid checkpoint record 2010-11-09 13:20:03 PST [8499]: [2-1] LOG: startup process (PID 8505) was terminated by signal 6: Aborted 2010-11-09 13:20:03 PST [8499]: [3-1] LOG: aborting startup due to startup process failure postgres@proc5-15:errorlog$ Thank you Isabella -- ----------------------------------------------------------- Isabella A. Ghiurea Isabella.Ghiurea@nrc-cnrc.gc.ca Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research Council of Canada, Herzberg Institute of Astrophysics 5071 West Saanich Road, Victoria BC V9E 2E7, Canada Phone: 250 363-3446 fax: 250 363-0045