[postgis-users] Input on upgrade to GIS database

Sears, Jeremy Jeremy.Sears at CCRS.NRCan.gc.ca
Fri Nov 18 06:41:00 PST 2005


Strk,
SELECT postgis_full_version()  gives me :
PostGIS 1.0.4, GEOS 2.1.4 Proj rel. 4.4.9 29 Oct 2004 Use Stats
DBProc="0.3.0" Relproc= 0.3.0.

I suspect the errors were due to the fact that the db that the dump came
from had written geometry functions in along with the data, when I loaded
the data into a new db that already had these functions, PostgreSQL put up
some fuss. 

This is my working theory. As far as I can see all of my data are in the new
db. I can access it with out problem.

I'm very open to any suggestions you or anyone else may have regarding
methods by wich I can verify that my data are indeed in their proper order.
Im quite new to PostgreSQL and db's in general.

Best Regards
Jeremy


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of
strk at refractions.net
Sent: November 17, 2005 5:56 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Input on upgrade to GIS database


On Thu, Nov 17, 2005 at 11:37:58AM -0500, Sears, Jeremy wrote:
> Onyx,
>  
> I have recently preformed a simmilar task. In the name of experimentation
I
> had tried a coupla methods to move data from an older PostgreSQL(8.0.2) +
> PostGIS install to a new one (postgresql 8.1 and postgis 1.0.4). The older
> database dumped data into a sql loader file. This was then loaded into the
> new database via 'psql -f datafile.sql'. This method seems to have worked
> although I did notice a couple of errors fly by as the data loaded. . .
Note
> that the new database is still in the testing phase and errors could exist
> that I havent noticed yet.. however so far so good.

Ehmm... I'm afraid those errors were important.
What does SELECT postgis_full_version() tell you ?
--strk;

>  
> Jeremy
>  
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Onyx
> Sent: November 17, 2005 11:01 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Input on upgrade to GIS database
> 
> 
> 
> PostGIS Friends, 
> I need some help/input on the proper approach to upgrading on GIS-driven
> database backend, and I am hoping that some of you have been in similar
> situations.  We run a PostgreSQL database with Proj, Geos, and (of course)
> PostGIS libraries.  I want to upgrade the following:
> 
> - PostgreSQL 7.4.6      --> 8.1.0 
> - Geos 2.1.0            --> 2.1.4 
> - PostGIS 0.9.0         --> 1.0.4 
> 
> What is the proper approach to get this done successfully, keeping our
> existing data intact?  I know that it is not as simple as 1) dumping the
> schema & data from the database to a file, 2) moving/deleting PostgreSQL
> 7.4.6 (and old libraries), 3) installing PostgreSQL 8.1.0 (and the new
> libraries), and 4) feeding the schema & data back in, although I wish it
> were that easy.  I have read the section of the PostGIS manual on
upgrading,
> but I am worried that there are some other aspects I need to know since I
> have other variables I am upgrading as well (PostgreSQL & Geos).  Has
anyone
> been in my boat before?
> 
> Any help would be greatly appreciated.  Thanks! 
> 
> 
> - Onyx 
> --- 
> Onyx Mueller 
> Software Engineer 
> i-cubed : information integration & imaging LLC 
> 201 Linden Street : Third Floor 
> Fort Collins, CO  80524 
> 970-482-4400 voice 
> 970-482-4499 fax 
>  <http://www.i3.com> http://www.i3.com 
>   
> 

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for open standards
  X     No HTML/RTF in email
 / \    No M$ Word docs in email

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list