How to upgrade a postgresql database?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]




Hello,

I'm trying to upgrade a postgresql database, but it doesn't work. I've also found this: https://wiki.archlinux.org/index.php/PostgreSQL#Upgrading_PostgreSQL

This doesn't work for me, because there isn't any folder /opt/pgsql-9.6/bin anymore - all the binaries are in /usr/bin. This implies, there're no two versions of the binaries available, nor any oldir or newdir (for -b / -B parameters).

It seems, I have to downgrade postgresql first, dump the database, and restore it after upgrading again. Is there any easier method available (i.e. some script which could do this automatically)?

Kind regards

Peter



[Index of Archives]     [Linux Wireless]     [Linux Kernel]     [ATH6KL]     [Linux Bluetooth]     [Linux Netdev]     [Kernel Newbies]     [Share Photos]     [IDE]     [Security]     [Git]     [Netfilter]     [Bugtraq]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Linux ATA RAID]     [Samba]     [Device Mapper]

  Powered by Linux