X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A291B529BB for ; Mon, 8 Aug 2005 18:11:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67724-10 for ; Mon, 8 Aug 2005 21:11:15 +0000 (GMT) Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by svr1.postgresql.org (Postfix) with ESMTP id CF2D452988 for ; Mon, 8 Aug 2005 18:11:10 -0300 (ADT) Received: from DELLMOTE ([151.201.138.110]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IKX00JTB9IMM6Q6@vms048.mailsrvcs.net> for pgsql-admin@postgresql.org; Mon, 08 Aug 2005 16:11:11 -0500 (CDT) Date: Mon, 08 Aug 2005 17:11:11 -0400 From: "Dirk Kalp" Subject: Trouble Getting Database Server Started To: Message-id: <003401c59c5d$b475ae70$7001a8c0@DELLMOTE> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Mailer: Microsoft Outlook Express 6.00.2900.2180 Content-type: multipart/alternative; boundary="----=_NextPart_000_0031_01C59C3C.2D072160" X-Priority: 3 X-MSMail-priority: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.505 tagged_above=0 required=5 tests=HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200508/94 X-Sequence-Number: 18413 This is a multi-part message in MIME format. ------=_NextPart_000_0031_01C59C3C.2D072160 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Trouble Getting Database Server Started I'm no longer able to connect to the database with psql. PostgreSQL = 8.0.0=20 was included as part of a software package I'm using to collect = environmental=20 data. It is a very simple logging application - mostly a single simple = table=20 with timestamp and 6 integers in each record and on the order of 50K = records=20 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=20 longer been able to connect to the database. I see from the Postgres archives that one can simply take a copy of the = installed=20 PostgreSQL directory folder and move it in place of the PostsgreSQL = folder on a=20 working system. I took another computer (Computer B) and ran the same = installation=20 script and tested to verify I could connect with psql. Window's Task = Manager showed=20 6 postgres processes: postmaster.exe, pg_ctl.exe, and 4 postgres.exe. = (Not sure what=20 the 4 postgres.exe are for.) I next replaced the PostgreSQL folder with the one from my Computer A = holding my=20 collected data. After rebooting Computer B, Task Manager shows only = postmaster.exe=20 and pg_ctl.exe. I still can't connect with psql.=20 Since I had a file system backup of Computer A from about a week prior = when everything=20 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=20 inadvertently cut the power. Would that corrupt the database to the = point where I can't=20 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 ------=_NextPart_000_0031_01C59C3C.2D072160 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Trouble Getting Database Server=20 Started
 
I'm no longer able to connect to the = database with=20 psql. PostgreSQL 8.0.0
was included as part of a software package = I'm using=20 to collect environmental
data. It is a very simple logging = application -=20 mostly a single simple table
with timestamp and 6 integers in each = record=20 and on the order of 50K records
over the past 3 weeks. I'm using = version=20 8.0.0 on Windows XP Pro.
 
The vendor install script for the = application=20 installs the database as a Win32 Service
to be launched when Windows = boots=20 up. I don't have access to the details of the
install procedure. It = has been=20 working fine for 3 weeks but one morning the computer
(I'll refer to = it as=20 Computer A) was found powered down and since then I've no
longer = been able=20 to connect to the database.
 
I see from the Postgres archives that = one can=20 simply take a copy of the installed
PostgreSQL directory folder and = move it=20 in place of the PostsgreSQL folder on a
working system. I took = another=20 computer (Computer B) and ran the same installation
script and = tested to=20 verify I could connect with psql. Window's Task Manager showed
6 = postgres=20 processes: postmaster.exe, pg_ctl.exe, and 4 postgres.exe. (Not sure = what=20
the 4 postgres.exe are for.)
 
I next replaced the PostgreSQL folder = with the one=20 from my Computer A holding my
collected data. After rebooting = Computer B,=20 Task Manager shows only postmaster.exe
and pg_ctl.exe. I still can't = connect=20 with psql.
 
Since I had a file system backup of = Computer A from=20 about a week prior when everything
was working fine, I tried to see = if I=20 could get the archived PostgreSQL directory to
work on Computer B. It = also=20 showed just postmaster.exe and pg_ctl.exe running and psql
could not = connect=20 either.
 
I don't know what caused Computer A to = power down.=20 It is in a lab and someone may have
inadvertently cut the power. = Would that=20 corrupt the database to the point where I can't
connect to it or its = startup=20 mechanism be disrupted? I don't know what role those 4
postgres.exe = processes=20 fill - are they part of standard postgres startup? Secondly, I
don't = know why=20 sliding in the archived PostgreSQL folder on Computer B did not=20 work.
 
Please let me know if further details = are=20 required.
 
Thanks in advance for any help,
Dirk = Kalp
------=_NextPart_000_0031_01C59C3C.2D072160--