pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Trent Pingenot <pintj@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: PG Service won't start
Date: Thu, 15 Nov 2007 14:02:35 -0700
Message-ID: <BAY127-W457434634D7601D31DF495A6820@phx.gbl> (raw)

Hello list,

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 foolishly 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 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 code 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:\Program%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 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. We are using the PostGIS "extension" since we deal with geographic 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

Message-ID: <BAY127-W457434634D7601D31DF495A6820@phx.gbl>
Permalink:  ../BAY127-W457434634D7601D31DF495A6820@phx.gbl/
Also on:    postgresql.org/message-id/BAY127-W457434634D7601D31DF495A6820@phx.gbl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: pintj@hotmail.com
  Subject: Re: PG Service won't start
  In-Reply-To: <BAY127-W457434634D7601D31DF495A6820@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox