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?