[postgis-users] RE [Polluriel potentiel] Re: Postgis installation on sles 11 sp1
Otto Dassau
dassau at gbd-consult.de
Sat Jan 7 01:31:07 PST 2012
Hi Steve,
the postgresql package is included from another repository:
server:database:postgresql
https://build.opensuse.org/package/users?package=postgresql&project=server%3Adatabase%3Apostgresql
Best would be to contact the maintainer Reinhard Max (rmax), if you
need changes for that packages. His contact is max at suse.com.
Regards
Otto
Am Fri, 6 Jan 2012 14:31:04 -0500
schrieb Steve.Toutant at inspq.qc.ca:
> 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
More information about the postgis-users
mailing list