Hosting Provided By

[GENERAL] windows and pg 8.2 (change database to another server)

From: Terry Yapt <yapt(at)technovell.com>
Date: Sun Sep 30 2007 - 17:36:23 EDT

Hello all,

I would like to change a pg database to another server.

The source environment is: postgresql Windows v.8.2.4 (windows xp workstation).
The target environment is: postgresql Windows v.8.2.5 (windows 2003 Server).

I would like to do migration without pg_dumpall and I think I can do the migration process _only_ copying this (after stop Postgresql service, of course):
1.- Data directory (c:\program files\postgresql\8.2\data). 2.- Another TableSpace folders/directories.

But after copy that folders to my new server, service PostgreSQL doesn't start with a 'cannot create postmaster.pid'.

First of all. I think this method is admisible. Isn't it ?

And second question: I think my problem is that some rights are wrong after copying data folder. What are the right rights to apply to data folder ?

Any other 'direct' migration process ?

Do you need help?

Greetings...

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq Received on Sun Sep 30 18:33:42 2007

This message: [ Message body ]
Next message: Webb Sprague: "[GENERAL] Inheritance fixing timeline? (Was "Inherited FK Indexing")"
Previous message: Martijn van Oosterhout: "Re: [GENERAL] Please change default characterset for database cluster"
Next in thread: Magnus Hagander: "Re: [GENERAL] windows and pg 8.2 (change database to another server)"
Reply: Magnus Hagander: "Re: [GENERAL] windows and pg 8.2 (change database to another server)"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 11:58:43 EDT