Updating suse 9 0 to 9 2
(I didn't want to have to dump and restore data manually, so several of the other answers here were not viable.) In short, the process consists of installing the new version of Postgre SQL alongside the old version (e.g., 9.5 and 9.6), and then running the When you run pg_upgrade, you must provide the following information: the data directory for the old cluster (-d DATADIR) the data directory for the new cluster (-D DATADIR) the "bin" directory for the old version (-b BINDIR) the "bin" directory for the new version (-B BINDIR) -b, --old-bindir=BINDIR old cluster executable directory -B, --new-bindir=BINDIR new cluster executable directory -d, --old-datadir=DATADIR old cluster data directory -D, --new-datadir=DATADIR new cluster data directory connection to database failed: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/lib/postgresql/.s. /usr/lib/postgresql/9.6/bin/pg_upgrade --old-bindir=/usr/lib/postgresql/9.5/bin --new-bindir=/usr/lib/postgresql/9.6/bin --old-datadir=/var/lib/postgresql/9.5/main --new-datadir=/var/lib/postgresql/9.6/main --old-options=-cconfig_file=/etc/postgresql/9.5/main/--new-options=-cconfig_file=/etc/postgresql/9.6/main/Upgrade Complete ---------------- Optimizer statistics are not transferred by pg_upgrade so, once you start the new server, consider running: ./analyze_new_Running this script will delete the old cluster's data files: ./delete_old_Standing on the shoulders of the other poor creatures trodding through this muck, I was able to follow these steps to get back up and running after an upgrade to Yosemite: Assuming you've used home-brew to install and upgrade Postgres, you can perform the following steps.
My solution was to do a combination of these two resources: https://gist.github.com/tamoyal/2ea1fcdf99c819b4e07d and The second one helped more then the first one.
Also, the link: https://help.ubuntu.com/stable/serverguide/Helped to set the encrypted password and set md5 for authenticating the postgres user.
unfortunately, due to admin reasons, our support expired, and so we are looking at manually upgdating Open SSL and its required libraries manually.
Don't delete the old data directory, just keep it in case something goes wrong / you make a mistake; that way you can just go back to your unchanged 9.3 install. If you're stuck, post a detailed question explaining how you're stuck, where, and what you tried first.
It depends a bit on how you installed Postgre SQL too, as there are several different "distributions" of Postgre SQL for OS X (unfortunately). I just upgraded Postgre SQL 9.5 to 9.6 on Ubuntu and thought I'd share my findings, as there are a couple of OS/package-specific nuances of which to be aware.
I'm afraid I will destroy the data in the database or mess it up.
wget -q -O - https:// sudo apt-key add - sudo apt-get update sudo apt-get install postgresql-9.4 sudo pg_dropcluster --stop 9.4 main sudo /etc/init.d/postgresql start If in doubt, do it with dumps.