Move PostgreSQL databases to new Ubuntu machine

Unfortunately an Ubuntu machine I manage has stopped working, and after much work it seems like I’ll have to reinstall the system. All the data from the old system is intact and backed up.

Among this data is a PostgreSQL installation with some databases (that was running isolated on this machine.) My goal is to move this data as is, and run it on the fresh install.

Since the old system is not running, I can’t do a pg_dump.

According to this article it should be possible to mode the data folder, but there are two restrictions mentioned. What I do not fully understand is if this will be a problem for me?

I cant seem to find much information on this online, since all refer to the preferred pg_dump-method.

Any help would be highly appreciated.

Source: ubuntu

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.