Python Forum
Python Forum

best way to transfer databases from old version of PostgreSQL to new version
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
best way to transfer databases from old version of PostgreSQL to new version
Larz60+
aetate et sapientia
Super Moderators
Posts: 12,050
Threads: 487
Joined: Sep 2016
Reputation: 452
#1
Jun-12-2018, 09:11 PM
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?
Find
Reply
Skaperen
Weighs the Same as a Duck
Posts: 4,655
Threads: 1,498
Joined: Sep 2016
Reputation: 15
#2
Jun-19-2018, 06:22 AM
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?
Tradition is peer pressure from dead people

What do you call someone who speaks three languages? Trilingual. Two languages? Bilingual. One language? American.
Find
Reply
Larz60+
aetate et sapientia
Super Moderators
Posts: 12,050
Threads: 487
Joined: Sep 2016
Reputation: 452
#3
Jun-19-2018, 09:53 AM (This post was last modified: Jun-19-2018, 09:53 AM by Larz60+.)
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.
Find
Reply
Skaperen
Weighs the Same as a Duck
Posts: 4,655
Threads: 1,498
Joined: Sep 2016
Reputation: 15
#4
Jun-20-2018, 07:13 AM (This post was last modified: Jun-20-2018, 07:13 AM by Skaperen.)
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.
Tradition is peer pressure from dead people

What do you call someone who speaks three languages? Trilingual. Two languages? Bilingual. One language? American.
Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Master thesis research: A Python version update behavior survey AJB96 2 2,283 Sep-07-2023, 08:39 PM
Last Post: Larz60+
  Industrial Databases like IAC Database? nEmaTA 0 1,756 Sep-04-2021, 08:13 AM
Last Post: nEmaTA
  Russian version of Python Skaperen 3 7,749 Jun-20-2019, 05:41 PM
Last Post: Skaperen
  downloading source for every version Skaperen 11 7,456 Jun-07-2019, 11:45 PM
Last Post: Skaperen
  NeneBot Alfa version francisco_neves2020 5 4,282 Apr-22-2019, 06:12 PM
Last Post: francisco_neves2020
  dil_bert Version-Control with Atom: how to set & configure the interaction apollo 0 3,128 Dec-03-2018, 10:05 PM
Last Post: apollo
  How to update pyenv pip version so that new virtualenv will use it Larz60+ 4 10,016 Aug-19-2018, 08:39 PM
Last Post: Larz60+
  Python version 2 Skaperen 0 2,650 Aug-15-2018, 11:36 PM
Last Post: Skaperen

Forum Jump:

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020