From: Dirk Kalp <dkalp@sensormgmt.com>
To: Magnus Hagander <mha@sollentuna.net>
To: pgsql-admin@postgresql.org
Subject: Re: Trouble Getting Database Server Started
Date: Fri, 12 Aug 2005 17:17:37 -0400
Message-ID: <002b01c59f83$43e10640$7001a8c0@DELLMOTE> (raw)
References: <6BCB9D8A16AC4241919521715F4D8BCE094683@algol.sollentuna.se>
Magnus,
Thanks for the advice. I checked the Windows Event Logs and did not see
anything there meaningful. The pg_log had only one interesting msg
"incomplete startup packet" in one of the logs a couple days before Computer
A had powered down. I don't know what this log msg means but I assume it is
not the cause. But I'm neither a database expert or a Windows expert so I
could be wrong.
Thanks,
Dirk
----- Original Message -----
From: "Magnus Hagander" <mha@sollentuna.net>
To: "Dirk Kalp" <dkalp@sensormgmt.com>; <pgsql-admin@postgresql.org>
Sent: Wednesday, August 10, 2005 3:23 PM
Subject: RE: [ADMIN] Trouble Getting Database Server Started
> 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.)
That's normal. It's one logger, one bgwriter and two stats processes.
> 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.
It normally sholdn't. You'll need to look into your logs to see wha
thave happened. Both the files in pg_log and in the system eventlog.
//Magnus
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, mha@sollentuna.net
Subject: Re: Trouble Getting Database Server Started
In-Reply-To: <002b01c59f83$43e10640$7001a8c0@DELLMOTE>
References: <6BCB9D8A16AC4241919521715F4D8BCE094683@algol.sollentuna.se> <002b01c59f83$43e10640$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