I have an existing PMP install on a 32-bit version of Linux using postgresql as the backend.
I've now re-installed the 64-bit version of PMP on a 64-bit Linux server and would like to migrate the database over. So far, I've had no success.
I was able to save an offline backup of the existing database and copy this file over to the new server. However, every time I try to do a restoreDB, I get errors relating to problems with connecting to the new database.
I've tried running the restoreDB with postgres running vs. not-running... nothing seems to work. Can anyone point me to accurate instructions for transferring a postgresql PMP database between installations like this?
thanks!