Обсуждение: Installing PostgreSQL 16 on FreeBSD 13.0

Поиск
Список
Период
Сортировка

Installing PostgreSQL 16 on FreeBSD 13.0

От
Philip Muturura
Дата:
Hello Team.

Am to install PostgreSQL 16, the new release, on my server running FreeBSD 13.

root@freeBSD-server:~ # uname -r
13.0-RELEASE-p13

However, I keep getting this error.

# wget https://www.postgresql.org/download/bsd/
ld-elf.so.1: /lib/libc.so.7: version FBSD_1.7 required by /usr/local/bin/wget not found

I have updated the system by following the official guide from the handbook: https://www.freebsd.org/releases/13.2R/installation/#install

I have also tried to do research on the error but am not successful.

Kindly assist me.




Best Regards.


Philip Ndung'u.
0727264621 
Unix is user-friendly — it's just choosy about who its friends are.

Re: Installing PostgreSQL 16 on FreeBSD 13.0

От
Thomas Munro
Дата:
On Tue, Sep 19, 2023 at 9:09 AM Philip Muturura <pndungu2006@gmail.com> wrote:
> # wget https://www.postgresql.org/download/bsd/

That's not a PostgreSQL bug, but anyway the web page you mentioned is
intended for humans to read on a web browser, and it just leads to
another page telling you to use "pkg" or build from the ports tree to
get PostgreSQL on a FreeBSD system.  Something like "pkg search
postgresql16" would be a starting point.

> ld-elf.so.1: /lib/libc.so.7: version FBSD_1.7 required by /usr/local/bin/wget not found

Perhaps because FreeBSD 13.0 is dead and you should upgrade to 13.2.



Re: Installing PostgreSQL 16 on FreeBSD 13.0

От
Philip Muturura
Дата:
Thank you for your reply,  I understand I should have may be asked this question in the FreeBSD community. 

Anyway , I had run the command you stated before asking for assistance. Seems PostgreSQL 16 is not included in the FreeBSD 13.0 repo. 

I did also try to upgrade to Release 13.2, but same error again.  




root@freeBSD-server:~ # pkg search postgresql
R-cran-RPostgreSQL-0.7.5       R Interface to the 'PostgreSQL' Database System
exim-postgresql-4.96_1         High performance MTA for Unix systems on the Internet
libgda5-postgresql-5.2.10_2    Provides postgresql access for the libgda5 library
opensmtpd-extras-table-postgresql-6.7.1,1 PostgreSQL table support for OpenSMTPD
orthanc-postgresql-4.0_5       Orthanc plugin to use PostgreSQL for indexing or storage
p5-PostgreSQL-PLPerl-Call-1.007 Simple interface for calling SQL functions from PostgreSQL PL/Perl
p5-PostgreSQL-PLPerl-Trace-1.001_1 Simple way to trace execution of Perl statements in PL/Perl
p5-Test-postgresql-0.09_3      Perl extension of postgresql runner for tests
pgtcl-postgresql11-2.1.1_2     TCL extension for accessing a PostgreSQL server (PGTCL-NG)
pgtcl-postgresql12-2.1.1_2     TCL extension for accessing a PostgreSQL server (PGTCL-NG)
pgtcl-postgresql13-2.1.1_2     TCL extension for accessing a PostgreSQL server (PGTCL-NG)
pgtcl-postgresql14-2.1.1_2     TCL extension for accessing a PostgreSQL server (PGTCL-NG)
pgtcl-postgresql15-2.1.1_2     TCL extension for accessing a PostgreSQL server (PGTCL-NG)
postgresql-jdbc-42.6.0         Java JDBC implementation for PostgreSQL
postgresql-libpgeasy-3.0.4_3   Easy-to-use C interface to PostgreSQL
postgresql-libpqxx-7.7.5       New C++ interface for PostgreSQL
postgresql-odbc-15.00.0000     PostgreSQL ODBC driver
postgresql-orafce-4.3.0        Oracle's compatibility functions and packages for PostgreSQL
postgresql-plproxy-2.10.0      Function-based sharding for PostgreSQL
postgresql-relay-1.3.2_1       Multiplex multiple PostgreSQL databases to one relay
postgresql-repmgr-5.4.0        PostgreSQL replication manager
postgresql11-client-11.21      PostgreSQL database (client)
postgresql11-contrib-11.21     The contrib utilities from the PostgreSQL distribution
postgresql11-docs-11.21        The PostgreSQL documentation set
postgresql11-plperl-11.21      Write SQL functions for PostgreSQL using Perl5
postgresql11-plpython-11.21    Module for using Python to write SQL functions
postgresql11-pltcl-11.21       Module for using Tcl to write SQL functions
postgresql11-server-11.21      PostgreSQL is the most advanced open-source database available anywhere
postgresql12-client-12.16      PostgreSQL database (client)
postgresql12-contrib-12.16     The contrib utilities from the PostgreSQL distribution
postgresql12-docs-12.16        The PostgreSQL documentation set
postgresql12-plperl-12.16      Write SQL functions for PostgreSQL using Perl5
postgresql12-plpython-12.16    Module for using Python to write SQL functions
postgresql12-pltcl-12.16       Module for using Tcl to write SQL functions
postgresql12-server-12.16      PostgreSQL is the most advanced open-source database available anywhere
postgresql13-client-13.12      PostgreSQL database (client)
postgresql13-contrib-13.12     The contrib utilities from the PostgreSQL distribution
postgresql13-cstore_fdw-1.7.0  Columnar store for analytics with PostgreSQL
postgresql13-docs-13.12        The PostgreSQL documentation set
postgresql13-mysql_fdw-2.9.0   PostgreSQL foreign data wrapper for MySQL
postgresql13-ogr_fdw-1.1.3_2   PostgreSQL foreign data wrapper for OGR
postgresql13-pg_dirtyread-2.4  Read dead but unvacuumed tuples from a PostgreSQL relation
postgresql13-pg_repack-1.4.8   Reorganize tables in PostgreSQL databases with minimal locks
postgresql13-pg_similarity-20160917_2 Set of functions and operators for executing similarity queries
postgresql13-plperl-13.12      Write SQL functions for PostgreSQL using Perl5
postgresql13-plpgsql_check-2.3.4 PostgreSQL extension to check PL/pgSQL code
postgresql13-plpython-13.12    Module for using Python to write SQL functions
postgresql13-pltcl-13.12       Module for using Tcl to write SQL functions
postgresql13-prefix-1.2.9      Prefix Range module for PostgreSQL
postgresql13-promscale-0.8.0_4 Tables, types and functions supporting Promscale
postgresql13-rum-1.3.13        Inverted index with additional information in posting lists
postgresql13-semver-0.31.2     SemVer 2.0.0 compatible datatype for PostgreSQL database
postgresql13-server-13.12      PostgreSQL is the most advanced open-source database available anywhere
postgresql13-tds_fdw-2.0.3     PostgreSQL foreign data wrapper to connect to TDS databases
postgresql13-zhparser-2.2      PostgreSQL extension for full-text search of Chinese
postgresql14-client-14.9       PostgreSQL database (client)
postgresql14-contrib-14.9      The contrib utilities from the PostgreSQL distribution
postgresql14-docs-14.9         The PostgreSQL documentation set
postgresql14-pgaudit-1.7.0     PostgreSQL Audit Extension
postgresql14-plperl-14.9       Write SQL functions for PostgreSQL using Perl5
postgresql14-plpython-14.9     Module for using Python to write SQL functions
postgresql14-pltcl-14.9        Module for using Tcl to write SQL functions
postgresql14-server-14.9       PostgreSQL is the most advanced open-source database available anywhere
postgresql15-client-15.4       PostgreSQL database (client)
postgresql15-contrib-15.4      The contrib utilities from the PostgreSQL distribution
postgresql15-docs-15.4         The PostgreSQL documentation set
postgresql15-plperl-15.4       Write SQL functions for PostgreSQL using Perl5
postgresql15-plpython-15.4     Module for using Python to write SQL functions
postgresql15-pltcl-15.4        Module for using Tcl to write SQL functions
postgresql15-server-15.4       PostgreSQL is the most advanced open-source database available anywhere
prometheus-postgresql-adapter-0.6.0_14 Use PostgreSQL as a remote storage database for Prometheus
py39-postgresql-1.3.0          Python 3 compatible PostgreSQL database driver and tools
rubygem-azure_mgmt_postgresql-0.17.2 Microsoft Azure PostgreSQL Client Library for Ruby

On Tue, 19 Sept 2023, 00:33 Thomas Munro, <thomas.munro@gmail.com> wrote:
On Tue, Sep 19, 2023 at 9:09 AM Philip Muturura <pndungu2006@gmail.com> wrote:
> # wget https://www.postgresql.org/download/bsd/

That's not a PostgreSQL bug, but anyway the web page you mentioned is
intended for humans to read on a web browser, and it just leads to
another page telling you to use "pkg" or build from the ports tree to
get PostgreSQL on a FreeBSD system.  Something like "pkg search
postgresql16" would be a starting point.

> ld-elf.so.1: /lib/libc.so.7: version FBSD_1.7 required by /usr/local/bin/wget not found

Perhaps because FreeBSD 13.0 is dead and you should upgrade to 13.2.

Re: Installing PostgreSQL 16 on FreeBSD 13.0

От
Thomas Munro
Дата:
On Tue, Sep 19, 2023 at 3:38 PM Philip Muturura <pndungu2006@gmail.com> wrote:
> Anyway , I had run the command you stated before asking for assistance. Seems PostgreSQL 16 is not included in the
FreeBSD13.0 repo. 

I guess in /etc/pkg/FreeBSD.conf you have:

FreeBSD: {
  url: "pkg+http://pkg.FreeBSD.org/${ABI}/quarterly",
...

If you change "quarterly" to "latest" and run "pkg update" you should
see it, otherwise I assume you'll have to wait until next month (?)
for it to show up in the Q3 quarterly package list.

> I did also try to upgrade to Release 13.2, but same error again.

But hopefully your symbol versioning problems went away when you
upgraded to 13.2?  That's because after minor releases reach EOL, the
packages start getting built on the next minor release even though
it's the "same" ABI for packaging purposes (in this case "13"),
AFAIK... I'm no expert on this packaging policy stuff but I guess this
usually doesn't cause trouble unless some new feature from the next
major release (14) gets back-ported and then some configure script
discovers it, or something like that.  Another good reason to keep
your system up to date...



Re: Installing PostgreSQL 16 on FreeBSD 13.0

От
Thomas Munro
Дата:
On Tue, Sep 19, 2023 at 4:49 PM Thomas Munro <thomas.munro@gmail.com> wrote:
> Q3

(Erm, I mean Q4, where does the time go?)