How to upgrade a postgresql database?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: General Discussion about Arch Linux <arch-general@xxxxxxxxxxxxx>
- Subject: How to upgrade a postgresql database?
- From: Peter Nabbefeld <peter.nabbefeld@xxxxxx>
- Date: Fri, 17 Aug 2018 15:57:18 +0200
- Reply-to: General Discussion about Arch Linux <arch-general@xxxxxxxxxxxxx>
- User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.0
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]