0

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.

Folders

I am using Windows as an OS.

  • Postgres recommends two methods to upgrade. Via pg_dump or using pg_upgrade – McNets Apr 10 '18 at 9:39
  • @McNets Thank you, this is correct, but it's over, I already uninstall PostgreSQL, So should this way work now! – YCF_L Apr 10 '18 at 9:45
  • Haven't took any backup of your db? – McNets Apr 10 '18 at 9:47
  • no I don't @McNets, I makes a wrong action I know! – YCF_L Apr 10 '18 at 9:48
  • @McNets I arrived to a solution, check my answer ;) – YCF_L Apr 10 '18 at 10:10
0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.