X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C4FB28BA1DF for ; Fri, 18 Feb 2005 22:40:41 +0000 (GMT) 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 66907-03 for ; Fri, 18 Feb 2005 22:40:29 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.194]) by svr1.postgresql.org (Postfix) with ESMTP id 260648BA31C for ; Fri, 18 Feb 2005 22:40:10 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id r35so518rna for ; Fri, 18 Feb 2005 14:39:43 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=E5liJmrfs/WmPuFQc7zxBzmqyX5Y52NPKXbak8a9Tubp6fXpe9HZd8oPpktCA6ryd1WQKqIBPRdq5A3qjkw46BF7ZjaCJ98lkBBdcppcO03sTWX85wSe0gLYmOfsfA/bCaHRDgztdyuUlgnKvHHPBRP0Xq9L8nymw4+tplcs8qY= Received: by 10.38.151.22 with SMTP id y22mr51077rnd; Fri, 18 Feb 2005 14:39:43 -0800 (PST) Received: by 10.38.102.35 with HTTP; Fri, 18 Feb 2005 14:39:42 -0800 (PST) Message-ID: <50526dc90502181439b18993d@mail.gmail.com> Date: Fri, 18 Feb 2005 17:39:42 -0500 From: Geoffrey Ducharme Reply-To: Geoffrey Ducharme To: "Joshua D. Drake" Subject: Re: Task manager fails to terminate postmaster process. Cc: pgsql-admin@postgresql.org In-Reply-To: <42164517.2050009@commandprompt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <50526dc905021811251d189d2b@mail.gmail.com> <42164517.2050009@commandprompt.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.286 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/173 X-Sequence-Number: 16341 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 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 > > >