After database update I did: root@thinkpad:/root(132)# emerge --config =dev-db/postgresql-server-9.0.0 ... vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the -A option the next time you run initdb. ... root@thinkpad:/root(133)# /etc/init.d/postgresql-9.0 start * Starting PostgreSQL ... [ ok ] root@thinkpad:/root(134)# psql -U postgres -d postgres -f pg_dumpall-8.3 You are now connected to database "postgres". SET SET SET psql:pg_dumpall-8.3:15: ERROR: role "postgres" already exists ALTER ROLE CREATE ROLE ALTER ROLE CREATE DATABASE REVOKE REVOKE GRANT GRANT You are now connected to database "gis". SET SET SET SET SET psql:pg_dumpall-8.3:52: ERROR: language "plpgsql" already exists ALTER LANGUAGE SET CREATE TYPE psql:pg_dumpall-8.3:72: ERROR: could not access file "/usr/lib/postgresql//liblwgeom": No such file or directory psql:pg_dumpall-8.3:75: ERROR: function public.st_box2d_in(cstring) does not exist psql:pg_dumpall-8.3:83: ERROR: could not access file "/usr/lib/postgresql//liblwgeom": No such file or directory psql:pg_dumpall-8.3:86: ERROR: function public.st_box2d_out(box2d) does not exist psql:pg_dumpall-8.3:98: ERROR: function st_box2d_in(cstring) does not exist ALTER TYPE CREATE TYPE psql:pg_dumpall-8.3:116: ERROR: could not access file "/usr/lib/postgresql//liblwgeom": No such file or directory psql:pg_dumpall-8.3:119: ERROR: function public.st_box3d_in(cstring) does not exist psql:pg_dumpall-8.3:127: ERROR: could not access file "/usr/lib/postgresql//liblwgeom": No such file or directory psql:pg_dumpall-8.3:130: ERROR: function public.st_box3d_out(box3d) does not exist psql:pg_dumpall-8.3:142: ERROR: function st_box3d_in(cstring) does not exist ALTER TYPE CREATE TYPE psql:pg_dumpall-8.3:160: ERROR: could not access file "/usr/lib/postgresql//liblwgeom": No such file or directory psql:pg_dumpall-8.3:163: ERROR: function public.st_chip_in(cstring) does not exist psql:pg_dumpall-8.3:171: ERROR: could not access file "/usr/lib/postgresql//liblwgeom": No such file or directory ... psql:pg_dumpall-8.3:9543: ERROR: type "public.geometry" is only a shell psql:pg_dumpall-8.3:9550: ERROR: type "public.chip" is only a shell psql:pg_dumpall-8.3:9557: ERROR: type "public.geometry" is only a shell psql:pg_dumpall-8.3:9564: ERROR: type "public.geometry" is only a shell psql:pg_dumpall-8.3:9571: ERROR: type "public.geometry" is only a shell psql:pg_dumpall-8.3:9578: ERROR: type "public.geometry" is only a shell psql:pg_dumpall-8.3:9585: ERROR: type "public.geometry" is only a shell psql:pg_dumpall-8.3:9592: ERROR: type "public.geometry" is only a shell SET SET SET CREATE TABLE ALTER TABLE SET CREATE TABLE ALTER TABLE ALTER TABLE ALTER TABLE REVOKE REVOKE GRANT GRANT You are now connected to database "postgres". SET SET SET SET SET REVOKE REVOKE GRANT GRANT You are now connected to database "template1". SET SET SET SET SET COMMENT REVOKE REVOKE GRANT GRANT Postgis-1.5.2 was installed with the patch corresponding to Bug 339312. Reproducible: Always root@thinkpad:/root(139)# emerge --info Portage 2.1.9.22 (default/linux/x86/10.0/desktop, gcc-4.4.4, glibc-2.12.1-r1, 2.6.36 i686) ================================================================= System uname: Linux-2.6.36-i686-Intel-R-_Pentium-R-_M_processor_2.00GHz-with-gentoo-2.0.1 Timestamp of tree: Sun, 24 Oct 2010 23:00:19 +0000 ccache version 2.4 [disabled] app-shells/bash: 4.1_p9 dev-java/java-config: 2.1.11-r1 dev-lang/python: 2.6.6-r1, 3.1.2-r4 dev-util/ccache: 2.4-r8 dev-util/cmake: 2.8.1-r2 sys-apps/baselayout: 2.0.1 sys-apps/openrc: 0.6.3 sys-apps/sandbox: 2.3-r1 sys-devel/autoconf: 2.13, 2.68 sys-devel/automake: 1.4_p6-r1, 1.7.9-r2, 1.8.5-r4, 1.9.6-r3, 1.10.3, 1.11.1 sys-devel/binutils: 2.20.1-r1 sys-devel/gcc: 4.4.4-r2, 4.5.1 sys-devel/gcc-config: 1.4.1 sys-devel/libtool: 2.2.10 sys-devel/make: 3.82 virtual/os-headers: 2.6.35 (sys-kernel/linux-headers) ACCEPT_KEYWORDS="x86 ~x86" ACCEPT_LICENSE="* -@EULA PUEL dlj-1.1 skype-eula googleearth AdobeFlash-10.1 cadsoft" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2 -march=pentium-m -fomit-frame-pointer" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/config /var/lib/hsqldb" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/eselect/postgresql /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c" CXXFLAGS="-O2 -march=pentium-m -fomit-frame-pointer" DISTDIR="/usr/portage/distfiles" FEATURES="assume-digests binpkg-logs distlocks fixlafiles fixpackages news parallel-fetch protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch" FFLAGS="-O2 -march=pentium-m -fomit-frame-pointer" GENTOO_MIRRORS="http://linux.rz.ruhr-uni-bochum.de/download/gentoo-mirror http://ftp-stud.fht-esslingen.de/pub/Mirrors/gentoo/ rsync://ftp.fi.muni.cz/pub/linux/gentoo ftp://ftp.wh2.tu-dresden.de/pub/mirrors/gentoo ftp://vlaai.snt.ipv6.utwente.nl/pub/os/linux/gentoo/" LANG="en_US.UTF-8" LDFLAGS="-Wl,-O1 -Wl,--as-needed" LINGUAS="de fr" MAKEOPTS="-j1" PKGDIR="/usr/portage/packages/" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/var/lib/layman/arcon /var/lib/layman/java-overlay /var/lib/layman/lordvan /var/lib/layman/pro-audio /var/lib/layman/science /var/lib/layman/sunrise /var/lib/layman/x11 /usr/local/portage /var/lib/cpan" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="R X Xaw3d a52 aac abiword acl acpi admin afs alsa amrr ao apache2 applet archive arpack asf aspell assistant audacious audiofile automap automount bash-completion beagle berkdb blas blast bluetooth boo boost branding bzip2 cairo cardbus cdda cddb cdf cdio cdparanoia cdr cgi chm cli consolekit corba cracklib crypt css cups curl cxx daap db dbase dbi dbm dbus designer devhelp device-mapper dga dia djvu doc dri ds2490 ds9097 ds9097u dts dv dvb dvd dvdr dvi dynamicplugin eds elf emacs emboss empathy encode epiphany evo examples exif expat extensions extra extras fam fame ffmpeg fftw firefox fits flac fltk fontconfig foomaticdb fortran fpx fts3 fuse galago garmin gd gdal gdbm gedit geoip geolocation geos gif gimp ginac git glade glib gml gmp gmtsuppl gnokii gnome gnome-keyring gnome-print gnuplot gnutls gphoto2 gpm grammar graphics graphtft graphviz grass gs gsl gsm gstreamer gtk guile hal harness hddtemp hdf hdf5 hdri hlapi http httpd iconv icq icu id3 ide imagemagick imap innodb inotify ipod ipv6 irda ithreads jabber jadetex java java5 java6 jbig john jpeg jpeg2k kdrive kerberos kpathsea ladspa lame lapack laptop latex latex3 lcms ldap lensfun libffi libgda libnotify libsamplerate lirc lua lzo mad madwifi mail maildir mailwrapper mapnik math matroska mikmod mkl mmx mmxext mng modules mono moonlight motif mozdevelop mozilla mp3 mp4 mpeg mpi mplayer mtp mudflap musicbrainz mysql mysqli nautilus ncurses neXt netcdf netpbm network networking networkmanager nfs nls nntp nptl nptlonly nsplugin ntfs ntp numarray numeric obex objc ocaml octave odbc ogdi ogg ole openexr opengl openmp overview pam pango pcre pda pdf perl plotutils plugins png podcast policykit posix postgres postscript ppds pppd preview-latex proj projectx pstricks pulseaudio pymol python python-bindings qemu qhull qt3support qt4 quicktime readline reiserfs reports rle romio rpc rrdcgi rrdtool samba sasl science sdl secure-delete semantic-desktop server session sip slang slp smbclient sms sndfile snmp soup sox speex spell sql sqlite sse sse2 ssl startup-notification stlport subtitles subversion suexec svg swig sysfs szip t1lib tcl tcpd tex tex4ht texmacs theora thinkpad threads thunderbird tidy tiff tk tntc tools truetype udev unicode usb userlocales utempter v4l2 virtualbox vorbis wav webdav webdav-serf webkit wifi win32codecs wmf wxwidgets x264 x86 xattr xcb xemacs xext xine xml xmlreader xmlrpc xorg xpm xulrunner xv xvid xvmc zlib zvbi" ALSA_CARDS="intel8x0 ac97_codec emu10k1 emu10k1x" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic auth_digest authn_anon authn_dbd authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock dbd deflate dir disk_cache env expires ext_filter file_cache filter headers ident imagemap include info log_config logio mem_cache mime mime_magic negotiation proxy proxy_ajp proxy_balancer proxy_connect proxy_http rewrite setenvif so speling status unique_id userdir usertrack vhost_alias" CAMERAS="canon" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" DVB_CARDS="usb-wt220u" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="keyboard mouse evdev synaptics " KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="de fr" NETBEANS_MODULES="apisupport cnd dlight enterprise ergonomics groovy gsf harness ide identity j2ee java mobility nb php profiler ruby websvccommon xml" PHP_TARGETS="php5-2" QEMU_SOFTMMU_TARGETS="i386 ppc ppc64 x86_64" QEMU_USER_TARGETS="arm i386 x86_64" RUBY_TARGETS="ruby18 jruby" USERLAND="GNU" VIDEO_CARDS="radeon vesa displaylink" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Is this any different from bug 339312, or is it ok to mark it as duplicate of that same issue?
It is different.
Upstream has a solution to this: http://postgis.refractions.net/documentation/manual-1.5/ch02.html#hard_upgrade
