X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D8F01D96FF for ; Mon, 26 Sep 2005 12:15:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12867-02 for ; Mon, 26 Sep 2005 15:14:58 +0000 (GMT) Received: from netbox.unitech.com.ar (unknown [200.32.92.34]) by svr1.postgresql.org (Postfix) with ESMTP id AB790D96FC for ; Mon, 26 Sep 2005 12:14:55 -0300 (ADT) Received: from dariop (dariop.unitech.com.ar [192.168.1.237]) by netbox.unitech.com.ar (8.11.6/8.11.6) with ESMTP id j8QGO5G31783 for ; Mon, 26 Sep 2005 12:24:05 -0400 Received: from 127.0.0.1 (AVG SMTP 7.0.344 [267.11.6]); Mon, 26 Sep 2005 12:15:15 -0300 From: "Dario" To: Subject: Re: PgAdmin3 1.2.2 Install on Win32 Disrupts Pg Service Date: Mon, 26 Sep 2005 12:15:15 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.058 required=5 tests=[AWL=0.058] X-Spam-Level: X-Archive-Number: 200509/290 X-Sequence-Number: 19027 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