Page 1 of 1

Transferring previous Postgres data to new install?

PostPosted: Sat May 24, 2008 4:47 pm
by PascalT
I've been looking all over for the way to do this but cannot find it. I've done it before but forgot.

I have an old windows/postgres install on drive B. I have a new windows/postgres install on A. I want to move the data from B to A without using the backup/restore method (the backup is old). I thought I could do this by just copying the Data folder but it doesn't seem to work. Do I need to keep some files intact like the config ones?

Thanks.

Re: Transferring previous Postgres data to new install?

PostPosted: Sat May 24, 2008 6:59 pm
by APerfect10
The only way to move databases between different major versions of PostgreSQL is to use pg_dump and pg_restore.

Best regards,

Derek

Re: Transferring previous Postgres data to new install?

PostPosted: Sat May 24, 2008 8:12 pm
by PascalT
what if it's the same version of Postgres, is it possible?

thanks