Re: PgAdmin3 1.2.2 Install on Win32 Disrupts Pg Service

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Lee,
> Patricia S.
> Sent: 23 September 2005 17:46
> To: pgsql-hackers@postgresql.org; psql-novice@postgresql.org
> Subject: [HACKERS] PgAdmin3 1.2.2 Install on Win32 Disrupts Pg Service
>
> System: Windows XP Pro SP2
> Running Postgres 8.0.3 for several months with the embedded PgAdmin3
> 1.2.1 on the same machine with no problems. Postgres is configured to
> start automatically as a service. I installed the PgAdmin3 1.2.2 which
> requested a Windows reboot. I rebooted without stopping Postgres and
> then couldn't restart the Postgres service. Manual restarts
> with pg_ctl
> and postmaster commands complained that the user must not have admin
> privilege. So, I changed the user's group to non-privileged status and
> uninstalled PgAdmin3 1.2.2. Now, the Postgres service starts and runs,
> PgAdmin3 1.2.1 works (and PgAdmin3 1.2.2 works remotely) but pg_ctl
> status claims there's no postmaster nor postgres running. What might
> have the installation of PgAdmin3 1.2.2 done to upset this
> installation?

Nothing that I can imagine. It shops with the same versions of the
shared DLLs as come with 8.0.3 anyway, and everything else installs in
it's own directory and really doesn't care what else is installed. Even
if pgAdmin 1.2.2 installed a corrupted dll for some odd reason,
uninstalling it again wouldn't have caused the old file to be restored,
so things would still be broken.

I suspect the pgAdmin installation is a red herring to a whole different
problem. You could try running the PostgreSQL 8.0.3 installer to repair
the installation, then upgrade the pgAdmin.exe file within the embedded
installation with the one from the 1.2.2 pgAdmin installer.

Regards, Dave.