pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dario <dario_d_s@unitech.com.ar>
To: pgsql-admin@postgresql.org
Subject: Re: PgAdmin3 1.2.2 Install on Win32 Disrupts Pg Service
Date: Mon, 26 Sep 2005 12:15:15 -0300
Message-ID: <MHEDJHCKDNOEHJKHIOCJEELDCHAA.dario_d_s@unitech.com.ar> (raw)
In-Reply-To: <B6419AF36AC8524082E1BC17DA2506E801A363E9@USMV-EXCH2.na.uis.unisys.com>

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




view thread (3+ messages)  latest in thread

Message-ID: <MHEDJHCKDNOEHJKHIOCJEELDCHAA.dario_d_s@unitech.com.ar>
Permalink:  ../MHEDJHCKDNOEHJKHIOCJEELDCHAA.dario_d_s@unitech.com.ar/
Also on:    postgresql.org/message-id/MHEDJHCKDNOEHJKHIOCJEELDCHAA.dario_d_s@unitech.com.ar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: dario_d_s@unitech.com.ar
  Subject: Re: PgAdmin3 1.2.2 Install on Win32 Disrupts Pg Service
  In-Reply-To: <MHEDJHCKDNOEHJKHIOCJEELDCHAA.dario_d_s@unitech.com.ar>
  References: <B6419AF36AC8524082E1BC17DA2506E801A363E9@USMV-EXCH2.na.uis.unisys.com> <MHEDJHCKDNOEHJKHIOCJEELDCHAA.dario_d_s@unitech.com.ar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox