pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Geoffrey Ducharme <geoffrey.ducharme@gmail.com>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Task manager fails to terminate postmaster process.
Date: Fri, 18 Feb 2005 17:39:42 -0500
Message-ID: <50526dc90502181439b18993d@mail.gmail.com> (raw)
In-Reply-To: <42164517.2050009@commandprompt.com>
References: <50526dc905021811251d189d2b@mail.gmail.com>
	<42164517.2050009@commandprompt.com>

Thanks for the tip. I tried logging in as the service and I managed to
shut down the service.

I also saw how I had originally misconfigured the system. Since not
all accounts are stored in the same place, I had to dig in a little
deeper to grab the old, wrong account. From there, reinstalling
Postgresql, "dump"ing from the XP machine and migrating was a snap.

Thank you again,

Geoffrey


On Fri, 18 Feb 2005 11:42:15 -0800, Joshua D. Drake
<jd@commandprompt.com> wrote:
> Geoffrey Ducharme wrote:
> > Hi everyone, I'm new to PostgreSQL administration. I hope the people
> > here will have some ideas to help me out.
> >
> > My current situation is that I am moving my database across machines
> > without access to network. It would be possible, but more difficult to
> > install a network.
> >
> > I understand that the recommanded way to make a back up is to shut
> > down the postmaster and related process, then copy the files. This
> > worked fine on the donor machine. (Windows XP SP2 postgresql 8.0.1)
> >
> > I grabbed the file to send them to the receiving machine (Win 2000) On
> > this one, however, I had a problem. The Task Manager does not allow me
> > to shut off the postmaster process. Specificaly the error message
> > says:"Unable to terminate process, the requested operation could not
> > be completed. Access is denied".
> 
> It sounds like you are trying to shut down the service without being an
> administrator or the owner of PostgreSQL?
> 
> Sincerely,
> 
> Joshua D. Drake
> 
> >
> > My impression is that such an error message wold only happen on system
> > critical process.
> >
> > So, what is the problem? Is this the right path to migration? Would
> > installing the network a be a better solution?
> >
> > Wondering,
> >
> > Geoffrey
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> >                http://www.postgresql.org/docs/faq
> 
> --
> Command Prompt, Inc., your source for PostgreSQL replication,
> professional support, programming, managed services, shared
> and dedicated hosting. Home of the Open Source Projects plPHP,
> plPerlNG, pgManage,  and pgPHPtoolkit.
> Contact us now at: +1-503-667-4564 - http://www.commandprompt.com
> 
> 
>



view thread (3+ messages)

Message-ID: <50526dc90502181439b18993d@mail.gmail.com>
Permalink:  ../50526dc90502181439b18993d@mail.gmail.com/
Also on:    postgresql.org/message-id/50526dc90502181439b18993d@mail.gmail.com

 · 

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: geoffrey.ducharme@gmail.com, jd@commandprompt.com
  Subject: Re: Task manager fails to terminate postmaster process.
  In-Reply-To: <50526dc90502181439b18993d@mail.gmail.com>
  References: <50526dc905021811251d189d2b@mail.gmail.com> <42164517.2050009@commandprompt.com> <50526dc90502181439b18993d@mail.gmail.com>

* 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