X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 456D752E1A for ; Fri, 12 Aug 2005 18:17:43 -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 21980-10 for ; Fri, 12 Aug 2005 21:17:40 +0000 (GMT) Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by svr1.postgresql.org (Postfix) with ESMTP id D274C52EE7 for ; Fri, 12 Aug 2005 18:17:35 -0300 (ADT) Received: from DELLMOTE ([151.201.138.110]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IL400MRCOHBEJD1@vms048.mailsrvcs.net> for pgsql-admin@postgresql.org; Fri, 12 Aug 2005 16:17:37 -0500 (CDT) Date: Fri, 12 Aug 2005 17:17:37 -0400 From: "Dirk Kalp" Subject: Re: Trouble Getting Database Server Started To: "Magnus Hagander" , Message-id: <002b01c59f83$43e10640$7001a8c0@DELLMOTE> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Mailer: Microsoft Outlook Express 6.00.2900.2180 Content-type: text/plain; format=flowed; charset=iso-8859-1; reply-type=original Content-transfer-encoding: 7bit X-Priority: 3 X-MSMail-priority: Normal References: <6BCB9D8A16AC4241919521715F4D8BCE094683@algol.sollentuna.se> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.168 tagged_above=0 required=5 tests=[AWL=0.168] X-Spam-Level: X-Archive-Number: 200508/162 X-Sequence-Number: 18481 Magnus, Thanks for the advice. I checked the Windows Event Logs and did not see anything there meaningful. The pg_log had only one interesting msg "incomplete startup packet" in one of the logs a couple days before Computer A had powered down. I don't know what this log msg means but I assume it is not the cause. But I'm neither a database expert or a Windows expert so I could be wrong. Thanks, Dirk ----- Original Message ----- From: "Magnus Hagander" To: "Dirk Kalp" ; Sent: Wednesday, August 10, 2005 3:23 PM Subject: RE: [ADMIN] Trouble Getting Database Server Started > I see from the Postgres archives that one can simply take a > copy of the installed PostgreSQL directory folder and move it > in place of the PostsgreSQL folder on a working system. I > took another computer (Computer B) and ran the same > installation script and tested to verify I could connect with > psql. Window's Task Manager showed > 6 postgres processes: postmaster.exe, pg_ctl.exe, and 4 > postgres.exe. (Not sure what the 4 postgres.exe are for.) That's normal. It's one logger, one bgwriter and two stats processes. > I don't know what caused Computer A to power down. It is in a > lab and someone may have inadvertently cut the power. Would > that corrupt the database to the point where I can't connect > to it or its startup mechanism be disrupted? I don't know > what role those 4 postgres.exe processes fill - are they part > of standard postgres startup? Secondly, I don't know why > sliding in the archived PostgreSQL folder on Computer B did not work. It normally sholdn't. You'll need to look into your logs to see wha thave happened. Both the files in pg_log and in the system eventlog. //Magnus