[postgis-users] Ready for 1.0.0 ? AMD64/Linux 2.6.10/pg8.0.1

[James Marca]

At approximately Wed, Mar 02, 2005 at 10:32:36AM -0800, James Marca wrote:
> At approximately Wed, Mar 02, 2005 at 05:24:48PM +0100, Markus Schaber wrote:
> > Hi, Strk,
> > 
> > strk at refractions.net schrieb:
> > > Hello users. We're trying to get 1.0.0 out.
> > 
> > The reports of crashes on AMD64 were against RC2, so let's hope that
> > they're fixed.
Hi,
I've (re)compiled and (re)installed 

PostgreSQL 8.0.1
PostGIS from CVS (checked out yesterday morning about 10AM PST)

Everything compiled and installed cleanly, with the single exception
noted below.  I haven't yet hit a runtime crash.  I also haven't had
to redo any of my Class::DBI::... scripts, which is cool.  I was
afraid I'd have to rewrite lots of things in my SQL calls.  I haven't
yet tried out my java programs.

I used the update perl script in utils and it worked (upgrading from
0.9.1, pg8.0.0rc1)

One problem on the install process:

The sql in lwpostgis.sql looks for the libraries in:

/usr/lib64/liblwgeom.so.1.0

but they were installed to: 

/usr/lib64/postgresql/liblwgeom.so*

my make and install lines in my packaging script (Slackware style) are
(one long line)

CFLAGS="-O2" LDFLAGS="-L/lib64 -L/usr/lib64" PROJ_DIR="/usr" GEOS_DIR="/usr" LPATH="/usr/lib64" PGSQL_SRC="/mnt/lfs/tmp/postgresql-$POSTGRESQLVERSION" make 

if [ $? -gt 0 ]; then
   echo "ERROR: failed"
   exit 1
fi

CFLAGS="-O2" LDFLAGS="-L/lib64 -L/usr/lib64" PROJ_DIR="/usr" GEOS_DIR="/usr" LPATH="/usr/lib64" PGSQL_SRC="/mnt/lfs/tmp/postgresql-$POSTGRESQLVERSION" make install DESTDIR=$PKG

It is easy enough to add a symlink to my packaging script in the next
step, but it seems strange that 'make install' would put the library in
one place, while lwpostgis.sql looks for them somewhere else.  I don't
know where the make install is picking up
/usr/lib64/postgresql ... perhaps from the PostgreSQL source?

for what its worth, my flags for installing postgresql are: 

SLKCFLAGS="-O2 -march=athlon64 -mtune=athlon64 -fPIC"
SLKLDFLAGS="-lstdc++ -L/lib64 -L/usr/lib64"
SLKLIBDIR="/usr/lib64"

CFLAGS="$SLKCFLAGS" \
LDFLAGS="$SLKLDFLAGS" \
./configure \
    --prefix=/usr \
    --libdir=$SLKLIBDIR \
    --sysconfdir=/etc --with-perl \
    --with-tcl \
    --with-java \
    --with-openssl \
    --with-tclconfig=/usr/lib64 \
    --with-tkconfig=/usr/lib64 \
    --host=x86_64-slackware-linux-gnu

make
if [ $? -gt 0 ]; then
   echo "ERROR: failed"
   exit 1
fi
make install DESTDIR=$PKG

I will keep testing and note any problems.