| From: | Terry Yapt <yapt(at)technovell(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | windows and pg 8.2 (change database to another server) |
| Date: | 2007-09-30 21:36:23 |
| Message-ID: | 470016D7.4090406@technovell.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 ?
Greetings...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Webb Sprague | 2007-09-30 23:28:43 | Inheritance fixing timeline? (Was "Inherited FK Indexing") |
| Previous Message | Martijn van Oosterhout | 2007-09-30 20:27:37 | Re: Please change default characterset for database cluster |