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.

asked Apr 10, 2018 at 9:28
5
  • Postgres recommends two methods to upgrade. Via pg_dump or using pg_upgrade Commented 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! Commented Apr 10, 2018 at 9:45
  • Haven't took any backup of your db? Commented Apr 10, 2018 at 9:47
  • no I don't @McNets, I makes a wrong action I know! Commented Apr 10, 2018 at 9:48
  • @McNets I arrived to a solution, check my answer ;) Commented Apr 10, 2018 at 10:10

1 Answer 1

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.

answered Apr 10, 2018 at 10:09

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.