could not load library
songzhiyong opened this issue · 18 comments
songzhiyong commented
ERROR: could not load library "/usr/lib/postgresql/10/lib/pg_similarity.so": /usr/lib/postgresql/10/lib/pg_similarity.so: undefined symbol: Float8GetDatum
i got this error, how to fix it
eulerto commented
@songzhiyong what is your postgres version? How do you install postgres? How do you install pg_similarity?
songzhiyong commented
my postgres version is 10.0 and I installed pg_similarity following README(git clone --> make --> make install)
eulerto commented
Could you show the make output? I suspect that the compile and/or linkage are not using postgres 10.0 libraries.
sollimeister commented
Got the same error when installing for postgresql 11 on ubuntu 18.04. This is the output from the linker:
root@geoserv:/usr/lib/postgresql/11/lib# ld -v pg_similarity.so
GNU ld (GNU Binutils for Ubuntu) 2.30
ld: warning: cannot find entry symbol _start; not setting start address
pg_similarity.so: undefined reference to DefineCustomEnumVariable' pg_similarity.so: undefined reference to textout'
pg_similarity.so: undefined reference to elog_finish' pg_similarity.so: undefined reference to text_to_cstring'
pg_similarity.so: undefined reference to errstart' pg_similarity.so: undefined reference to pg_detoast_datum'
pg_similarity.so: undefined reference to palloc' pg_similarity.so: undefined reference to cstring_to_text_with_len'
pg_similarity.so: undefined reference to elog_start' pg_similarity.so: undefined reference to errmsg'
pg_similarity.so: undefined reference to EmitWarningsOnPlaceholders' pg_similarity.so: undefined reference to Float8GetDatum'
pg_similarity.so: undefined reference to DefineCustomRealVariable' pg_similarity.so: undefined reference to DirectFunctionCall2Coll'
pg_similarity.so: undefined reference to DatumGetFloat8' pg_similarity.so: undefined reference to errfinish'
pg_similarity.so: undefined reference to sqrt' pg_similarity.so: undefined reference to DirectFunctionCall1Coll'
pg_similarity.so: undefined reference to pfree' pg_similarity.so: undefined reference to DefineCustomBoolVariable'
pg_similarity.so: undefined reference to `errcode'
root@geoserv:/usr/lib/postgresql/11/lib#
sollimeister commented
postgres=# create extension pg_similarity;
2019-07-04 15:05:58 CEST ERROR: could not load library "/usr/lib/postgresql/11/lib/pg_similarity.so": /usr/lib/postgresql/11/lib/pg_similarity.so: undefined symbol: Float8GetDatum
2019-07-04 15:05:58 CEST STATEMENT: create extension pg_similarity;
ERROR: could not load library "/usr/lib/postgresql/11/lib/pg_similarity.so": /usr/lib/postgresql/11/lib/pg_similarity.so: undefined symbol: Float8GetDatum
eulerto commented
@sollimeister How do you compile pg_similarity? It seems it couldn't find the postgres libraries. What is the pg_config --configure output? What is the make output?
sollimeister commented
pg_config --configure
'--build=x86_64-linux-gnu' '--prefix=/usr' '--includedir=/usr/include'
'--mandir=/usr/share/man' '--infodir=/usr/share/info' '--sysconfdir=/etc'
'--localstatedir=/var' '--disable-silent-rules'
'--libdir=/usr/lib/x86_64-linux-gnu'
'--libexecdir=/usr/lib/x86_64-linux-gnu' '--disable-maintainer-mode'
'--disable-dependency-tracking' '--with-icu' '--with-tcl' '--with-perl'
'--with-python' '--with-pam' '--with-openssl' '--with-libxml'
'--with-libxslt' 'PYTHON=/usr/bin/python'
'--mandir=/usr/share/postgresql/11/man'
'--docdir=/usr/share/doc/postgresql-doc-11'
'--sysconfdir=/etc/postgresql-common' '--datarootdir=/usr/share/'
'--datadir=/usr/share/postgresql/11' '--bindir=/usr/lib/postgresql/11/bin'
'--libdir=/usr/lib/x86_64-linux-gnu/' '--libexecdir=/usr/lib/postgresql/'
'--includedir=/usr/include/postgresql/' '--with-extra-version= (Ubuntu
11.4-1.pgdg18.04+1)' '--enable-nls' '--enable-integer-datetimes'
'--enable-thread-safety' '--enable-tap-tests' '--enable-debug'
'--enable-dtrace' '--disable-rpath' '--with-uuid=e2fs' '--with-gnu-ld'
'--with-pgport=5432' '--with-system-tzdata=/usr/share/zoneinfo'
'--with-llvm' '--with-systemd' '--with-selinux' 'MKDIR_P=/bin/mkdir -p'
'TAR=/bin/tar' 'CFLAGS=-g -O2 -fstack-protector-strong -Wformat
-Werror=format-security -fno-omit-frame-pointer'
'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now' '--with-gssapi'
'--with-ldap' '--with-includes=/usr/include/mit-krb5'
'--with-libs=/usr/lib/mit-krb5'
'--with-libs=/usr/lib/x86_64-linux-gnu/mit-krb5'
'build_alias=x86_64-linux-gnu' 'CPPFLAGS=-Wdate-time -D_FORTIFY_SOURCE=2'
'CXXFLAGS=-g -O2 -fstack-protector-strong -Wformat -Werror=format-security'
…On Thu, Jul 4, 2019 at 3:11 PM Euler Taveira de Oliveira < ***@***.***> wrote:
@sollimeister <https://github.com/sollimeister> How do you compile
pg_similarity? It seems it couldn't find the postgres libraries. What is
the pg_config --configure output? What is the make output?
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#18?email_source=notifications&email_token=AAA3COVNPG34QYEXM25UFTDP5XZHPA5CNFSM4EKLTQKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZHMAQI#issuecomment-508477505>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AAA3COUDASPH24TF7J2I7LTP5XZHPANCNFSM4EKLTQKA>
.
--
AS
sollimeister commented
Hi
Seems like port is wrong. I am upgradeing from 9.6 to 11. The old 9.6 is on
5432 and version 11 is on 5435. It was a problem that postgres11 did not
install pg_config, so I had to install the postgres11-server-devel in order
to get pg_config for version 11.
Perhaps there is some mix of 9.6 and 11.0 directories (libraries ?).
Arne
…On Thu, Jul 4, 2019 at 3:42 PM Arne Solli ***@***.***> wrote:
pg_config --configure
'--build=x86_64-linux-gnu' '--prefix=/usr' '--includedir=/usr/include'
'--mandir=/usr/share/man' '--infodir=/usr/share/info' '--sysconfdir=/etc'
'--localstatedir=/var' '--disable-silent-rules'
'--libdir=/usr/lib/x86_64-linux-gnu'
'--libexecdir=/usr/lib/x86_64-linux-gnu' '--disable-maintainer-mode'
'--disable-dependency-tracking' '--with-icu' '--with-tcl' '--with-perl'
'--with-python' '--with-pam' '--with-openssl' '--with-libxml'
'--with-libxslt' 'PYTHON=/usr/bin/python'
'--mandir=/usr/share/postgresql/11/man'
'--docdir=/usr/share/doc/postgresql-doc-11'
'--sysconfdir=/etc/postgresql-common' '--datarootdir=/usr/share/'
'--datadir=/usr/share/postgresql/11' '--bindir=/usr/lib/postgresql/11/bin'
'--libdir=/usr/lib/x86_64-linux-gnu/' '--libexecdir=/usr/lib/postgresql/'
'--includedir=/usr/include/postgresql/' '--with-extra-version= (Ubuntu
11.4-1.pgdg18.04+1)' '--enable-nls' '--enable-integer-datetimes'
'--enable-thread-safety' '--enable-tap-tests' '--enable-debug'
'--enable-dtrace' '--disable-rpath' '--with-uuid=e2fs' '--with-gnu-ld'
'--with-pgport=5432' '--with-system-tzdata=/usr/share/zoneinfo'
'--with-llvm' '--with-systemd' '--with-selinux' 'MKDIR_P=/bin/mkdir -p'
'TAR=/bin/tar' 'CFLAGS=-g -O2 -fstack-protector-strong -Wformat
-Werror=format-security -fno-omit-frame-pointer'
'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now' '--with-gssapi'
'--with-ldap' '--with-includes=/usr/include/mit-krb5'
'--with-libs=/usr/lib/mit-krb5'
'--with-libs=/usr/lib/x86_64-linux-gnu/mit-krb5'
'build_alias=x86_64-linux-gnu' 'CPPFLAGS=-Wdate-time -D_FORTIFY_SOURCE=2'
'CXXFLAGS=-g -O2 -fstack-protector-strong -Wformat -Werror=format-security'
On Thu, Jul 4, 2019 at 3:11 PM Euler Taveira de Oliveira <
***@***.***> wrote:
> @sollimeister <https://github.com/sollimeister> How do you compile
> pg_similarity? It seems it couldn't find the postgres libraries. What is
> the pg_config --configure output? What is the make output?
>
> —
> You are receiving this because you were mentioned.
> Reply to this email directly, view it on GitHub
> <#18?email_source=notifications&email_token=AAA3COVNPG34QYEXM25UFTDP5XZHPA5CNFSM4EKLTQKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZHMAQI#issuecomment-508477505>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/AAA3COUDASPH24TF7J2I7LTP5XZHPANCNFSM4EKLTQKA>
> .
>
--
AS
--
AS
eulerto commented
You do not provide all information I requested. What are the postgresql packages installed?
dpkg -l | grep postgresql
eulerto commented
Seems like port is wrong. I am upgradeing from 9.6 to 11. The old 9.6 is on
5432 and version 11 is on 5435. It was a problem that postgres11 did not
install pg_config, so I had to install the postgres11-server-devel in order
to get pg_config for version 11.
It does not matter if you have multiple postgres versions. However, while build/install pg_similarity you have to make sure the right pg_config is in your PATH ( pg_config --version ).
sollimeister commented
Yes, it was because I purged version 9.6 in order to remove the old
pg_config, then installed developer version of 11 to get the correct
pg_config. Then I checked that all references in the compile / link was to
11, not to 9.6. The first time I compiled&linked all references was to
9.6. So perhaps there are some files that has not been deleted since I
compiled the first times using the wrong pg_config
Arne
…On Thu, Jul 4, 2019 at 4:07 PM Euler Taveira de Oliveira < ***@***.***> wrote:
Seems like port is wrong. I am upgradeing from 9.6 to 11. The old 9.6 is on
5432 and version 11 is on 5435. It was a problem that postgres11 did not
install pg_config, so I had to install the postgres11-server-devel in order
to get pg_config for version 11.
It does not matter if you have multiple postgres versions. However, while
build/install pg_similarity you have to make sure the *right* pg_config
is in your PATH ( pg_config --version ).
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#18?email_source=notifications&email_token=AAA3CORGZRAO7EWYQZ4VB6DP5X72TA5CNFSM4EKLTQKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZHQKGA#issuecomment-508495128>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AAA3COVPELR7LT5ZHVMPHYTP5X72TANCNFSM4EKLTQKA>
.
--
AS
sollimeister commented
arne@geoserv:/etc/postgresql/11/main$ dpkg -l | grep postgresql
ii libpostgresql-jdbc-java
42.2.5-2.pgdg18.04+1 all Java
database (JDBC) driver for PostgreSQL
ii libreoffice-sdbc-postgresql
1:6.0.7-0ubuntu0.18.04.6 amd64
PostgreSQL SDBC driver for LibreOffice
ii pgdg-keyring 2018.2
all keyring for apt.postgresql.org
ii postgresql 11+201.pgdg18.04+1
all object-relational SQL
database (supported version)
ii postgresql-10-postgis-2.4-scripts
2.4.4+dfsg-4.pgdg18.04+1 all
Geographic objects support for PostgreSQL 10 -- SQL scripts
ii postgresql-11 11.4-1.pgdg18.04+1
amd64 object-relational SQL
database, version 11 server
ii postgresql-11-postgis-2.5
2.5.2+dfsg-1~exp1.pgdg18.04+1 amd64
Geographic objects support for PostgreSQL 11
ii postgresql-11-postgis-2.5-scripts
2.5.2+dfsg-1~exp1.pgdg18.04+1 all
Geographic objects support for PostgreSQL 11 -- SQL scripts
rc postgresql-9.3
9.3.25-1.pgdg14.04+1 amd64
object-relational SQL database, version 9.3 server
rc postgresql-9.4
9.4.20-1.pgdg14.04+1 amd64
object-relational SQL database, version 9.4 server
ii postgresql-9.4-postgis-2.3-scripts
2.3.3+dfsg-1.pgdg14.04+1 all Geographic
objects support for PostgreSQL 9.4 -- scripts
rc postgresql-9.5
9.5.15-1.pgdg14.04+1 amd64
object-relational SQL database, version 9.5 server
ii postgresql-9.6
9.6.14-1.pgdg18.04+1 amd64
object-relational SQL database, version 9.6 server
ii postgresql-9.6-postgis-2.4
2.4.4+dfsg-4.pgdg18.04+1 amd64 Geographic
objects support for PostgreSQL 9.6
ii postgresql-9.6-postgis-2.4-scripts
2.4.4+dfsg-4.pgdg18.04+1 all Geographic
objects support for PostgreSQL 9.6 -- SQL scripts
ii postgresql-client-10 10.9-1.pgdg18.04+1
amd64 front-end programs for
PostgreSQL 10
ii postgresql-client-11 11.4-1.pgdg18.04+1
amd64 front-end programs for
PostgreSQL 11
ii postgresql-client-9.3
9.3.25-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.3
ii postgresql-client-9.4
9.4.23-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.4
ii postgresql-client-9.5
9.5.18-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.5
ii postgresql-client-9.6
9.6.14-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.6
ii postgresql-client-common 201.pgdg18.04+1
all manager for multiple
PostgreSQL client versions
ii postgresql-common 201.pgdg18.04+1
all PostgreSQL database-cluster
manager
ii postgresql-contrib 11+201.pgdg18.04+1
all additional facilities for
PostgreSQL (supported version)
ii postgresql-contrib-9.6
9.6.14-1.pgdg18.04+1 amd64 additional
facilities for PostgreSQL
ii postgresql-doc 11+201.pgdg18.04+1
all documentation for the
PostgreSQL database management system
ii postgresql-doc-11 11.4-1.pgdg18.04+1
all documentation for the
PostgreSQL database management system
ii postgresql-doc-9.4
9.4.23-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-doc-9.5
9.5.18-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-doc-9.6
9.6.14-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-server-dev-11 11.4-1.pgdg18.04+1
amd64 development files for
PostgreSQL 11 server-side programming
ii postgresql-server-dev-9.4
9.4.23-1.pgdg18.04+1 amd64
development files for PostgreSQL 9.4 server-side programming
ii postgresql-server-dev-9.6
9.6.14-1.pgdg18.04+1 amd64
development files for PostgreSQL 9.6 server-side programming
Ver Cluster Port Status Owner Data directory Log file
9.3 main 5432 down <unknown> /var/lib/postgresql/9.3/main
/var/log/postgresql/postgresql-9.3-main.log
9.4 main 5433 down <unknown> /var/lib/postgresql/9.4/main
/var/log/postgresql/postgresql-9.4-main.log
9.5 main 5433 down <unknown> /var/lib/postgresql/9.5/main
/var/log/postgresql/postgresql-9.5-main.log
9.6 main 5435 online postgres /var/lib/postgresql/9.6/main
/var/log/postgresql/postgresql-9.6-main.log
11 main 5432 online postgres /var/lib/postgresql/11/main
/var/log/postgresql/postgresql-11-main.log
…On Thu, Jul 4, 2019 at 4:18 PM Arne Solli ***@***.***> wrote:
Yes, it was because I purged version 9.6 in order to remove the old
pg_config, then installed developer version of 11 to get the correct
pg_config. Then I checked that all references in the compile / link was to
11, not to 9.6. The first time I compiled&linked all references was to
9.6. So perhaps there are some files that has not been deleted since I
compiled the first times using the wrong pg_config
Arne
On Thu, Jul 4, 2019 at 4:07 PM Euler Taveira de Oliveira <
***@***.***> wrote:
> Seems like port is wrong. I am upgradeing from 9.6 to 11. The old 9.6 is
> on
> 5432 and version 11 is on 5435. It was a problem that postgres11 did not
> install pg_config, so I had to install the postgres11-server-devel in
> order
> to get pg_config for version 11.
>
> It does not matter if you have multiple postgres versions. However, while
> build/install pg_similarity you have to make sure the *right* pg_config
> is in your PATH ( pg_config --version ).
>
> —
> You are receiving this because you were mentioned.
> Reply to this email directly, view it on GitHub
> <#18?email_source=notifications&email_token=AAA3CORGZRAO7EWYQZ4VB6DP5X72TA5CNFSM4EKLTQKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZHQKGA#issuecomment-508495128>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/AAA3COVPELR7LT5ZHVMPHYTP5X72TANCNFSM4EKLTQKA>
> .
>
--
AS
--
AS
sollimeister commented
Here is an updated version of the postgres packages. Removed and updated,
so I think maybe I got some updates
arne@geoserv:/etc/postgresql/11/main$ dpkg -l | grep postgresql
ii libpostgresql-jdbc-java
42.2.5-2.pgdg18.04+1 all Java
database (JDBC) driver for PostgreSQL
ii libreoffice-sdbc-postgresql
1:6.0.7-0ubuntu0.18.04.7 amd64
PostgreSQL SDBC driver for LibreOffice
ii pgdg-keyring 2018.2
all keyring for apt.postgresql.org
ii postgresql 11+201.pgdg18.04+1
all object-relational SQL
database (supported version)
ii postgresql-11 11.4-1.pgdg18.04+1
amd64 object-relational SQL
database, version 11 server
ii postgresql-11-postgis-2.5
2.5.2+dfsg-1~exp1.pgdg18.04+1 amd64
Geographic objects support for PostgreSQL 11
ii postgresql-11-postgis-2.5-scripts
2.5.2+dfsg-1~exp1.pgdg18.04+1 all
Geographic objects support for PostgreSQL 11 -- SQL scripts
rc postgresql-9.4
9.4.20-1.pgdg14.04+1 amd64
object-relational SQL database, version 9.4 server
ii postgresql-9.4-postgis-2.3-scripts
2.3.3+dfsg-1.pgdg14.04+1 all Geographic
objects support for PostgreSQL 9.4 -- scripts
ii postgresql-9.6
9.6.14-1.pgdg18.04+1 amd64
object-relational SQL database, version 9.6 server
ii postgresql-9.6-postgis-2.4
2.4.4+dfsg-4.pgdg18.04+1 amd64 Geographic
objects support for PostgreSQL 9.6
ii postgresql-9.6-postgis-2.4-scripts
2.4.4+dfsg-4.pgdg18.04+1 all Geographic
objects support for PostgreSQL 9.6 -- SQL scripts
ii postgresql-client-11 11.4-1.pgdg18.04+1
amd64 front-end programs for
PostgreSQL 11
ii postgresql-client-9.4
9.4.23-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.4
ii postgresql-client-9.6
9.6.14-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.6
ii postgresql-client-common 201.pgdg18.04+1
all manager for multiple
PostgreSQL client versions
ii postgresql-common 201.pgdg18.04+1
all PostgreSQL database-cluster
manager
ii postgresql-contrib 11+201.pgdg18.04+1
all additional facilities for
PostgreSQL (supported version)
ii postgresql-contrib-9.6
9.6.14-1.pgdg18.04+1 amd64 additional
facilities for PostgreSQL
ii postgresql-doc 11+201.pgdg18.04+1
all documentation for the
PostgreSQL database management system
ii postgresql-doc-11 11.4-1.pgdg18.04+1
all documentation for the
PostgreSQL database management system
ii postgresql-doc-9.4
9.4.23-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-doc-9.6
9.6.14-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-server-dev-11 11.4-1.pgdg18.04+1
amd64 development files for
PostgreSQL 11 server-side programming
ii postgresql-server-dev-9.4
9.4.23-1.pgdg18.04+1 amd64
development files for PostgreSQL 9.4 server-side programming
ii postgresql-server-dev-9.6
9.6.14-1.pgdg18.04+1 amd64
development files for PostgreSQL 9.6 server-side programming
…On Thu, Jul 4, 2019 at 4:26 PM Arne Solli ***@***.***> wrote:
***@***.***:/etc/postgresql/11/main$ dpkg -l | grep postgresql
ii libpostgresql-jdbc-java
42.2.5-2.pgdg18.04+1 all Java
database (JDBC) driver for PostgreSQL
ii libreoffice-sdbc-postgresql
1:6.0.7-0ubuntu0.18.04.6 amd64
PostgreSQL SDBC driver for LibreOffice
ii pgdg-keyring 2018.2
all keyring for
apt.postgresql.org
ii postgresql
11+201.pgdg18.04+1 all
object-relational SQL database (supported version)
ii postgresql-10-postgis-2.4-scripts
2.4.4+dfsg-4.pgdg18.04+1 all
Geographic objects support for PostgreSQL 10 -- SQL scripts
ii postgresql-11
11.4-1.pgdg18.04+1 amd64
object-relational SQL database, version 11 server
ii postgresql-11-postgis-2.5
2.5.2+dfsg-1~exp1.pgdg18.04+1 amd64
Geographic objects support for PostgreSQL 11
ii postgresql-11-postgis-2.5-scripts
2.5.2+dfsg-1~exp1.pgdg18.04+1 all
Geographic objects support for PostgreSQL 11 -- SQL scripts
rc postgresql-9.3
9.3.25-1.pgdg14.04+1 amd64
object-relational SQL database, version 9.3 server
rc postgresql-9.4
9.4.20-1.pgdg14.04+1 amd64
object-relational SQL database, version 9.4 server
ii postgresql-9.4-postgis-2.3-scripts
2.3.3+dfsg-1.pgdg14.04+1 all Geographic
objects support for PostgreSQL 9.4 -- scripts
rc postgresql-9.5
9.5.15-1.pgdg14.04+1 amd64
object-relational SQL database, version 9.5 server
ii postgresql-9.6
9.6.14-1.pgdg18.04+1 amd64
object-relational SQL database, version 9.6 server
ii postgresql-9.6-postgis-2.4
2.4.4+dfsg-4.pgdg18.04+1 amd64 Geographic
objects support for PostgreSQL 9.6
ii postgresql-9.6-postgis-2.4-scripts
2.4.4+dfsg-4.pgdg18.04+1 all Geographic
objects support for PostgreSQL 9.6 -- SQL scripts
ii postgresql-client-10
10.9-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 10
ii postgresql-client-11
11.4-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 11
ii postgresql-client-9.3
9.3.25-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.3
ii postgresql-client-9.4
9.4.23-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.4
ii postgresql-client-9.5
9.5.18-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.5
ii postgresql-client-9.6
9.6.14-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.6
ii postgresql-client-common 201.pgdg18.04+1
all manager for multiple
PostgreSQL client versions
ii postgresql-common 201.pgdg18.04+1
all PostgreSQL database-cluster
manager
ii postgresql-contrib
11+201.pgdg18.04+1 all additional
facilities for PostgreSQL (supported version)
ii postgresql-contrib-9.6
9.6.14-1.pgdg18.04+1 amd64 additional
facilities for PostgreSQL
ii postgresql-doc
11+201.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-doc-11
11.4-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-doc-9.4
9.4.23-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-doc-9.5
9.5.18-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-doc-9.6
9.6.14-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-server-dev-11
11.4-1.pgdg18.04+1 amd64
development files for PostgreSQL 11 server-side programming
ii postgresql-server-dev-9.4
9.4.23-1.pgdg18.04+1 amd64
development files for PostgreSQL 9.4 server-side programming
ii postgresql-server-dev-9.6
9.6.14-1.pgdg18.04+1 amd64
development files for PostgreSQL 9.6 server-side programming
Ver Cluster Port Status Owner Data directory Log file
9.3 main 5432 down <unknown> /var/lib/postgresql/9.3/main
/var/log/postgresql/postgresql-9.3-main.log
9.4 main 5433 down <unknown> /var/lib/postgresql/9.4/main
/var/log/postgresql/postgresql-9.4-main.log
9.5 main 5433 down <unknown> /var/lib/postgresql/9.5/main
/var/log/postgresql/postgresql-9.5-main.log
9.6 main 5435 online postgres /var/lib/postgresql/9.6/main
/var/log/postgresql/postgresql-9.6-main.log
11 main 5432 online postgres /var/lib/postgresql/11/main
/var/log/postgresql/postgresql-11-main.log
On Thu, Jul 4, 2019 at 4:18 PM Arne Solli ***@***.***> wrote:
> Yes, it was because I purged version 9.6 in order to remove the old
> pg_config, then installed developer version of 11 to get the correct
> pg_config. Then I checked that all references in the compile / link was to
> 11, not to 9.6. The first time I compiled&linked all references was to
> 9.6. So perhaps there are some files that has not been deleted since I
> compiled the first times using the wrong pg_config
>
> Arne
>
> On Thu, Jul 4, 2019 at 4:07 PM Euler Taveira de Oliveira <
> ***@***.***> wrote:
>
>> Seems like port is wrong. I am upgradeing from 9.6 to 11. The old 9.6 is
>> on
>> 5432 and version 11 is on 5435. It was a problem that postgres11 did not
>> install pg_config, so I had to install the postgres11-server-devel in
>> order
>> to get pg_config for version 11.
>>
>> It does not matter if you have multiple postgres versions. However,
>> while build/install pg_similarity you have to make sure the *right*
>> pg_config is in your PATH ( pg_config --version ).
>>
>> —
>> You are receiving this because you were mentioned.
>> Reply to this email directly, view it on GitHub
>> <#18?email_source=notifications&email_token=AAA3CORGZRAO7EWYQZ4VB6DP5X72TA5CNFSM4EKLTQKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZHQKGA#issuecomment-508495128>,
>> or mute the thread
>> <https://github.com/notifications/unsubscribe-auth/AAA3COVPELR7LT5ZHVMPHYTP5X72TANCNFSM4EKLTQKA>
>> .
>>
>
>
> --
> AS
>
--
AS
--
AS
sollimeister commented
Output from pg_config (version 11)
$ pg_config
BINDIR = /usr/lib/postgresql/11/bin
DOCDIR = /usr/share/doc/postgresql-doc-11
HTMLDIR = /usr/share/doc/postgresql-doc-11
INCLUDEDIR = /usr/include/postgresql
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/11/server
LIBDIR = /usr/lib/x86_64-linux-gnu
PKGLIBDIR = /usr/lib/postgresql/11/lib
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/postgresql/11/man
SHAREDIR = /usr/share/postgresql/11
SYSCONFDIR = /etc/postgresql-common
PGXS = /usr/lib/postgresql/11/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--build=x86_64-linux-gnu' '--prefix=/usr'
'--includedir=/usr/include' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--sysconfdir=/etc' '--localstatedir=/var'
'--disable-silent-rules' '--libdir=/usr/lib/x86_64-linux-gnu'
'--libexecdir=/usr/lib/x86_64-linux-gnu' '--disable-maintainer-mode'
'--disable-dependency-tracking' '--with-icu' '--with-tcl' '--with-perl'
'--with-python' '--with-pam' '--with-openssl' '--with-libxml'
'--with-libxslt' 'PYTHON=/usr/bin/python'
'--mandir=/usr/share/postgresql/11/man'
'--docdir=/usr/share/doc/postgresql-doc-11'
'--sysconfdir=/etc/postgresql-common' '--datarootdir=/usr/share/'
'--datadir=/usr/share/postgresql/11' '--bindir=/usr/lib/postgresql/11/bin'
'--libdir=/usr/lib/x86_64-linux-gnu/' '--libexecdir=/usr/lib/postgresql/'
'--includedir=/usr/include/postgresql/' '--with-extra-version= (Ubuntu
11.4-1.pgdg18.04+1)' '--enable-nls' '--enable-integer-datetimes'
'--enable-thread-safety' '--enable-tap-tests' '--enable-debug'
'--enable-dtrace' '--disable-rpath' '--with-uuid=e2fs' '--with-gnu-ld'
'--with-pgport=5432' '--with-system-tzdata=/usr/share/zoneinfo'
'--with-llvm' '--with-systemd' '--with-selinux' 'MKDIR_P=/bin/mkdir -p'
'TAR=/bin/tar' 'CFLAGS=-g -O2 -fstack-protector-strong -Wformat
-Werror=format-security -fno-omit-frame-pointer'
'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now' '--with-gssapi'
'--with-ldap' '--with-includes=/usr/include/mit-krb5'
'--with-libs=/usr/lib/mit-krb5'
'--with-libs=/usr/lib/x86_64-linux-gnu/mit-krb5'
'build_alias=x86_64-linux-gnu' 'CPPFLAGS=-Wdate-time -D_FORTIFY_SOURCE=2'
'CXXFLAGS=-g -O2 -fstack-protector-strong -Wformat -Werror=format-security'
CC = gcc
CPPFLAGS = -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE
-I/usr/include/libxml2 -I/usr/include/mit-krb5
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
-Wno-format-truncation -g -g -O2 -fstack-protector-strong -Wformat
-Werror=format-security -fno-omit-frame-pointer
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now
-L/usr/lib/llvm-6.0/lib -L/usr/lib/x86_64-linux-gnu/mit-krb5 -Wl,--as-needed
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lpthread -lselinux -lxslt -lxml2 -lpam -lssl
-lcrypto -lgssapi_krb5 -lz -ledit -lrt -lcrypt -ldl -lm
VERSION = PostgreSQL 11.4 (Ubuntu 11.4-1.pgdg18.04+1)
$
…On Thu, Jul 4, 2019 at 4:40 PM Arne Solli ***@***.***> wrote:
Here is an updated version of the postgres packages. Removed and updated,
so I think maybe I got some updates
***@***.***:/etc/postgresql/11/main$ dpkg -l | grep postgresql
ii libpostgresql-jdbc-java
42.2.5-2.pgdg18.04+1 all Java
database (JDBC) driver for PostgreSQL
ii libreoffice-sdbc-postgresql
1:6.0.7-0ubuntu0.18.04.7 amd64
PostgreSQL SDBC driver for LibreOffice
ii pgdg-keyring 2018.2
all keyring for
apt.postgresql.org
ii postgresql
11+201.pgdg18.04+1 all
object-relational SQL database (supported version)
ii postgresql-11
11.4-1.pgdg18.04+1 amd64
object-relational SQL database, version 11 server
ii postgresql-11-postgis-2.5
2.5.2+dfsg-1~exp1.pgdg18.04+1 amd64
Geographic objects support for PostgreSQL 11
ii postgresql-11-postgis-2.5-scripts
2.5.2+dfsg-1~exp1.pgdg18.04+1 all
Geographic objects support for PostgreSQL 11 -- SQL scripts
rc postgresql-9.4
9.4.20-1.pgdg14.04+1 amd64
object-relational SQL database, version 9.4 server
ii postgresql-9.4-postgis-2.3-scripts
2.3.3+dfsg-1.pgdg14.04+1 all Geographic
objects support for PostgreSQL 9.4 -- scripts
ii postgresql-9.6
9.6.14-1.pgdg18.04+1 amd64
object-relational SQL database, version 9.6 server
ii postgresql-9.6-postgis-2.4
2.4.4+dfsg-4.pgdg18.04+1 amd64 Geographic
objects support for PostgreSQL 9.6
ii postgresql-9.6-postgis-2.4-scripts
2.4.4+dfsg-4.pgdg18.04+1 all Geographic
objects support for PostgreSQL 9.6 -- SQL scripts
ii postgresql-client-11
11.4-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 11
ii postgresql-client-9.4
9.4.23-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.4
ii postgresql-client-9.6
9.6.14-1.pgdg18.04+1 amd64 front-end
programs for PostgreSQL 9.6
ii postgresql-client-common 201.pgdg18.04+1
all manager for multiple
PostgreSQL client versions
ii postgresql-common 201.pgdg18.04+1
all PostgreSQL database-cluster
manager
ii postgresql-contrib
11+201.pgdg18.04+1 all additional
facilities for PostgreSQL (supported version)
ii postgresql-contrib-9.6
9.6.14-1.pgdg18.04+1 amd64 additional
facilities for PostgreSQL
ii postgresql-doc
11+201.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-doc-11
11.4-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-doc-9.4
9.4.23-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-doc-9.6
9.6.14-1.pgdg18.04+1 all
documentation for the PostgreSQL database management system
ii postgresql-server-dev-11
11.4-1.pgdg18.04+1 amd64
development files for PostgreSQL 11 server-side programming
ii postgresql-server-dev-9.4
9.4.23-1.pgdg18.04+1 amd64
development files for PostgreSQL 9.4 server-side programming
ii postgresql-server-dev-9.6
9.6.14-1.pgdg18.04+1 amd64
development files for PostgreSQL 9.6 server-side programming
On Thu, Jul 4, 2019 at 4:26 PM Arne Solli ***@***.***> wrote:
> ***@***.***:/etc/postgresql/11/main$ dpkg -l | grep postgresql
> ii libpostgresql-jdbc-java
> 42.2.5-2.pgdg18.04+1 all Java
> database (JDBC) driver for PostgreSQL
> ii libreoffice-sdbc-postgresql
> 1:6.0.7-0ubuntu0.18.04.6 amd64
> PostgreSQL SDBC driver for LibreOffice
> ii pgdg-keyring 2018.2
> all keyring for
> apt.postgresql.org
> ii postgresql
> 11+201.pgdg18.04+1 all
> object-relational SQL database (supported version)
> ii postgresql-10-postgis-2.4-scripts
> 2.4.4+dfsg-4.pgdg18.04+1 all
> Geographic objects support for PostgreSQL 10 -- SQL scripts
> ii postgresql-11
> 11.4-1.pgdg18.04+1 amd64
> object-relational SQL database, version 11 server
> ii postgresql-11-postgis-2.5
> 2.5.2+dfsg-1~exp1.pgdg18.04+1 amd64
> Geographic objects support for PostgreSQL 11
> ii postgresql-11-postgis-2.5-scripts
> 2.5.2+dfsg-1~exp1.pgdg18.04+1 all
> Geographic objects support for PostgreSQL 11 -- SQL scripts
> rc postgresql-9.3
> 9.3.25-1.pgdg14.04+1 amd64
> object-relational SQL database, version 9.3 server
> rc postgresql-9.4
> 9.4.20-1.pgdg14.04+1 amd64
> object-relational SQL database, version 9.4 server
> ii postgresql-9.4-postgis-2.3-scripts
> 2.3.3+dfsg-1.pgdg14.04+1 all Geographic
> objects support for PostgreSQL 9.4 -- scripts
> rc postgresql-9.5
> 9.5.15-1.pgdg14.04+1 amd64
> object-relational SQL database, version 9.5 server
> ii postgresql-9.6
> 9.6.14-1.pgdg18.04+1 amd64
> object-relational SQL database, version 9.6 server
> ii postgresql-9.6-postgis-2.4
> 2.4.4+dfsg-4.pgdg18.04+1 amd64 Geographic
> objects support for PostgreSQL 9.6
> ii postgresql-9.6-postgis-2.4-scripts
> 2.4.4+dfsg-4.pgdg18.04+1 all Geographic
> objects support for PostgreSQL 9.6 -- SQL scripts
> ii postgresql-client-10
> 10.9-1.pgdg18.04+1 amd64 front-end
> programs for PostgreSQL 10
> ii postgresql-client-11
> 11.4-1.pgdg18.04+1 amd64 front-end
> programs for PostgreSQL 11
> ii postgresql-client-9.3
> 9.3.25-1.pgdg18.04+1 amd64 front-end
> programs for PostgreSQL 9.3
> ii postgresql-client-9.4
> 9.4.23-1.pgdg18.04+1 amd64 front-end
> programs for PostgreSQL 9.4
> ii postgresql-client-9.5
> 9.5.18-1.pgdg18.04+1 amd64 front-end
> programs for PostgreSQL 9.5
> ii postgresql-client-9.6
> 9.6.14-1.pgdg18.04+1 amd64 front-end
> programs for PostgreSQL 9.6
> ii postgresql-client-common 201.pgdg18.04+1
> all manager for multiple
> PostgreSQL client versions
> ii postgresql-common 201.pgdg18.04+1
> all PostgreSQL
> database-cluster manager
> ii postgresql-contrib
> 11+201.pgdg18.04+1 all additional
> facilities for PostgreSQL (supported version)
> ii postgresql-contrib-9.6
> 9.6.14-1.pgdg18.04+1 amd64 additional
> facilities for PostgreSQL
> ii postgresql-doc
> 11+201.pgdg18.04+1 all
> documentation for the PostgreSQL database management system
> ii postgresql-doc-11
> 11.4-1.pgdg18.04+1 all
> documentation for the PostgreSQL database management system
> ii postgresql-doc-9.4
> 9.4.23-1.pgdg18.04+1 all
> documentation for the PostgreSQL database management system
> ii postgresql-doc-9.5
> 9.5.18-1.pgdg18.04+1 all
> documentation for the PostgreSQL database management system
> ii postgresql-doc-9.6
> 9.6.14-1.pgdg18.04+1 all
> documentation for the PostgreSQL database management system
> ii postgresql-server-dev-11
> 11.4-1.pgdg18.04+1 amd64
> development files for PostgreSQL 11 server-side programming
> ii postgresql-server-dev-9.4
> 9.4.23-1.pgdg18.04+1 amd64
> development files for PostgreSQL 9.4 server-side programming
> ii postgresql-server-dev-9.6
> 9.6.14-1.pgdg18.04+1 amd64
> development files for PostgreSQL 9.6 server-side programming
>
> Ver Cluster Port Status Owner Data directory Log file
> 9.3 main 5432 down <unknown> /var/lib/postgresql/9.3/main
> /var/log/postgresql/postgresql-9.3-main.log
> 9.4 main 5433 down <unknown> /var/lib/postgresql/9.4/main
> /var/log/postgresql/postgresql-9.4-main.log
> 9.5 main 5433 down <unknown> /var/lib/postgresql/9.5/main
> /var/log/postgresql/postgresql-9.5-main.log
> 9.6 main 5435 online postgres /var/lib/postgresql/9.6/main
> /var/log/postgresql/postgresql-9.6-main.log
> 11 main 5432 online postgres /var/lib/postgresql/11/main
> /var/log/postgresql/postgresql-11-main.log
>
>
>
> On Thu, Jul 4, 2019 at 4:18 PM Arne Solli ***@***.***> wrote:
>
>> Yes, it was because I purged version 9.6 in order to remove the old
>> pg_config, then installed developer version of 11 to get the correct
>> pg_config. Then I checked that all references in the compile / link was to
>> 11, not to 9.6. The first time I compiled&linked all references was to
>> 9.6. So perhaps there are some files that has not been deleted since I
>> compiled the first times using the wrong pg_config
>>
>> Arne
>>
>> On Thu, Jul 4, 2019 at 4:07 PM Euler Taveira de Oliveira <
>> ***@***.***> wrote:
>>
>>> Seems like port is wrong. I am upgradeing from 9.6 to 11. The old 9.6
>>> is on
>>> 5432 and version 11 is on 5435. It was a problem that postgres11 did not
>>> install pg_config, so I had to install the postgres11-server-devel in
>>> order
>>> to get pg_config for version 11.
>>>
>>> It does not matter if you have multiple postgres versions. However,
>>> while build/install pg_similarity you have to make sure the *right*
>>> pg_config is in your PATH ( pg_config --version ).
>>>
>>> —
>>> You are receiving this because you were mentioned.
>>> Reply to this email directly, view it on GitHub
>>> <#18?email_source=notifications&email_token=AAA3CORGZRAO7EWYQZ4VB6DP5X72TA5CNFSM4EKLTQKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZHQKGA#issuecomment-508495128>,
>>> or mute the thread
>>> <https://github.com/notifications/unsubscribe-auth/AAA3COVPELR7LT5ZHVMPHYTP5X72TANCNFSM4EKLTQKA>
>>> .
>>>
>>
>>
>> --
>> AS
>>
>
>
> --
> AS
>
--
AS
--
AS
sollimeister commented
Hi
Updated I tried again, but still
postgres=# create extension pg_similarity;
2019-07-04 16:47:28 CEST ERROR: could not load library
"/usr/lib/postgresql/11/lib/pg_similarity.so":
/usr/lib/postgresql/11/lib/pg_similarity.so: undefined symbol:
Float8GetDatum
2019-07-04 16:47:28 CEST STATEMENT: create extension pg_similarity;
ERROR: could not load library
"/usr/lib/postgresql/11/lib/pg_similarity.so":
/usr/lib/postgresql/11/lib/pg_similarity.so: undefined symbol:
Float8GetDatum
postgres=#
…On Thu, Jul 4, 2019 at 4:43 PM Arne Solli ***@***.***> wrote:
Output from pg_config (version 11)
$ pg_config
BINDIR = /usr/lib/postgresql/11/bin
DOCDIR = /usr/share/doc/postgresql-doc-11
HTMLDIR = /usr/share/doc/postgresql-doc-11
INCLUDEDIR = /usr/include/postgresql
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/11/server
LIBDIR = /usr/lib/x86_64-linux-gnu
PKGLIBDIR = /usr/lib/postgresql/11/lib
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/postgresql/11/man
SHAREDIR = /usr/share/postgresql/11
SYSCONFDIR = /etc/postgresql-common
PGXS = /usr/lib/postgresql/11/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--build=x86_64-linux-gnu' '--prefix=/usr'
'--includedir=/usr/include' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--sysconfdir=/etc' '--localstatedir=/var'
'--disable-silent-rules' '--libdir=/usr/lib/x86_64-linux-gnu'
'--libexecdir=/usr/lib/x86_64-linux-gnu' '--disable-maintainer-mode'
'--disable-dependency-tracking' '--with-icu' '--with-tcl' '--with-perl'
'--with-python' '--with-pam' '--with-openssl' '--with-libxml'
'--with-libxslt' 'PYTHON=/usr/bin/python'
'--mandir=/usr/share/postgresql/11/man'
'--docdir=/usr/share/doc/postgresql-doc-11'
'--sysconfdir=/etc/postgresql-common' '--datarootdir=/usr/share/'
'--datadir=/usr/share/postgresql/11' '--bindir=/usr/lib/postgresql/11/bin'
'--libdir=/usr/lib/x86_64-linux-gnu/' '--libexecdir=/usr/lib/postgresql/'
'--includedir=/usr/include/postgresql/' '--with-extra-version= (Ubuntu
11.4-1.pgdg18.04+1)' '--enable-nls' '--enable-integer-datetimes'
'--enable-thread-safety' '--enable-tap-tests' '--enable-debug'
'--enable-dtrace' '--disable-rpath' '--with-uuid=e2fs' '--with-gnu-ld'
'--with-pgport=5432' '--with-system-tzdata=/usr/share/zoneinfo'
'--with-llvm' '--with-systemd' '--with-selinux' 'MKDIR_P=/bin/mkdir -p'
'TAR=/bin/tar' 'CFLAGS=-g -O2 -fstack-protector-strong -Wformat
-Werror=format-security -fno-omit-frame-pointer'
'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now' '--with-gssapi'
'--with-ldap' '--with-includes=/usr/include/mit-krb5'
'--with-libs=/usr/lib/mit-krb5'
'--with-libs=/usr/lib/x86_64-linux-gnu/mit-krb5'
'build_alias=x86_64-linux-gnu' 'CPPFLAGS=-Wdate-time -D_FORTIFY_SOURCE=2'
'CXXFLAGS=-g -O2 -fstack-protector-strong -Wformat -Werror=format-security'
CC = gcc
CPPFLAGS = -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE
-I/usr/include/libxml2 -I/usr/include/mit-krb5
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
-Wno-format-truncation -g -g -O2 -fstack-protector-strong -Wformat
-Werror=format-security -fno-omit-frame-pointer
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now
-L/usr/lib/llvm-6.0/lib -L/usr/lib/x86_64-linux-gnu/mit-krb5 -Wl,--as-needed
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lpthread -lselinux -lxslt -lxml2 -lpam -lssl
-lcrypto -lgssapi_krb5 -lz -ledit -lrt -lcrypt -ldl -lm
VERSION = PostgreSQL 11.4 (Ubuntu 11.4-1.pgdg18.04+1)
$
On Thu, Jul 4, 2019 at 4:40 PM Arne Solli ***@***.***> wrote:
> Here is an updated version of the postgres packages. Removed and updated,
> so I think maybe I got some updates
> ***@***.***:/etc/postgresql/11/main$ dpkg -l | grep postgresql
> ii libpostgresql-jdbc-java
> 42.2.5-2.pgdg18.04+1 all Java
> database (JDBC) driver for PostgreSQL
> ii libreoffice-sdbc-postgresql
> 1:6.0.7-0ubuntu0.18.04.7 amd64
> PostgreSQL SDBC driver for LibreOffice
> ii pgdg-keyring 2018.2
> all keyring for
> apt.postgresql.org
> ii postgresql
> 11+201.pgdg18.04+1 all
> object-relational SQL database (supported version)
> ii postgresql-11
> 11.4-1.pgdg18.04+1 amd64
> object-relational SQL database, version 11 server
> ii postgresql-11-postgis-2.5
> 2.5.2+dfsg-1~exp1.pgdg18.04+1 amd64
> Geographic objects support for PostgreSQL 11
> ii postgresql-11-postgis-2.5-scripts
> 2.5.2+dfsg-1~exp1.pgdg18.04+1 all
> Geographic objects support for PostgreSQL 11 -- SQL scripts
> rc postgresql-9.4
> 9.4.20-1.pgdg14.04+1 amd64
> object-relational SQL database, version 9.4 server
> ii postgresql-9.4-postgis-2.3-scripts
> 2.3.3+dfsg-1.pgdg14.04+1 all Geographic
> objects support for PostgreSQL 9.4 -- scripts
> ii postgresql-9.6
> 9.6.14-1.pgdg18.04+1 amd64
> object-relational SQL database, version 9.6 server
> ii postgresql-9.6-postgis-2.4
> 2.4.4+dfsg-4.pgdg18.04+1 amd64 Geographic
> objects support for PostgreSQL 9.6
> ii postgresql-9.6-postgis-2.4-scripts
> 2.4.4+dfsg-4.pgdg18.04+1 all Geographic
> objects support for PostgreSQL 9.6 -- SQL scripts
> ii postgresql-client-11
> 11.4-1.pgdg18.04+1 amd64 front-end
> programs for PostgreSQL 11
> ii postgresql-client-9.4
> 9.4.23-1.pgdg18.04+1 amd64 front-end
> programs for PostgreSQL 9.4
> ii postgresql-client-9.6
> 9.6.14-1.pgdg18.04+1 amd64 front-end
> programs for PostgreSQL 9.6
> ii postgresql-client-common 201.pgdg18.04+1
> all manager for multiple
> PostgreSQL client versions
> ii postgresql-common 201.pgdg18.04+1
> all PostgreSQL
> database-cluster manager
> ii postgresql-contrib
> 11+201.pgdg18.04+1 all additional
> facilities for PostgreSQL (supported version)
> ii postgresql-contrib-9.6
> 9.6.14-1.pgdg18.04+1 amd64 additional
> facilities for PostgreSQL
> ii postgresql-doc
> 11+201.pgdg18.04+1 all
> documentation for the PostgreSQL database management system
> ii postgresql-doc-11
> 11.4-1.pgdg18.04+1 all
> documentation for the PostgreSQL database management system
> ii postgresql-doc-9.4
> 9.4.23-1.pgdg18.04+1 all
> documentation for the PostgreSQL database management system
> ii postgresql-doc-9.6
> 9.6.14-1.pgdg18.04+1 all
> documentation for the PostgreSQL database management system
> ii postgresql-server-dev-11
> 11.4-1.pgdg18.04+1 amd64
> development files for PostgreSQL 11 server-side programming
> ii postgresql-server-dev-9.4
> 9.4.23-1.pgdg18.04+1 amd64
> development files for PostgreSQL 9.4 server-side programming
> ii postgresql-server-dev-9.6
> 9.6.14-1.pgdg18.04+1 amd64
> development files for PostgreSQL 9.6 server-side programming
>
>
> On Thu, Jul 4, 2019 at 4:26 PM Arne Solli ***@***.***> wrote:
>
>> ***@***.***:/etc/postgresql/11/main$ dpkg -l | grep postgresql
>> ii libpostgresql-jdbc-java
>> 42.2.5-2.pgdg18.04+1 all Java
>> database (JDBC) driver for PostgreSQL
>> ii libreoffice-sdbc-postgresql
>> 1:6.0.7-0ubuntu0.18.04.6 amd64
>> PostgreSQL SDBC driver for LibreOffice
>> ii pgdg-keyring 2018.2
>> all keyring for
>> apt.postgresql.org
>> ii postgresql
>> 11+201.pgdg18.04+1 all
>> object-relational SQL database (supported version)
>> ii postgresql-10-postgis-2.4-scripts
>> 2.4.4+dfsg-4.pgdg18.04+1 all
>> Geographic objects support for PostgreSQL 10 -- SQL scripts
>> ii postgresql-11
>> 11.4-1.pgdg18.04+1 amd64
>> object-relational SQL database, version 11 server
>> ii postgresql-11-postgis-2.5
>> 2.5.2+dfsg-1~exp1.pgdg18.04+1 amd64
>> Geographic objects support for PostgreSQL 11
>> ii postgresql-11-postgis-2.5-scripts
>> 2.5.2+dfsg-1~exp1.pgdg18.04+1 all
>> Geographic objects support for PostgreSQL 11 -- SQL scripts
>> rc postgresql-9.3
>> 9.3.25-1.pgdg14.04+1 amd64
>> object-relational SQL database, version 9.3 server
>> rc postgresql-9.4
>> 9.4.20-1.pgdg14.04+1 amd64
>> object-relational SQL database, version 9.4 server
>> ii postgresql-9.4-postgis-2.3-scripts
>> 2.3.3+dfsg-1.pgdg14.04+1 all Geographic
>> objects support for PostgreSQL 9.4 -- scripts
>> rc postgresql-9.5
>> 9.5.15-1.pgdg14.04+1 amd64
>> object-relational SQL database, version 9.5 server
>> ii postgresql-9.6
>> 9.6.14-1.pgdg18.04+1 amd64
>> object-relational SQL database, version 9.6 server
>> ii postgresql-9.6-postgis-2.4
>> 2.4.4+dfsg-4.pgdg18.04+1 amd64 Geographic
>> objects support for PostgreSQL 9.6
>> ii postgresql-9.6-postgis-2.4-scripts
>> 2.4.4+dfsg-4.pgdg18.04+1 all Geographic
>> objects support for PostgreSQL 9.6 -- SQL scripts
>> ii postgresql-client-10
>> 10.9-1.pgdg18.04+1 amd64 front-end
>> programs for PostgreSQL 10
>> ii postgresql-client-11
>> 11.4-1.pgdg18.04+1 amd64 front-end
>> programs for PostgreSQL 11
>> ii postgresql-client-9.3
>> 9.3.25-1.pgdg18.04+1 amd64 front-end
>> programs for PostgreSQL 9.3
>> ii postgresql-client-9.4
>> 9.4.23-1.pgdg18.04+1 amd64 front-end
>> programs for PostgreSQL 9.4
>> ii postgresql-client-9.5
>> 9.5.18-1.pgdg18.04+1 amd64 front-end
>> programs for PostgreSQL 9.5
>> ii postgresql-client-9.6
>> 9.6.14-1.pgdg18.04+1 amd64 front-end
>> programs for PostgreSQL 9.6
>> ii postgresql-client-common 201.pgdg18.04+1
>> all manager for multiple
>> PostgreSQL client versions
>> ii postgresql-common 201.pgdg18.04+1
>> all PostgreSQL
>> database-cluster manager
>> ii postgresql-contrib
>> 11+201.pgdg18.04+1 all additional
>> facilities for PostgreSQL (supported version)
>> ii postgresql-contrib-9.6
>> 9.6.14-1.pgdg18.04+1 amd64 additional
>> facilities for PostgreSQL
>> ii postgresql-doc
>> 11+201.pgdg18.04+1 all
>> documentation for the PostgreSQL database management system
>> ii postgresql-doc-11
>> 11.4-1.pgdg18.04+1 all
>> documentation for the PostgreSQL database management system
>> ii postgresql-doc-9.4
>> 9.4.23-1.pgdg18.04+1 all
>> documentation for the PostgreSQL database management system
>> ii postgresql-doc-9.5
>> 9.5.18-1.pgdg18.04+1 all
>> documentation for the PostgreSQL database management system
>> ii postgresql-doc-9.6
>> 9.6.14-1.pgdg18.04+1 all
>> documentation for the PostgreSQL database management system
>> ii postgresql-server-dev-11
>> 11.4-1.pgdg18.04+1 amd64
>> development files for PostgreSQL 11 server-side programming
>> ii postgresql-server-dev-9.4
>> 9.4.23-1.pgdg18.04+1 amd64
>> development files for PostgreSQL 9.4 server-side programming
>> ii postgresql-server-dev-9.6
>> 9.6.14-1.pgdg18.04+1 amd64
>> development files for PostgreSQL 9.6 server-side programming
>>
>> Ver Cluster Port Status Owner Data directory Log file
>> 9.3 main 5432 down <unknown> /var/lib/postgresql/9.3/main
>> /var/log/postgresql/postgresql-9.3-main.log
>> 9.4 main 5433 down <unknown> /var/lib/postgresql/9.4/main
>> /var/log/postgresql/postgresql-9.4-main.log
>> 9.5 main 5433 down <unknown> /var/lib/postgresql/9.5/main
>> /var/log/postgresql/postgresql-9.5-main.log
>> 9.6 main 5435 online postgres /var/lib/postgresql/9.6/main
>> /var/log/postgresql/postgresql-9.6-main.log
>> 11 main 5432 online postgres /var/lib/postgresql/11/main
>> /var/log/postgresql/postgresql-11-main.log
>>
>>
>>
>> On Thu, Jul 4, 2019 at 4:18 PM Arne Solli ***@***.***>
>> wrote:
>>
>>> Yes, it was because I purged version 9.6 in order to remove the old
>>> pg_config, then installed developer version of 11 to get the correct
>>> pg_config. Then I checked that all references in the compile / link was to
>>> 11, not to 9.6. The first time I compiled&linked all references was to
>>> 9.6. So perhaps there are some files that has not been deleted since I
>>> compiled the first times using the wrong pg_config
>>>
>>> Arne
>>>
>>> On Thu, Jul 4, 2019 at 4:07 PM Euler Taveira de Oliveira <
>>> ***@***.***> wrote:
>>>
>>>> Seems like port is wrong. I am upgradeing from 9.6 to 11. The old 9.6
>>>> is on
>>>> 5432 and version 11 is on 5435. It was a problem that postgres11 did
>>>> not
>>>> install pg_config, so I had to install the postgres11-server-devel in
>>>> order
>>>> to get pg_config for version 11.
>>>>
>>>> It does not matter if you have multiple postgres versions. However,
>>>> while build/install pg_similarity you have to make sure the *right*
>>>> pg_config is in your PATH ( pg_config --version ).
>>>>
>>>> —
>>>> You are receiving this because you were mentioned.
>>>> Reply to this email directly, view it on GitHub
>>>> <#18?email_source=notifications&email_token=AAA3CORGZRAO7EWYQZ4VB6DP5X72TA5CNFSM4EKLTQKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZHQKGA#issuecomment-508495128>,
>>>> or mute the thread
>>>> <https://github.com/notifications/unsubscribe-auth/AAA3COVPELR7LT5ZHVMPHYTP5X72TANCNFSM4EKLTQKA>
>>>> .
>>>>
>>>
>>>
>>> --
>>> AS
>>>
>>
>>
>> --
>> AS
>>
>
>
> --
> AS
>
--
AS
--
AS
eulerto commented
What is the make output?
Do you close this connection when you try again? Make sure postgres is using a fresh pg_similarity library (restart or simply closing all connections).
BTW, if you are using PGDB packages, why don't you use the pg_similarity package? It is called postgresql-11-similarity.
sollimeister commented
Hi
Did not know it existed! I used the pg_similarity back on postgresgl 9.3
and ubuntu 14.04. Just recently updated to 18.04 and postgres 11. Will
install the package later today. I am now in a birthday party, so i will
have a break for some time. Reporting back later today
Arne
tor. 4. jul. 2019, 17:05 skrev Euler Taveira de Oliveira <
notifications@github.com>:
… What is the make output?
Do you close this connection when you try again? Make sure postgres is
using a fresh pg_similarity library (restart or simply closing all
connections).
BTW, if you are using PGDB packages, why don't you use the pg_similarity
package? It is called postgresql-11-similarity.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#18?email_source=notifications&email_token=AAA3CORRKLYGMRGRNBH7RLLP5YGUPA5CNFSM4EKLTQKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZHUWBI#issuecomment-508513029>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AAA3COS7436G45J3XWM6OJ3P5YGUPANCNFSM4EKLTQKA>
.
sollimeister commented
postgres=# create extension pg_similarity;
CREATE EXTENSION
It works!
Thanks
Sorry for bothering you!
Arne
…On Thu, Jul 4, 2019 at 5:19 PM Arne Solli ***@***.***> wrote:
Hi
Did not know it existed! I used the pg_similarity back on postgresgl 9.3
and ubuntu 14.04. Just recently updated to 18.04 and postgres 11. Will
install the package later today. I am now in a birthday party, so i will
have a break for some time. Reporting back later today
Arne
tor. 4. jul. 2019, 17:05 skrev Euler Taveira de Oliveira <
***@***.***>:
> What is the make output?
>
> Do you close this connection when you try again? Make sure postgres is
> using a fresh pg_similarity library (restart or simply closing all
> connections).
>
> BTW, if you are using PGDB packages, why don't you use the pg_similarity
> package? It is called postgresql-11-similarity.
>
> —
> You are receiving this because you were mentioned.
> Reply to this email directly, view it on GitHub
> <#18?email_source=notifications&email_token=AAA3CORRKLYGMRGRNBH7RLLP5YGUPA5CNFSM4EKLTQKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZHUWBI#issuecomment-508513029>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/AAA3COS7436G45J3XWM6OJ3P5YGUPANCNFSM4EKLTQKA>
> .
>
--
AS