[postgis-users] Building 0.6.2 with pg 7.1.3

[Paul Ramsey]

Very good evening. I am configuring our new 'superserver' a dual athlon
w/ 2G ram and 500G storage for postgresql/postgis database applications.
Crank up those shared segments!

To guarantee a clean install, go to the root of your pgsql install
directory and rm -rf. Blow it all away. The do 'make install' in your
7.1 directory, and in your postgis directory. Harsh, but guaranteed.

Tyler Mitchell wrote:
> 
> Good evening eh.  If I were a betting man - I'd say you're right about the
> versioning problems.
> I had originally tried (like the only other guy in the mailing list had
> tried) to run PG 7.2, but then backed off (and started to read instructions
> :)
> Now it appears that we both got the same error after trying that.
> At least there is something consistent happening here, so I would assume
> that anyone who tried out 7.2 and then realized that wasn't gonna work, will
> have the same problem.  Is there something that you can put your finger on
> there?
> 
> Do you think it's a matter of cleaning out all my postgresql installs and
> starting fresh.  How would I do that?
> 
> Tyler
> 
> > -----Original Message-----
> > From: postgis-users-admin at postgis.refractions.net
> > [mailto:postgis-users-admin at postgis.refractions.net]On Behalf Of Paul
> > Ramsey
> > Sent: Thursday, April 04, 2002 10:04 PM
> > To: postgis-users at postgis.refractions.net
> > Subject: Re: [postgis-users] Building 0.6.2 with pg 7.1.3
> >
> >
> > Tyler Mitchell wrote:
> > >
> > > Howdy, I haven't seen too much on this in the mailing list
> > except an oldy
> > > from last year.  Since I'm 'dabbling' in postgresql I'm
> > wondering if I'm not
> > > catching something simple here.
> > > I've installed pg 7.1.3 from source code, grabbed CVS
> > version of postgis and
> > > everything ran fine until...I ran the postgis.sql file.
> >
> > Not really... maybe Dave has some idea. I just installed the
> > CVS version
> > against 7.1.3 and had no problems. Perhaps you have some mixed
> > versioning problems going on? Various installs in various places?
> >
> > > Here's my "log".  Any ideas wuzup?
> > >
> > > tyler
> > > --------------------------------
> > > [tyler at spatialguru postgis]$ createdb testgis3
> > > CREATE DATABASE
> > > [tyler at spatialguru postgis]$ createlang plpgsql testgis3
> > > [tyler at spatialguru postgis]$ psql -f postgis.sql -d testgis3
> > > BEGIN
> > >        message
> > > ----------------------
> > >  plpgsql is installed
> > > (1 row)
> > >
> > > CREATE
> > > psql:postgis.sql:29: NOTICE:  CREATE TABLE / PRIMARY KEY
> > will create implicit
> > > index 'spatial_ref_sys_pkey' for table 'spatial_ref_sys'
> > > CREATE
> > > psql:postgis.sql:42: NOTICE:  CREATE TABLE / PRIMARY KEY
> > will create implicit
> > > index 'gc_pk' for table 'geometry_columns'CREATE
> > > CREATE
> > > ......<a few more NOTICES>....
> > > CREATE
> > > CREATE
> > > CREATE
> > > CREATE
> > > psql:postgis.sql:799: ERROR:  OperatorDef: function
> > 'postgis_gist_sel(opaque,
> > > oid, opaque, int4)' does not exist
> > > psql:postgis.sql:805: NOTICE:  current transaction is
> > aborted, queries
> > > ignored until end of transaction block
> > > *ABORT STATE*
> > > psql:postgis.sql:811: NOTICE:  current transaction is
> > aborted, queries
> > > ignored until end of transaction block
> > >
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users