I was using PostgreSQL 9.3, then I installed PostgreSQL 9.5, then I unistalled PostgreSQL 9.3.
Now I want to move the database from the folder of PostgreSQL/9.3/data/base
of PostgresSQL 9.3 to PostgreSQL/9.5/data/base
of PostgresSQL 9.5.
When I open PostgreSQL 9.5 from pg_admin I can't find the database.
I know copy past is not the correct way, so what is the correct way to move this databases from pg_9.3 folder to pg_9.5 so I can use them like any database.
When I unistall the PostgreSQL 9.3 I still find this folders bin, data, lib, data - Copie.rar.
I am using Windows as an OS.
-
Postgres recommends two methods to upgrade. Via pg_dump or using pg_upgradeMcNets– McNets2018年04月10日 09:39:41 +00:00Commented Apr 10, 2018 at 9:39
-
@McNets Thank you, this is correct, but it's over, I already uninstall PostgreSQL, So should this way work now!Youcef LAIDANI– Youcef LAIDANI2018年04月10日 09:45:50 +00:00Commented Apr 10, 2018 at 9:45
-
Haven't took any backup of your db?McNets– McNets2018年04月10日 09:47:08 +00:00Commented Apr 10, 2018 at 9:47
-
no I don't @McNets, I makes a wrong action I know!Youcef LAIDANI– Youcef LAIDANI2018年04月10日 09:48:42 +00:00Commented Apr 10, 2018 at 9:48
-
@McNets I arrived to a solution, check my answer ;)Youcef LAIDANI– Youcef LAIDANI2018年04月10日 10:10:04 +00:00Commented Apr 10, 2018 at 10:10
1 Answer 1
Nice news, finally, I arrived to a Solution.
Just Install PostgreSQL 9.3 in the same folder, now I open pg_admin and all the databases are back.
Now I should to make a backup before I uninstall PostgreSQL again.
If someone have another idea, I can be happy to use it.
Explore related questions
See similar questions with these tags.