Advice on copying postgres database to new server

[empusa]

I've recently moved all of my sites to a new hosting company. The last hosting company has security problems and my sites got hacked (not an Elxis problem, just a bad hosting company)

I backed up all of my postgres databases using phppgadmin

The new hosting company requires different database names and user names.

Could anyone give be some advice on the best way to copy the postgres databases as the sites on the new server are not running quite as they used to. My previous hosting company used postgres 7, the new one uses postgres 8. This may be causing the issues, but I'm not sure.

I found the most reliable way was to save the databases as COPY not SQL, this caused less errors. However, all of the sites now have small problems so the databases are not copying over exactly. One site in particular that is still using Elxis 2006 is particularly bad. I can no longer view most of the pages.

The encoding may also be the problem. The last hosting company used SQL ASCII, the new one uses UTF8

[datahell]

The normal way is to export and import SQL file via phppgadmin. Before importing you should replace the database name with the new one and create the database if it does not exist.

[empusa]

That's what I did.

Most of the Elxis 2008 sites were nearly OK. They just don't want to add any new components.

I have one site that still uses Elxis 2006. This site is really causing problems. All of the content pages are telling me that I am not authorised to view the page and there's an error if I view the content pages in admin. It doesn't matter how I export and import, I still get the errors.