pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dirk Kalp <dkalp@sensormgmt.com>
To: pgsql-admin@postgresql.org
Subject: Trouble Getting Database Server Started
Date: Mon, 08 Aug 2005 17:11:11 -0400
Message-ID: <003401c59c5d$b475ae70$7001a8c0@DELLMOTE> (raw)

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

view thread (5+ messages)  latest in thread

Message-ID: <003401c59c5d$b475ae70$7001a8c0@DELLMOTE>
Permalink:  ../003401c59c5d$b475ae70$7001a8c0@DELLMOTE/
Also on:    postgresql.org/message-id/003401c59c5d$b475ae70$7001a8c0@DELLMOTE

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: dkalp@sensormgmt.com
  Subject: Re: Trouble Getting Database Server Started
  In-Reply-To: <003401c59c5d$b475ae70$7001a8c0@DELLMOTE>
  References: <003401c59c5d$b475ae70$7001a8c0@DELLMOTE>

* 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