Re: Trouble Getting Database Server Started - Mailing list pgsql-admin

From Magnus Hagander
Subject Re: Trouble Getting Database Server Started
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE094683@algol.sollentuna.se
Whole thread Raw
In response to Trouble Getting Database Server Started  ("Dirk Kalp" <dkalp@sensormgmt.com>)
List pgsql-admin
> 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

pgsql-admin by date:

Previous
From: Chris Hoover
Date:
Subject: Re: PG 7.3.4 VS PG 8.0.3 Problem
Next
From: ljb
Date:
Subject: Re: REVOKE from all tables ...