Re: [postgis-users] Upgrading PostGIS

2020-12-21 Thread Clifford Snow
Thanks for all the suggestions. I decided to take the safe route by running pg_dumpall then turning on Postgresql 13 with Postgis 3.1. Once the data was loaded the system was working perfectly. I didn't mention this in my original email but one of my databases has nealy 100M records. I didn't wan

Re: [postgis-users] Upgrading PostGIS

2020-12-17 Thread Tomas Straupis
2020-12-17, kt, 22:46 Clifford Snow rašė: > I want to upgrade Postgresql from 11 to 13 and PostGIS from 2.5 to 3.1 on a > Fedora Workstation. Is it possible? If I understand you correctly, you're using both postgresql and postgis packages from fedora repos? If so, these are my notes, I use Fe

Re: [postgis-users] Upgrading PostGIS

2020-12-17 Thread Regina Obe
since the -3 is downward compatible with 2.5 From: Regina Obe [mailto:l...@pcorp.us] Sent: Thursday, December 17, 2020 5:06 PM To: 'PostGIS Users Discussion' Subject: RE: [postgis-users] Upgrading PostGIS Clifford, I think this may be referenced in Darafei’s notes but couldn’

Re: [postgis-users] Upgrading PostGIS

2020-12-17 Thread Regina Obe
-users-boun...@lists.osgeo.org] On Behalf Of Darafei "Kom?pa" Praliaskouski Sent: Thursday, December 17, 2020 4:18 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Upgrading PostGIS Hi, Here is a gist I use to put notes of all my upgrades: https://gist.github.

Re: [postgis-users] Upgrading PostGIS

2020-12-17 Thread Komяpa
Hi, Here is a gist I use to put notes of all my upgrades: https://gist.github.com/Komzpa/994d5aaf340067ccec0e чц, 17 сне 2020, 23:46 карыстальнік Clifford Snow напісаў: > I want to upgrade Postgresql from 11 to 13 and PostGIS from 2.5 to 3.1 on > a Fedora Workstation. Is it possible? > > I thou

[postgis-users] Upgrading PostGIS

2020-12-17 Thread Clifford Snow
I want to upgrade Postgresql from 11 to 13 and PostGIS from 2.5 to 3.1 on a Fedora Workstation. Is it possible? I thought that I could upgrade postgresql from 11 to 13 then just add postgis, but pg_upgrade apparently wants postgis 2.5. 2.5 isn't available for postgresql 13. Another thought was to

Re: [postgis-users] Upgrading PostGIS

2013-07-08 Thread Sandro Santilli
On Mon, Jul 08, 2013 at 02:27:55PM +0100, James David Smith wrote: > Hi all, > > Could someone point me towards some instructions for upgrading my > PostGIS version please? I interact with it using PSQL. My current > versions are below: > > PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled

[postgis-users] Upgrading PostGIS

2013-07-08 Thread James David Smith
Hi all, Could someone point me towards some instructions for upgrading my PostGIS version please? I interact with it using PSQL. My current versions are below: PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit POSTGIS="1.5.5SVN" GE

[postgis-users] Upgrading postGIS database from Postgresql 9.1.4 to 9.2

2012-11-14 Thread Jan Hartmann
I've just installed from source the new PostgreSQL 9.2 distribution without a database. The old 9.1.4 version is running under a different port and uses PostGIS version 2.1.0SVN. I can't access that database with the 9.2 PostgreSQL binaries. There is a simple upgrade method (pg_upgrade), that c