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@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]En nombre de Steuckrath, Randy A
Enviado el: jueves, 22 de septiembre de 2005 21:30
Para: pgsql-admin@postgresql.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
