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
begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:[EMAIL PROTECTED] title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
