Trouble Getting Database Server Started
| От | Dirk Kalp |
|---|---|
| Тема | Trouble Getting Database Server Started |
| Дата | |
| Msg-id | 003401c59c5d$b475ae70$7001a8c0@DELLMOTE обсуждение исходный текст |
| Ответы |
Re: Trouble Getting Database Server Started
|
| Список | pgsql-admin |
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.
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.
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.)
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.
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.
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.
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
Dirk Kalp
В списке pgsql-admin по дате отправления: