How to restore database from files?

Question

PostgreSQL

Old PostgreSQL 9.1
database Only the files in the C:\Program Files\PostgreSQL\9.1\data
directory are left from the database. Is it possible to restore several tables from this database?
I installed a new version of PostgreSQL 11.2 and tried to restore using pg_upgrade.exe , but since I don't have strictly server executables left, I get the error:

existence check for "C:\Program Files\PostgreSQL\9.1\bin/postgres.exe" failed: No such file or directory

Answer 1

If the directory C:\Program Files\PostgreSQL\9.1\data (hereinafter I will call it $PGDATA) contains the base, global, pg_xlog directories and everything else, mostly with the pg_* prefix, then there is hope. If there are a lot of strange files in pg_xlog, and pg_tblspc is empty or the links from it are live. Make a backup of $PGDATA and the contents of pg_tblspc (if there were links).
Then install server version 9.1.24. Set data_directory to look into your $PGDATA. Try to start the DBMS and see what happens in the database log.
pg_upgrade requires clusters that are known to be running and gracefully stopped, both the old version and the new one. Refuses to work even if the base was turned off in an emergency.