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
>
>
>
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