X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B995E9FB3DE for ; Thu, 21 Sep 2006 12:45:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 13713-10 for ; Thu, 21 Sep 2006 12:45:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from bay0-omc3-s29.bay0.hotmail.com (bay0-omc3-s29.bay0.hotmail.com [65.54.246.229]) by postgresql.org (Postfix) with ESMTP id 825379FB3CD for ; Thu, 21 Sep 2006 12:45:09 -0300 (ADT) Received: from hotmail.com ([64.4.38.32]) by bay0-omc3-s29.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 21 Sep 2006 08:45:08 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 21 Sep 2006 08:45:08 -0700 Message-ID: Received: from 64.4.38.200 by by116fd.bay116.hotmail.msn.com with HTTP; Thu, 21 Sep 2006 15:45:06 GMT X-Originating-IP: [66.160.12.211] X-Originating-Email: [bitsandbytes88@hotmail.com] X-Sender: bitsandbytes88@hotmail.com From: "Mr. Dan" To: pgsql-admin@postgresql.org Subject: psql: FATAL: the database system is starting up Date: Thu, 21 Sep 2006 11:45:06 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 21 Sep 2006 15:45:08.0204 (UTC) FILETIME=[EA46BAC0:01C6DD94] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.51 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: * X-Archive-Number: 200609/226 X-Sequence-Number: 23140 Hi, We had to kill postmaster, and it's been ugly. The last backup finished successfully not last night, but the night before. This is 161 GB database. How long should I expect this to take before it starts. Developers are coming into my office every 5 minutes asking for updates. It's never taken this long to come back. We did have an awful lot of transactions last night. Is the server replaying everything fhttp://by116fd.bay116.hotmail.msn.com/cgi-bin/compose?&curmbox=00000000%2d0000%2d0000%2d0000%2d000000000001&a=3b0ef010ec78a7ca825dcdc7953aaf4c22ff15917d66f2ef8a3ddf1fd5dbd659# Sendrom the last succesful backup? Is it hanging because it can't find some WAL files that were archived? It's been an hour and a half so far. Would a reboot help? ~DjK ep 21 10:07:05 p postgres[28301]: [2-3] recovery. Sep 21 10:07:05 p postgres[28301]: [3-1] < % %2006-09-21 10:07:05 EDT>LOG: checkpoint record is at 14D/69FFBD8 Sep 21 10:07:05 p postgres[28301]: [4-1] < % %2006-09-21 10:07:05 EDT>LOG: redo record is at 14D/696AC20; undo record is at 0/0; shutdown FALSE Sep 21 10:07:05 p postgres[28301]: [5-1] < % %2006-09-21 10:07:05 EDT>LOG: next transaction ID: 39405490; next OID: 1799955 Sep 21 10:07:05 p postgres[28301]: [6-1] < % %2006-09-21 10:07:05 EDT>LOG: next MultiXactId: 5696; next MultiXactOffset: 11694 Sep 21 10:07:05 p postgres[28301]: [7-1] < % %2006-09-21 10:07:05 EDT>LOG: database system was not properly shut down; automatic recovery in progress Sep 21 10:07:05 p postgres[28301]: [8-1] < % %2006-09-21 10:07:05 EDT>LOG: redo starts at 14D/696AC20 Sep 21 10:07:20 p postgres[28305]: [2-1] <[unknown] %[unknown] %2006-09-21 10:07:20 EDT>LOG: invalid length of startup packet