[postgis-users] RE [Polluriel potentiel] Re: Postgis installation on sles 11 sp1
Steve.Toutant at inspq.qc.ca
Steve.Toutant at inspq.qc.ca
Fri Jan 6 11:31:04 PST 2012
I was looking for tablefunc.sql as specified here
http://www.postgresonline.com/journal/archives/14-CrossTab-Queries-in-PostgreSQL-using-tablefunc-contrib.html
tablefunc.sql doesn't exist But tablefunc.so does and is available from
the package so I can create the sql that creates crosstab function.
Having tablefunc.sql would be nice though
thanks
steve
Steve.Toutant at inspq.qc.ca@postgis.refractions.net
Envoyé par : postgis-users-bounces at postgis.refractions.net
2012-01-06 13:37
Veuillez répondre à
PostGIS Users Discussion <postgis-users at postgis.refractions.net>
A
PostGIS Users Discussion <postgis-users at postgis.refractions.net>
cc
postgis-users at postgis.refractions.net,
postgis-users-bounces at postgis.refractions.net
Objet
[Polluriel potentiel] Re: [postgis-users] Postgis installation on sles 11
sp1
Hi Otto,
With postgres 8.3 I was using some functions available from the tablefunc
module
http://www.postgresql.org/docs/current/static/tablefunc.html
My understanding is that this module should be available in the
postgresql-contrib package, and it is not.
Is it possible to rebuild the package or I should build this module from
the source?
thanks
steve
Otto Dassau <dassau at gbd-consult.de>@postgis.refractions.net
Envoyé par : postgis-users-bounces at postgis.refractions.net
2012-01-05 11:08
Veuillez répondre à
PostGIS Users Discussion <postgis-users at postgis.refractions.net>
A
postgis-users at postgis.refractions.net
cc
Objet
Re: [postgis-users] Postgis installation on sles 11 sp1
Hi Steve,
I added further necessary packages to Application:Geo:Postgres9PostGIS1:
libgeos, postgresql-libs and proj. This should fix all dependency
problems. Please test again and note that the repo provides packages for
SLE_11 and for SLE_11_SP1.
Regards
Otto
Am Wed, 4 Jan 2012 15:05:08 -0500
schrieb Steve.Toutant at inspq.qc.ca:
> Hi Otto,
> yes postgresql-libs-8.3.9 is part of the distribution, I saw that after
I
> wrote
>
> I tried to install postgresql-server using your repository, see message
> below
>
> zypper in -r Postgres9PostGIS1_sle11 -C postgresql-server.x86_64
> Loading repository data...
> Reading installed packages...
> Resolving package dependencies...
>
> Problem: nothing provides libpq.so.5()(64bit) needed by
> postgresql-server-9.1.2-64.1.x86_64
> Solution 1: do not ask to install a solvable providing
> postgresql-server.x86_64
> Solution 2: break postgresql-server by ignoring some of its
dependencies
>
> I just begin with linux, don't know wich solution is best...
> Good night!
> Steve
> Steve Toutant, M. Sc.
> Analyste en géomatique
> Secteur environnement
> Direction de la santé environnementale et de la toxicologie
> Institut national de santé publique du Québec
> Tél.: 418 646-6777 poste 30015
> Téléc.: 418 644-4593
> steve.toutant at inspq.qc.ca
> http://www.inspq.qc.ca
> http://www.monclimatmasante.qc.ca
> Pour me rejoindre par courrier
> Service de l'infrastructure et du réseau
> Direction des technologies de l'information
> Ministère de la Sécurité Publique
> 2525 boul. Laurier, 2è étage
> Tour Laurentides
> Québec, G1V 2L2
>
>
>
> Otto Dassau <dassau at gbd-consult.de>@postgis.refractions.net
> Envoyé par : postgis-users-bounces at postgis.refractions.net
> 2012-01-04 14:43
> Veuillez répondre à
> PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>
>
> A
> postgis-users at postgis.refractions.net
> cc
>
> Objet
> Re: [postgis-users] Postgis installation on sles 11 sp1
>
>
>
>
>
>
>
>
> Hi Steve,
>
> just another note for now. The Application:Geo:Postgres9PostGIS1 repo
does
> not contain postgresql-libs-8.3.9, see:
>
>
http://download.opensuse.org/repositories/Application:/Geo:/Postgres9PostGIS1/
>
>
> It is probably part of SLE_11. I guess, you don't need to install that
> package. All libs are included in the postgresql-server package, I
guess.
>
> Regards
> Otto
>
> Am Wed, 4 Jan 2012 20:15:07 +0100
> schrieb Otto Dassau <dassau at gbd-consult.de>:
>
> > Hi,
> >
> > I have to look at it tomorrow. There is also a problem with postgis
> > packaging I have to fix. I write again, when it is working.
> >
> > Regards
> > Otto
> >
> > Am Wed, 4 Jan 2012 14:01:44 -0500
> > schrieb Steve.Toutant at inspq.qc.ca:
> >
> > > Thanks Otto,
> > > I saw that these packages are now available in sles11_sp1.
quick...!!
> > >
> > > But the repo contains package postgresql-libs-8.3.9-0.1.1.x86_64
> > > Should it be 9.1.2-64.1 as per postgresql-server?
> > >
> > > many thanks again
> > > Steve
> > >
> > > Steve Toutant, M. Sc.
> > > Analyste en géomatique
> > > Secteur environnement
> > > Direction de la santé environnementale et de la toxicologie
> > > Institut national de santé publique du Québec
> > > Tél.: 418 646-6777 poste 30015
> > > Téléc.: 418 644-4593
> > > steve.toutant at inspq.qc.ca
> > > http://www.inspq.qc.ca
> > > http://www.monclimatmasante.qc.ca
> > > Pour me rejoindre par courrier
> > > Service de l'infrastructure et du réseau
> > > Direction des technologies de l'information
> > > Ministère de la Sécurité Publique
> > > 2525 boul. Laurier, 2è étage
> > > Tour Laurentides
> > > Québec, G1V 2L2
> > >
> > >
> > >
> > > Otto Dassau <dassau at gbd-consult.de>@postgis.refractions.net
> > > Envoyé par : postgis-users-bounces at postgis.refractions.net
> > > 2012-01-04 13:09
> > > Veuillez répondre à
> > > PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> > >
> > > A
> > > postgis-users at postgis.refractions.net
> > > cc
> > >
> > > Objet
> > > Re: [postgis-users] Postgis installation on sles 11 sp1
> > >
> > >
> > > Hi Steve,
> > >
> > > ok, then the Application:Geo packages won't work for you, because
they
> > > don't provide postgresql 9 for SLE_11.
> > >
> > > I updated the Application:Geo:Postgres9PostGIS1 repository. It now
> > > provides
> > > postgres 9.1.2 and postgres 1.5.3, also for SLE_11. Please try, if
> that
> > > works for you. The packages will be available soon, also for
> SLE_11_SP1,
> > > I guess.
> > >
> > >
>
http://download.opensuse.org/repositories/Application:/Geo:/Postgres9PostGIS1/
>
> > >
> > >
> > > Regards
> > > Otto
> > >
> > > Am Wed, 4 Jan 2012 11:05:59 -0500
> > > schrieb Steve.Toutant at inspq.qc.ca:
> > >
> > > > Hi Otto,
> > > > I need postgis to work with at least postgres v9.0
> > > > regards,
> > > > Steve
> > > >
> > > > Otto Dassau <dassau at gbd-consult.de>@postgis.refractions.net
> > > > Envoyé par : postgis-users-bounces at postgis.refractions.net
> > > > 2012-01-04 09:49
> > > > Veuillez répondre à
> > > > PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> > > >
> > > >
> > > > A
> > > > postgis-users at postgis.refractions.net
> > > > cc
> > > >
> > > > Objet
> > > > Re: [postgis-users] Postgis installation on sles 11 sp1
> > > >
> > > > Hi Steve,
> > > >
> > > > I recently (3 weeks ago) updated the postgis package for SLES 11
on
> > > > Application:Geo to version 1.5.3. They built without any problems
on
>
> > > SLES
> > > > 11 and I think (didn't test), that they also work with the
standard
> > > > postgresql packages provided with SLES 11, but that's not version
> > > > 9.1.2.
> > > >
> > > > Have you tried to use the standard postgres from SLES 11? I think
it
> is
> > > > 8.1.x?
> > > >
> > > > Regards
> > > > Otto
> > > >
> > > > Am Wed, 4 Jan 2012 09:33:29 -0500
> > > > schrieb Steve.Toutant at inspq.qc.ca:
> > > >
> > > > > Hi,
> > > > > I still can't make postgis work on sles 11 sp1
> > > > > I successfully installed postgres 9.1.2-64.1 from this
repository
> > > > >
> > > >
> > >
>
http://download.opensuse.org/repositories/server:/database:/postgresql/SLE_11_SP1
>
> > >
> > > >
> > > > >
> > > > > Then I installed postgis from this repo of sles11 (not sp1)
> > > > >
> > > >
> > >
>
http://download.opensuse.org/repositories/Application:/Geo:/Postgres9PostGIS1/SLE_11
>
> > >
> > > >
> > > > > (also tried with this one
> > > > >
http://download.opensuse.org/repositories/Application:/Geo/SLE_11)
> > > > >
> > > > > Everything went well but I when I tried to enable postgis
running
> > > > > postgis.sql, I got this error
> > > > > psql:/usr/share/postgresql/contrib/postgis-1.5/postgis.sql:59:
> > > > > ERREUR:
> > >
> > > > n'a
> > > > > pas pu charger la bibliothèque
> > > > > « /usr/lib64/postgresql/postgis-1.5.so
> > > »
> > > > :
> > > > > /usr/lib64/postgresql/postgis-1.5.so: undefined symbol:
> > > > > DirectFunctionCall4
> > > > >
> > > > > I also tried to compile postgis but I got this error
> > > > >
> > > >
> > >
>
/usr/lib64/gcc/x86_64-suse-linux/4.3/../../../../x86_64-suse-linux/bin/ld:
>
> > >
> > > >
> > > > > /usr/lib64/libxml2.a(parser.o): relocation R_X86_64_32S against
> > > > > `.rodata.str1.1' can not be used when making a shared object;
> > > recompile
> > > > > with -fPIC
> > > > > /usr/lib64/libxml2.a: could not read symbols: Bad value
> > > > > collect2: ld returned 1 exit status
> > > > >
> > > > > Anyone successfully installed postgis on sles 11 SP1?
> > > > > Any help or suggestions?
> > > > > Thanks for your help
> > > > > Steve
> > > > _______________________________________________
> > > > 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
Geoinformatik Büro Dassau - http://www.gbd-consult.de
FOSSGIS consulting , training , support and analysis
Davenstedter Str. 60 , D - 30453 Hannover , Germany
Phone: +49-(0)511-2615322 , Fax: +49-(0)511-2615323
--
Community Advisor - QGIS Project Steering Committee
_______________________________________________
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120106/8aba5a6b/attachment.html>
More information about the postgis-users
mailing list