Thread: PgAdmin3 1.2.2 Install on Win32 Disrupts Pg Service

PgAdmin3 1.2.2 Install on Win32 Disrupts Pg Service

From
"Steuckrath, Randy A"
Date:

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

Re: PgAdmin3 1.2.2 Install on Win32 Disrupts Pg Service

From
"Dario"
Date:
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


Re: PgAdmin3 1.2.2 Install on Win32 Disrupts Pg Service

From
"Steuckrath, Randy A"
Date:
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.