Re: PgAdmin3 1.2.2 Install on Win32 Disrupts Pg Service

Thanks for your suggestions, Dario.

1. The user running as a service is not postgres. The user is a member
of Users group when all works correctly.
2. pg_ctl with the -D argument did not correct the problem.

I agree, the user running the service lost its environment. We
uninstalled PgAdmin3 1.2.2, ensured the user running postgres was not an
administrator, rebooted the system, and all works well now. Seems all I
needed was a system reboot.

Moral: Stop Postgres services before installing *any* Postgres software
on the server.

Original message below.

Randy Steuckrath
Unisys Corporation - Mission Viejo, CA

********************

Hi...
It seems odd...
1) ?Could you check the user running the service? ?Is it postgres? It
should be, unless you have changed.
2) ?could you try to specify data directory to pg_ctl with "-D"
parameter?
Example: "C:\Archivos de programa\PostgreSQL\8.0\bin\pg_ctl.exe" status
-D
"C:\Archivos de programa\PostgreSQL\8.0\data\" (replace Archivos de
programa\blabla with your binary and data path)

Probably, the user running the service lost its enviroment... May be you
need to setup it right... I'm not sure how to accomplish that... be
carefull
and RTFM ... (F = FANTASTIC!!!) :-)

-----Mensaje original-----
De: pgsql-admin-owner ( at ) postgresql ( dot ) org
[mailto:pgsql-admin-owner ( at ) postgresql ( dot ) org]En nombre de
Steuckrath, Randy A
Enviado el: jueves, 22 de septiembre de 2005 21:30
Para: pgsql-admin ( at ) postgresql ( dot ) org
Asunto: [ADMIN] 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? What shall I try next to
restore normal pg_ctl activity on the host?
Thanks for your consideration.
Randy Steuckrath
Unisys Corporation - Mission Viejo, CA

Randy Steuckrath
Unisys Corporation - Mission Viejo, CA
(949)380-6138 / (Net2)656-6138
THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you
received this in error, please contact the sender and delete the e-mail
and its attachments from all computers.