On 2011-02-07, at 11:27 AM, Edoardo Panfili wrote: > On 07/02/11 18.55, Paul Ramsey wrote: >> Well, maybe you could in-place upgrade if you left your PostGIS version >> at the original and only upgraded the PostgreSQL part, but you aren't >> doing that, you're also upgrading your PostGIS version. >> >> pg_dump the database >> create a new database on the new server, install postgis in it >> pg_restore the database > I am at the beginning with postigis. This is also my way to copy the data from one machine to another. I have the same server in both the machines (postgresql 8.4 + postgis 1.5), no errors during this process. > >> ignore the many errors > this sentence scares me a bit (for my future)... what kind of errors? "error messages" would be a better term. In the procedure above you are installing a database dump, which will naturally include the PostGIS function and type definitions into a database in which you have *already* installed the PostGIS function and type definitions. Naturally you get a lot of noise as the functions in the dump try to install and hit the existing types and functions. But it's sound and fury signifying nothing. P. > > > Edoardo > > > >> On 2011-02-07, at 9:49 AM, akp geek wrote: >> >>> >>> Please pardon my ignorance. The reason I am worried about it is, when >>> I tried to use pg_upgrade to migrate from 8.3 to 9.0.2. I am getting >>> an error >>> >>> Failed to load library: $libdir/liblwgeom >>> ERROR: could not access file "$libdir/liblwgeom": No such file or >>> directory >>> >>> I am using pg_upgrade for upgrading >>> >>> >>> Regards >>> >>> On Mon, Feb 7, 2011 at 12:39 PM, Paul Ramsey >>> <pramsey@xxxxxxxxxxxxxxxxx <mailto:pramsey@xxxxxxxxxxxxxxxxx>> wrote: >>> >>> It's not a dynlib, it's statically linked at build time, so have >>> no fear. Stop thinking so much :) >>> P >>> >>> On 2011-02-07, at 9:38 AM, akp geek wrote: >>> >>>> installation was successful. But it did not install the liblwgeom.so >>>> >>>> Regards >>>> >>>> On Mon, Feb 7, 2011 at 12:29 PM, Paul Ramsey >>>> <pramsey@xxxxxxxxxxxxxxxxx <mailto:pramsey@xxxxxxxxxxxxxxxxx>> wrote: >>>> >>>> It's just a warning, continue happily onwards. Just means a >>>> few unit tests won't be run. >>>> >>>> P. >>>> >>>> >>>> On 2011-02-07, at 9:27 AM, akp geek wrote: >>>> >>>>> Hi All - >>>>> >>>>> I am trying to install postgis 1.5.2 on solaris10. When I >>>>> run the configure I get the following. >>>>> >>>>> *configure: WARNING: could not locate CUnit required for >>>>> liblwgeom unit tests* >>>>> >>>>> is there some setting I need to do to make it work? >>>>> >>>>> >>>>> $./configure --prefix=/opt/postgres/gis >>>>> --with-geosconfig=/opt/postgres/gis/bin/geos-config >>>>> --with-projdir=/opt/postgres/gis >>>>> checking build system type... sparc-sun-solaris2.10 >>>>> checking host system type... sparc-sun-solaris2.10 >>>>> checking for gcc... gcc >>>>> checking whether the C compiler works... ^C10.112.161.124$ >>>>> $./configure --prefix=/opt/postgres/gis >>>>> --with-geosconfig=/opt/postgres/gis/bin/geos-config >>>>> --with-projdir=/opt/postgres/gis >>>>> checking build system type... sparc-sun-solaris2.10 >>>>> checking host system type... sparc-sun-solaris2.10 >>>>> checking for gcc... gcc >>>>> checking whether the C compiler works... yes >>>>> checking for C compiler default output file name... a.out >>>>> checking for suffix of executables... >>>>> checking whether we are cross compiling... no >>>>> checking for suffix of object files... o >>>>> checking whether we are using the GNU C compiler... yes >>>>> checking whether gcc accepts -g... yes >>>>> checking for gcc option to accept ISO C89... none needed >>>>> checking for a sed that does not truncate output... >>>>> /usr/5bin/sed >>>>> checking for grep that handles long lines and -e... >>>>> /usr/sfw/bin/ggrep >>>>> checking for egrep... /usr/sfw/bin/ggrep -E >>>>> checking for fgrep... /usr/sfw/bin/ggrep -F >>>>> checking for ld used by gcc... /usr/ccs/bin/ld >>>>> checking if the linker (/usr/ccs/bin/ld) is GNU ld... no >>>>> checking for BSD- or MS-compatible name lister (nm)... >>>>> /usr/ccs/bin/nm -p >>>>> checking the name lister (/usr/ccs/bin/nm -p) interface... >>>>> BSD nm >>>>> checking whether ln -s works... yes >>>>> checking the maximum length of command line arguments... 786240 >>>>> checking whether the shell understands some XSI >>>>> constructs... yes >>>>> checking whether the shell understands "+="... no >>>>> checking for /usr/ccs/bin/ld option to reload object files... -r >>>>> checking for objdump... no >>>>> checking how to recognize dependent libraries... pass_all >>>>> checking for ar... ar >>>>> checking for strip... strip >>>>> checking for ranlib... ranlib >>>>> checking command to parse /usr/ccs/bin/nm -p output from gcc >>>>> object... ok >>>>> checking how to run the C preprocessor... gcc -E >>>>> checking for ANSI C header files... yes >>>>> checking for sys/types.h... yes >>>>> checking for sys/stat.h... yes >>>>> checking for stdlib.h... yes >>>>> checking for string.h... yes >>>>> checking for memory.h... yes >>>>> checking for strings.h... yes >>>>> checking for inttypes.h... yes >>>>> checking for stdint.h... yes >>>>> checking for unistd.h... yes >>>>> checking for dlfcn.h... yes >>>>> checking for objdir... .libs >>>>> checking if gcc supports -fno-rtti -fno-exceptions... no >>>>> checking for gcc option to produce PIC... -fPIC -DPIC >>>>> checking if gcc PIC flag -fPIC -DPIC works... yes >>>>> checking if gcc static flag -static works... no >>>>> checking if gcc supports -c -o file.o... yes >>>>> checking if gcc supports -c -o file.o... (cached) yes >>>>> checking whether the gcc linker (/usr/ccs/bin/ld) supports >>>>> shared libraries... yes >>>>> checking whether -lc should be explicitly linked in... yes >>>>> checking dynamic linker characteristics... solaris2.10 ld.so >>>>> checking how to hardcode library paths into programs... >>>>> immediate >>>>> checking whether stripping libraries is possible... no >>>>> checking if libtool supports shared libraries... yes >>>>> checking whether to build shared libraries... yes >>>>> checking whether to build static libraries... yes >>>>> checking for gcc... (cached) gcc >>>>> checking whether we are using the GNU C compiler... (cached) yes >>>>> checking whether gcc accepts -g... (cached) yes >>>>> checking for gcc option to accept ISO C89... (cached) none >>>>> needed >>>>> checking how to run the C preprocessor... gcc -E >>>>> checking for g++... g++ >>>>> checking whether we are using the GNU C++ compiler... yes >>>>> checking whether g++ accepts -g... yes >>>>> checking whether we are using the GNU C++ compiler... >>>>> (cached) yes >>>>> checking whether g++ accepts -g... (cached) yes >>>>> checking how to run the C++ preprocessor... g++ -E >>>>> checking for ld used by g++... /usr/ccs/bin/ld >>>>> checking if the linker (/usr/ccs/bin/ld) is GNU ld... no >>>>> checking whether the g++ linker (/usr/ccs/bin/ld) supports >>>>> shared libraries... yes >>>>> checking for g++ option to produce PIC... -fPIC -DPIC >>>>> checking if g++ PIC flag -fPIC -DPIC works... yes >>>>> checking if g++ static flag -static works... no >>>>> checking if g++ supports -c -o file.o... yes >>>>> checking if g++ supports -c -o file.o... (cached) yes >>>>> checking whether the g++ linker (/usr/ccs/bin/ld) supports >>>>> shared libraries... yes >>>>> checking dynamic linker characteristics... solaris2.10 ld.so >>>>> checking how to hardcode library paths into programs... >>>>> immediate >>>>> checking if g++ supports -Wall... yes >>>>> checking if g++ supports -Wmissing-prototypes... yes >>>>> checking if g++ supports -ffloat-store... yes >>>>> checking for flex... flex >>>>> checking lex output file root... lex.yy >>>>> checking lex library... -lfl >>>>> checking whether yytext is a pointer... yes >>>>> checking for bison... bison -y >>>>> checking ieeefp.h usability... yes >>>>> checking ieeefp.h presence... yes >>>>> checking for ieeefp.h... yes >>>>> checking for convert... /usr/sfw/bin/convert >>>>> checking for xsltproc... /usr/5bin/xsltproc >>>>> checking for dblatex... no >>>>> configure: WARNING: dblatex is not installed so PDF >>>>> documentation cannot be built >>>>> checking CUnit/CUnit.h usability... no >>>>> checking CUnit/CUnit.h presence... no >>>>> checking for CUnit/CUnit.h... no >>>>> configure: WARNING: could not locate CUnit required for >>>>> liblwgeom unit tests >>>>> checking iconv.h usability... yes >>>>> checking iconv.h presence... yes >>>>> checking for iconv.h... yes >>>>> checking for libiconv_open in -liconv... yes >>>>> checking for iconvctl... no >>>>> checking for libiconvctl... no >>>>> checking for pg_config... /opt/postgres/9.0.2/bin/pg_config >>>>> checking PostgreSQL version... PostgreSQL 9.0.2 >>>>> checking libpq-fe.h usability... yes >>>>> checking libpq-fe.h presence... yes >>>>> checking for libpq-fe.h... yes >>>>> checking for PQserverVersion in -lpq... yes >>>>> checking for xml2-config... /usr/5bin/xml2-config >>>>> checking libxml/tree.h usability... yes >>>>> checking libxml/tree.h presence... yes >>>>> checking for libxml/tree.h... yes >>>>> checking libxml/parser.h usability... yes >>>>> checking libxml/parser.h presence... yes >>>>> checking for libxml/parser.h... yes >>>>> checking libxml/xpath.h usability... yes >>>>> checking libxml/xpath.h presence... yes >>>>> checking for libxml/xpath.h... yes >>>>> checking libxml/xpathInternals.h usability... yes >>>>> checking libxml/xpathInternals.h presence... yes >>>>> checking for libxml/xpathInternals.h... yes >>>>> checking for xmlInitParser in -lxml2... yes >>>>> Using user-specified geos-config file: >>>>> /opt/postgres/gis/bin/geos-config >>>>> checking GEOS version... 3.2.2 >>>>> checking geos_c.h usability... yes >>>>> checking geos_c.h presence... yes >>>>> checking for geos_c.h... yes >>>>> checking for initGEOS in -lgeos_c... yes >>>>> Using user-specified proj directory: /opt/postgres/gis >>>>> checking proj_api.h usability... yes >>>>> checking proj_api.h presence... yes >>>>> checking for proj_api.h... yes >>>>> checking for pj_get_release in -lproj... yes >>>>> configure: creating ./config.status >>>>> config.status: creating liblwgeom/Makefile >>>>> config.status: creating liblwgeom/cunit/Makefile >>>>> config.status: creating postgis/Makefile >>>>> config.status: creating postgis/sqldefines.h >>>>> config.status: creating loader/Makefile >>>>> config.status: creating topology/Makefile >>>>> config.status: creating regress/Makefile >>>>> config.status: creating doc/Makefile >>>>> config.status: creating doc/Makefile.comments >>>>> config.status: creating doc/html/image_src/Makefile >>>>> config.status: creating postgis_config.h >>>>> config.status: executing libtool commands >>>>> >>>>> PostGIS is now configured for sparc-sun-solaris2.10 >>>>> >>>>> -------------- Compiler Info ------------- >>>>> C compiler: gcc -g -O2 >>>>> C++ compiler: g++ -g -O2 >>>>> >>>>> -------------- Dependencies -------------- >>>>> GEOS config: /opt/postgres/gis/bin/geos-config >>>>> GEOS version: 3.2.2 >>>>> PostgreSQL config: /opt/postgres/9.0.2/bin/pg_config >>>>> PostgreSQL version: PostgreSQL 9.0.2 >>>>> PROJ4 version: 47 >>>>> Libxml2 config: /usr/5bin/xml2-config >>>>> Libxml2 version: 2.6.23 >>>>> PostGIS debug level: 0 >>>>> >>>>> -------- Documentation Generation -------- >>>>> xsltproc: /usr/5bin/xsltproc >>>>> xsl style sheets: /usr/share/sgml/docbook/xsl-stylesheets >>>>> dblatex: >>>>> convert: /usr/sfw/bin/convert >>>>> >>>>> Regards >>>>> >>>> >>>> >>> >>> >> > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
