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?
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
