[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