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