+- Python Forum (https://python-forum.io)
+-- Forum: Forum & Off Topic (https://python-forum.io/forum-23.html)
+--- Forum: Bar (https://python-forum.io/forum-27.html)
+--- Thread: best way to transfer databases from old version of PostgreSQL to new version (/thread-10904.html)
best way to transfer databases from old version of PostgreSQL to new version - Larz60+ - Jun-12-2018
I haven't done this in a while, but just upgraded my PostgreSQL and now have to move all database stuff from the old version to the new.
I can't even remember the command string for dumping a database using psql or PgAdmin.
Anyone got a handle on this?
RE: best way to transfer databases from old version of PostgreSQL to new version - Skaperen - Jun-19-2018
which OS are you running under? if Linux which distro? if Ubuntu, did you install package "postgresql-doc" yet? which old version of postgresql are you data files for?
RE: best way to transfer databases from old version of PostgreSQL to new version - Larz60+ - Jun-19-2018
OS for this instance, PostgreSQL version 9.~ to 10. windows 7 pro, I got it done using backup option, Seems that I had a migration tool last time, but that was a long time ago.
RE: best way to transfer databases from old version of PostgreSQL to new version - Skaperen - Jun-20-2018
i recall a migration tool back around version 4 to version 5, but i haven't used it since.
all my uses have been on Linux, Slackware then Ubuntu.