I have a postgres server with 2 databases residing on a host which is being de-commissioned. I need to move the postgres server itself, including the databases to a new host. All the stuff I can find on the web talks about moving the database, but I need to move the entire server. Am I missing something here? Am I suppose to create an identical server on the new host (with the same server name), then backup/restore the databases individually? Is there not any way to move the entire server? |