Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 02F5B2E2E95 for ; Thu, 15 Nov 2007 17:02:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 77343-02-5 for ; Thu, 15 Nov 2007 17:02:22 -0400 (AST) Received: from bay0-omc3-s40.bay0.hotmail.com (bay0-omc3-s40.bay0.hotmail.com [65.54.246.240]) by postgresql.org (Postfix) with ESMTP id 38AB92E2EB2 for ; Thu, 15 Nov 2007 17:02:37 -0400 (AST) Received: from BAY127-W45 ([65.55.132.80]) by bay0-omc3-s40.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Thu, 15 Nov 2007 13:02:35 -0800 Message-ID: Content-Type: multipart/alternative; boundary="_f80f2a65-6aa5-436e-9e68-96820bf13bb1_" X-Originating-IP: [75.166.47.117] From: Trent Pingenot To: Subject: PG Service won't start Date: Thu, 15 Nov 2007 14:02:35 -0700 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 15 Nov 2007 21:02:35.0550 (UTC) FILETIME=[D8E013E0:01C827CA] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200711/159 X-Sequence-Number: 27402 --_f80f2a65-6aa5-436e-9e68-96820bf13bb1_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello list, I made a really dumb mistake of killing a fairly simple select query (no in= serts or updates) that was taking way to long to cancel. I foolishly kille= d the query by closing the window in PGAdmin3. Alas I figured it was time = for a reboot so I rebooted. Upon reboot my PG Service won't start. I tried starting it manually but comes back saying it won't start but didn'= t report an error. I check the Event Viewer and I see "could not open process token: error cod= e 5" I tried rebooting again. I tried starting with with pg_ctrl C:\Program Files\PostgreSQL\8.2\bin>pg_ctl start -w -l mylog.txt -D C:\Pro= gram%20Files\PostgreSQL\8.2\data waiting for server to start...Access is denied. ............................................................could not start= server but again without luck. No log file was created. The version is 8.2.3 running on Windows 2000 Server SP4. It's been running for a year or more without problems. We have several data= bases, several table_spaces and lots of data. We have backup dumps of some = but not all of the data so it wouldn't be a total loss, but it would be nic= e to recover. We are using the PostGIS "extension" since we deal with geogr= aphic data almost exclusively, not sure if that complicates anything. Any ideas or a suggestions would be much appreciated. I feel pretty stupid = for being impatient. Thanks in advance, Trent --_f80f2a65-6aa5-436e-9e68-96820bf13bb1_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello list,
<= br>I made a really dumb mistake of killing a fairly simple select query (no= inserts or updates) that was taking way to long to cancel.  I foolish= ly killed the query by closing the window in PGAdmin3.  Alas I figured= it was time for a reboot so I rebooted. Upon reboot my PG Service won't st= art.

I tried starting it manually but comes back saying it won't sta= rt but didn't report an error.

I check the Event Viewer and I see "c= ould not open process token: error code 5"

I tried rebooting again.<= br>
I tried starting with with pg_ctrl

C:\Program Files\PostgreSQ= L\8.2\bin>pg_ctl start -w  -l mylog.txt -D C:\Program%20Files\Postg= reSQL\8.2\data
waiting for server to start...Access is denied.
......= ......................................................could not start serve= r

 but again without luck. No log file was created.

The = version is 8.2.3 running on Windows 2000 Server SP4.

It's been runni= ng for a year or more without problems. We have several databases, several = table_spaces and lots of data. We have backup dumps of some but not all of = the data so it wouldn't be a total loss, but it would be nice to recover. W= e are using the PostGIS "extension" since we deal with geographic data almo= st exclusively, not sure if that complicates anything.

Any ideas or = a suggestions would be much appreciated. I feel pretty stupid for being imp= atient.

Thanks in advance,

Trent
= --_f80f2a65-6aa5-436e-9e68-96820bf13bb1_--