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 57E0152EC7 for ; Fri, 12 Aug 2005 18:09:10 -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 36675-06 for ; Fri, 12 Aug 2005 21:09:06 +0000 (GMT) Received: from vms040pub.verizon.net (vms040pub.verizon.net [206.46.252.40]) by svr1.postgresql.org (Postfix) with ESMTP id 2CC9E52E27 for ; Fri, 12 Aug 2005 18:09:05 -0300 (ADT) Received: from DELLMOTE ([151.201.138.110]) by vms040.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IL4002BSO3583T4@vms040.mailsrvcs.net> for pgsql-admin@postgresql.org; Fri, 12 Aug 2005 16:09:07 -0500 (CDT) Date: Fri, 12 Aug 2005 17:09:06 -0400 From: "Dirk Kalp" Subject: Re: Trouble Getting Database Server Started To: Cc: Message-id: <002501c59f82$13ba2ba0$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: <003401c59c5d$b475ae70$7001a8c0@DELLMOTE> <1541.47.65.66.142.1123514186.squirrel@47.65.66.142> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.253 tagged_above=0 required=5 tests=[AWL=0.253] X-Spam-Level: X-Archive-Number: 200508/161 X-Sequence-Number: 18480 Karim, Thanks for the suggestion. I did try to reset and then set the postgres user's rights to "Logon as a service" in both the Local Security Policy and Services tools of the Windows Control Panel. It did not make any difference. I suspect that that is not the problem since it appears that the server is initially being launched but does not complete. Thanks, Dirk ----- Original Message ----- From: "Karim Mardhani" To: "Dirk Kalp" Cc: Sent: Monday, August 08, 2005 11:16 AM Subject: Re: [ADMIN] Trouble Getting Database Server Started > Hi Dirk: > > I have been seeing similar problems if PC pwered down rather than using > the Windows shut down facility. > > In my case the user which suppose to start the service loses "Logon as > service" right therefore service can not be started. > > On your computer A, check to see if the database service was started or > not. If not then give the user which suppose to start the service > "logon as service" rigth again and try to re-start the service. The > service should start. Once the service is started your front end > programe should be able to connect to backend database. > > Hope this helps. > > Karim > > >> Trouble Getting Database Server Started >> >> I'm no longer able to connect to the database with psql. PostgreSQL 8.0.0 >> was included as part of a software package I'm using to collect >> environmental >> data. It is a very simple logging application - mostly a single simple >> table >> with timestamp and 6 integers in each record and on the order of 50K >> records >> over the past 3 weeks. I'm using version 8.0.0 on Windows XP Pro. >> >> The vendor install script for the application installs the database as a >> Win32 Service >> to be launched when Windows boots up. I don't have access to the details >> of the >> install procedure. It has been working fine for 3 weeks but one morning >> the computer >> (I'll refer to it as Computer A) was found powered down and since then >> I've no >> longer been able to connect to the database. >> >> 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.) >> >> I next replaced the PostgreSQL folder with the one from my Computer A >> holding my >> collected data. After rebooting Computer B, Task Manager shows only >> postmaster.exe >> and pg_ctl.exe. I still can't connect with psql. >> >> Since I had a file system backup of Computer A from about a week prior >> when everything >> was working fine, I tried to see if I could get the archived PostgreSQL >> directory to >> work on Computer B. It also showed just postmaster.exe and pg_ctl.exe >> running and psql >> could not connect either. >> >> 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. >> >> Please let me know if further details are required. >> >> Thanks in advance for any help, >> Dirk Kalp >> > > > Regards, > > Karim Mardhani > ZeeCore Consulting > > >