Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

windows and pg 8.2 (change database to another server)



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group