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: 11,870
Threads: 474
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,558
Threads: 1,463
Joined: Sep 2016
Reputation: 14
#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: 11,870
Threads: 474
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,558
Threads: 1,463
Joined: Sep 2016
Reputation: 14
#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 1,488 Sep-07-2023, 08:39 PM
Last Post: Larz60+
  Industrial Databases like IAC Database? nEmaTA 0 1,360 Sep-04-2021, 08:13 AM
Last Post: nEmaTA
  Russian version of Python Skaperen 3 4,842 Jun-20-2019, 05:41 PM
Last Post: Skaperen
  downloading source for every version Skaperen 11 5,274 Jun-07-2019, 11:45 PM
Last Post: Skaperen
  NeneBot Alfa version francisco_neves2020 5 3,144 Apr-22-2019, 06:12 PM
Last Post: francisco_neves2020
  dil_bert Version-Control with Atom: how to set & configure the interaction apollo 0 2,579 Dec-03-2018, 10:05 PM
Last Post: apollo
  How to update pyenv pip version so that new virtualenv will use it Larz60+ 4 8,178 Aug-19-2018, 08:39 PM
Last Post: Larz60+
  Python version 2 Skaperen 0 2,025 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