Possible to xfer PT postgre SQL databases from PC to PC?

RevAgain · #1 11-09-2006, 02:45 PM

Is it feasible to transfer databases across PCs? Basically I want to be able to synchronise laptop and desktop but the dbs are going to be too slow if I use Access.

TIA

jwp · #2 11-09-2006, 03:11 PM

Do a backup of your Postgre DB on one computer, copy that file to the other, and then restore that file on the other.

JWP

CASSHERN · #3 11-09-2006, 05:37 PM

aren't the database files in the data directory ?! owouldn't copying that directory over work ?

RevAgain · #4 11-10-2006, 01:57 PM

Mmmm, I have a feeling I tried this and had a problem because the name of the database file I was trying to restore was the same as a different database file on the PC I was transferring to, which I wanted to keep and it would overwrite - I guess that's the way to do it just remember to not use the default database names when creating databases.

Cheers