conda-forge / postgresql-feedstock Goto Github PK

View Code? Open in Web Editor NEW

1.0 9.0 31.0 383 KB

A conda-smithy repository for postgresql.

License: BSD 3-Clause "New" or "Revised" License

Shell 43.33% Batchfile 56.67%

postgresql-feedstock's Introduction

About postgresql-split-feedstock

Feedstock license: BSD-3-Clause

About postgresql-split

Home: http://www.postgresql.org/

Package license: PostgreSQL

Summary: multi-ouput recipe for postgresql

About libpq

Package license: PostgreSQL

Summary: The postgres runtime libraries and utilities (not the server itself)

About postgresql

Package license: PostgreSQL

Summary: PostgreSQL is a powerful, open source object-relational database system.

About postgresql-plpython

Package license: PostgreSQL

Summary: The plpythonu postgresql extension

Current build status

Azure

Variant	Status
linux_64
linux_aarch64
linux_ppc64le
osx_64
osx_arm64
win_64

Current release info

Name	Downloads	Version	Platforms

Installing postgresql-split

Installing postgresql-split from the conda-forge channel can be achieved by adding conda-forge to your channels with:

conda config --add channels conda-forge
conda config --set channel_priority strict

Once the conda-forge channel has been enabled, libpq, postgresql, postgresql-plpython can be installed with conda:

conda install libpq postgresql postgresql-plpython

or with mamba:

mamba install libpq postgresql postgresql-plpython

It is possible to list all of the versions of libpq available on your platform with conda:

conda search libpq --channel conda-forge

or with mamba:

mamba search libpq --channel conda-forge

Alternatively, mamba repoquery may provide more information:

# Search all versions available on your platform:
mamba repoquery search libpq --channel conda-forge

# List packages depending on `libpq`:
mamba repoquery whoneeds libpq --channel conda-forge

# List dependencies of `libpq`:
mamba repoquery depends libpq --channel conda-forge

About conda-forge

conda-forge is a community-led conda channel of installable packages. In order to provide high-quality builds, the process has been automated into the conda-forge GitHub organization. The conda-forge organization contains one repository for each of the installable packages. Such a repository is known as a feedstock.

A feedstock is made up of a conda recipe (the instructions on what and how to build the package) and the necessary configurations for automatic building using freely available continuous integration services. Thanks to the awesome service provided by Azure, GitHub, CircleCI, AppVeyor, Drone, and TravisCI it is possible to build and upload installable packages to the conda-forge anaconda.org channel for Linux, Windows and OSX respectively.

To manage the continuous integration and simplify feedstock maintenance conda-smithy has been developed. Using the conda-forge.yml within this repository, it is possible to re-render all of this feedstock's supporting files (e.g. the CI configuration files) with conda smithy rerender.

For more information please check the conda-forge documentation.

Terminology

feedstock - the conda recipe (raw material), supporting scripts and CI configuration.

conda-smithy - the tool which helps orchestrate the feedstock. Its primary use is in the construction of the CI .yml files and simplify the management of many feedstocks.

conda-forge - the place where the feedstock and smithy live and work to produce the finished article (built conda distributions)

Updating postgresql-split-feedstock

If you would like to improve the postgresql-split recipe or build a new package version, please fork this repository and submit a PR. Upon submission, your changes will be run on the appropriate platforms to give the reviewer an opportunity to confirm that the changes result in a successful build. Once merged, the recipe will be re-built and uploaded automatically to the conda-forge channel, whereupon the built conda packages will be available for everybody to install and use from the conda-forge channel. Note that all branches in the conda-forge/postgresql-split-feedstock are immediately built and any created packages are uploaded, so PRs should be based on branches in forks and branches in the main repository should only be used to build distinct package versions.

In order to produce a uniquely identifiable distribution:

If the version of a package is not being increased, please add or increase the build/number.
If the version of a package is being increased, please remember to return the build/number back to 0.

Feedstock Maintainers

postgresql-feedstock's People

Contributors

Stargazers

Watchers

postgresql-feedstock's Issues

Add run: section to libpq outputs

Comment:

With the fun this week with #191, 16.1 build 5 was generated that had the libpq package not get the right openssl pin. My ignorant speculation is the lack of a run requirements section for the libpq output is to blame. Reviewing the present state of run requirements for

base requirements

  run:
    - krb5
    - openssl
    - readline        # [not win]
    - tzcode          # [not win]
    - tzdata          # [not win]

postgresql output

      run:
        - {{ pin_subpackage('libpq', exact=True) }}
        - krb5
        - openssl
        - readline         # [not win]
        - tzcode          # [not win]
        - tzdata          # [not win]
        - zlib

postgresql-python output

      run:
        - {{ pin_subpackage('postgresql', exact=True) }}
        - python
        - krb5
        - openssl
        - zlib

looking at the dependencies of current build 6 on linux64

  "depends": [
    "krb5 >=1.21.2,<1.22.0a0",
    "libgcc-ng >=12",
    "libxml2 >=2.12.2,<2.13.0a0",
    "libzlib >=1.2.13,<1.3.0a0",
    "openssl >=3.2.0,<4.0a0"
  ],

So I'm generating a PR to add a run section to libpq to hopefully prevent future troubles.

Build postgresql-contrib package

I really appreciate having postgresql available through conda. It makes it really easy during tests and in some cases deployment.

Would it be possible to build the contrib section as well? There quite a few extensions that I would like to use.

OpenSSL 3.2 postgresql client connection segfault

Comment:

A reproducible client connection segfault was reported conda-forge/psycopg2-feedstock#94

I am now able to reproduce this with just a simple psql connection test, so am opening an issue here.

psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL:  no PostgreSQL user name specified in startup packet
connection to server at "localhost" (::1), port 5432 failed: FATAL:  no PostgreSQL user name specified in startup packet
double free or corruption (out)
/home/runner/work/_temp/4df30af9-73d0-4c53-9a2c-0a24f1b1d2ab.sh: line 7:  2224 Aborted                 (core dumped) /home/runner/micromamba/envs/prod/bin/psql -l '***localhost/postgres?gssencmode=disable'

postgresql 15.5 availability?

Comment:

I wasn't sure where to ask, but here goes. We have a bokeh application which one of the packages used is postgresql 15.4 but, it's been found to have a vulnerability according to CVE-2023-5869. The fix is to upgrade to 16.1 or 15.5. Do you guys know when 15.5 will be published on the conda-forge channel? We'd upgrade to 16.1 but we run into dependency problems.

Is the v15.x branch still useful in late 2023

Comment:

Seems like the migration was closed 1 year ago. Are there still some known packages that use postgresql 15
conda-forge/conda-forge-pinning-feedstock#3902

I found:

initdb can't find timezones in share path

Issue: initdb can't find timezones in share path

Reproducible on 10.6 and 11.5
Running in yarn on CDH5

I confirmed that the share_path listed contains valid zoneinfo, but postgres' initdb instead looks in another directory:
"/home/conda/feedstock_root/build_artifacts/postgresql-split_1546400609186/_h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_plac/share/zoneinfo": No such file or directory

Possibly related configs:
--with-system-tzdata=DIRECTORY
https://www.postgresql.org/docs/11/install-procedure.html

After this error, I'm unable to set timezones in postgres:

$ psql
# SET timezone TO utc;
ERROR:  invalid value for parameter "TimeZone": "utc"

I don't know where this path came from, but it isn't in my environment so it seems to be some default built into the postgres distributed in conda-forge.

$ initdb -d
Running in debug mode.
The files belonging to this database system will be owned by user "nobody".
This user must also own the server process.

VERSION=10.6
PGDATA=/tmp/postgres_42e7d79b-beea-444e-bf13-748704343f52/postgres
share_path=/data6/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/filecache/12/airflow-runtime.tgz/share
PGPATH=/data6/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/filecache/12/airflow-runtime.tgz/bin
POSTGRES_SUPERUSERNAME=nobody
POSTGRES_BKI=/data6/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/filecache/12/airflow-runtime.tgz/share/postgres.bki
POSTGRES_DESCR=/data6/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/filecache/12/airflow-runtime.tgz/share/postgres.description
POSTGRES_SHDESCR=/data6/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/filecache/12/airflow-runtime.tgz/share/postgres.shdescription
POSTGRESQL_CONF_SAMPLE=/data6/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/filecache/12/airflow-runtime.tgz/share/postgresql.conf.sample
PG_HBA_SAMPLE=/data6/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/filecache/12/airflow-runtime.tgz/share/pg_hba.conf.sample
PG_IDENT_SAMPLE=/data6/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/filecache/12/airflow-runtime.tgz/share/pg_ident.conf.sample
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /tmp/postgres_42e7d79b-beea-444e-bf13-748704343f52/postgres ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... could not open directory "/home/conda/feedstock_root/build_artifacts/postgresql-split_1546400609186/_h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_pla
cehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_plac/share/zoneinfo": No such file or directory
ok
running bootstrap script ... 2020-02-03 05:19:34.789 GMT [41808] LOG:  could not open directory "/home/conda/feedstock_root/build_artifacts/postgresql-split_1546400609186/_h_env_placehold_placehold_placehold_place
hold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_plac/share/zoneinfo": No such file or directory
...

Environment (conda list):

$ conda list
# packages in environment at /data12/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/container_e98_1579285806855_310355_01_000005/env:
#
# Name                    Version                   Build  Channel
_libgcc_mutex             0.1                 conda_forge    conda-forge
_openmp_mutex             4.5                       0_gnu    conda-forge
airflow                   1.10.7                   py37_0    conda-forge
airflow-with-celery       1.10.7                        0    conda-forge
airflow-with-postgres     1.10.7                        0    conda-forge
alembic                   1.3.3                      py_0    conda-forge
amqp                      2.5.2                      py_0    conda-forge
argcomplete               1.10.3                     py_0    conda-forge
asn1crypto                1.3.0                    py37_0    conda-forge
attrs                     19.3.0                     py_0    conda-forge
babel                     2.8.0                      py_0    conda-forge
backcall                  0.1.0                      py_0    conda-forge
billiard                  3.6.0.0          py37h516909a_0    conda-forge
bleach                    3.1.0                      py_0    conda-forge
bzip2                     1.0.8                h516909a_2    conda-forge
c-ares                    1.15.0            h516909a_1001    conda-forge
ca-certificates           2019.11.28           hecc5488_0    conda-forge
cached-property           1.5.1                      py_0    conda-forge
cairo                     1.16.0            hfb77d84_1002    conda-forge
cattrs                    0.9.0                      py_1    conda-forge
celery                    4.4.0rc1                   py_0    conda-forge
certifi                   2019.11.28               py37_0    conda-forge
cffi                      1.13.2           py37h8022711_0    conda-forge
chardet                   3.0.4                 py37_1003    conda-forge
click                     7.0                        py_0    conda-forge
colorama                  0.4.3                      py_0    conda-forge
colorlog                  4.0.2                 py37_1000    conda-forge
conda                     4.8.2                    py37_0    conda-forge
conda-pack                0.4.0                      py_0    conda-forge
conda-package-handling    1.6.0            py37h516909a_1    conda-forge
configparser              3.5.0                 py37_1001    conda-forge
croniter                  0.3.30                     py_0    conda-forge
cryptography              2.5              py37hb7f436b_1    conda-forge
curl                      7.64.0               h646f8bb_0    conda-forge
decorator                 4.4.1                      py_0    conda-forge
defusedxml                0.6.0                      py_0    conda-forge
dill                      0.3.1.1                  py37_0    conda-forge
entrypoints               0.3                   py37_1000    conda-forge
expat                     2.2.9                he1b5a44_2    conda-forge
flask                     1.1.1                      py_1    conda-forge
flask-admin               1.5.3                      py_0    conda-forge
flask-appbuilder          1.12.5                     py_0    conda-forge
flask-babel               0.12.2                     py_0    conda-forge
flask-caching             1.3.3                      py_0    conda-forge
flask-login               0.4.1                      py_0    conda-forge
flask-openid              1.2.5                 py37_1003    conda-forge
flask-sqlalchemy          2.4.0                      py_0    conda-forge
flask-swagger             0.2.13                     py_2    conda-forge
flask-wtf                 0.14.2                     py_1    conda-forge
flower                    0.9.3                    py37_0    conda-forge
fontconfig                2.13.1            h86ecdb6_1001    conda-forge
freetype                  2.10.0               he983fc9_1    conda-forge
fribidi                   1.0.5             h516909a_1002    conda-forge
funcsigs                  1.0.2                      py_3    conda-forge
future                    0.16.0                py37_1002    conda-forge
gettext                   0.19.8.1          hc5be6a0_1002    conda-forge
git                       2.20.1          pl526hc122a05_1001    conda-forge
glib                      2.58.3          py37h6f030ca_1002    conda-forge
graphite2                 1.3.13            hf484d3e_1000    conda-forge
graphviz                  2.42.3               h0511662_0    conda-forge
grpcio                    1.16.0          py37h4f00d22_1000    conda-forge
gunicorn                  19.9.0                py37_1000    conda-forge
harfbuzz                  2.4.0                h9f30f68_3    conda-forge
humanize                  0.5.1                      py_1    conda-forge
icu                       64.2                 he1b5a44_1    conda-forge
idna                      2.8                   py37_1000    conda-forge
importlib_metadata        1.5.0                    py37_0    conda-forge
inflect                   4.0.0                    py37_1    conda-forge
ipykernel                 5.1.4            py37h5ca1d4c_0    conda-forge
ipython                   7.12.0           py37h5ca1d4c_0    conda-forge
ipython_genutils          0.2.0                      py_1    conda-forge
iso8601                   0.1.12                     py_1    conda-forge
itsdangerous              1.1.0                      py_0    conda-forge
jaraco.itertools          5.0.0                      py_0    conda-forge
jedi                      0.16.0                   py37_0    conda-forge
jinja2                    2.10.3                     py_0    conda-forge
jpeg                      9c                h14c3975_1001    conda-forge
json-merge-patch          0.2                        py_0    conda-forge
json5                     0.9.0                      py_0    conda-forge
jsonschema                3.2.0                    py37_0    conda-forge
jupyter_client            5.3.4                    py37_1    conda-forge
jupyter_core              4.6.1                    py37_0    conda-forge
jupyterlab                1.2.6                      py_0    conda-forge
jupyterlab_server         1.0.6                      py_0    conda-forge
kombu                     4.6.3                      py_0    conda-forge
krb5                      1.16.3            hc83ff2d_1000    conda-forge
lazy-object-proxy         1.3.1           py37h516909a_1001    conda-forge
libblas                   3.8.0               14_openblas    conda-forge
libcblas                  3.8.0               14_openblas    conda-forge
libcurl                   7.64.0               h01ee5af_0    conda-forge
libedit                   3.1.20170329      hf8c457e_1001    conda-forge
libffi                    3.2.1             he1b5a44_1006    conda-forge
libgcc-ng                 9.2.0                h24d8f2e_2    conda-forge
libgfortran-ng            7.3.0                hdf63c60_5    conda-forge
libgomp                   9.2.0                h24d8f2e_2    conda-forge
libiconv                  1.15              h516909a_1005    conda-forge
liblapack                 3.8.0               14_openblas    conda-forge
libopenblas               0.3.7                h5ec1e0e_6    conda-forge
libpng                    1.6.37               hed695b0_0    conda-forge
libpq                     10.6              h13b8bad_1000    conda-forge
libprotobuf               3.11.2               h8b12597_0    conda-forge
libsodium                 1.0.17               h516909a_0    conda-forge
libssh2                   1.8.0             h1ad7b7a_1003    conda-forge
libstdcxx-ng              9.2.0                hdf63c60_2    conda-forge
libtiff                   4.1.0                hc3755c2_3    conda-forge
libtool                   2.4.6             h14c3975_1002    conda-forge
libuuid                   2.32.1            h14c3975_1000    conda-forge
libxcb                    1.13              h14c3975_1002    conda-forge
libxml2                   2.9.10               hee79883_0    conda-forge
lockfile                  0.12.2                     py_1    conda-forge
lz4-c                     1.8.3             he1b5a44_1001    conda-forge
mako                      1.1.0                      py_0    conda-forge
markdown                  2.6.11                     py_0    conda-forge
markupsafe                1.1.1            py37h516909a_0    conda-forge
marshmallow               3.3.0                      py_0    conda-forge
marshmallow-sqlalchemy    0.17.2                     py_0    conda-forge
mistune                   0.8.4           py37h516909a_1000    conda-forge
more-itertools            8.2.0                      py_0    conda-forge
nbconvert                 5.6.1                    py37_0    conda-forge
nbformat                  5.0.4                      py_0    conda-forge
ncurses                   6.1               hf484d3e_1002    conda-forge
notebook                  6.0.3                    py37_0    conda-forge
numpy                     1.17.5           py37h95a1406_0    conda-forge
openssl                   1.0.2u               h516909a_0    conda-forge
pandas                    0.25.3           py37hb3f55d8_0    conda-forge
pandoc                    2.9.1.1                       0    conda-forge
pandocfilters             1.4.2                      py_1    conda-forge
pango                     1.42.4               ha030887_1    conda-forge
parso                     0.6.0                      py_0    conda-forge
pcre                      8.43                 he1b5a44_0    conda-forge
pendulum                  1.4.4                    py37_1    conda-forge
perl                      5.26.2            h516909a_1006    conda-forge
pexpect                   4.8.0                    py37_0    conda-forge
pickleshare               0.7.5                 py37_1000    conda-forge
pip                       20.0.2                   py37_1    conda-forge
pixman                    0.38.0            h516909a_1003    conda-forge
postgresql                10.6              h66cca7a_1000    conda-forge
prometheus_client         0.7.1                      py_0    conda-forge
prompt_toolkit            3.0.3                      py_0    conda-forge
protobuf                  3.11.2           py37he1b5a44_0    conda-forge
psutil                    5.6.7            py37h516909a_0    conda-forge
psycopg2                  2.7.7            py37hb7f436b_0    conda-forge
pthread-stubs             0.4               h14c3975_1001    conda-forge
ptyprocess                0.6.0                   py_1001    conda-forge
pycosat                   0.6.3           py37h516909a_1002    conda-forge
pycparser                 2.19                     py37_1    conda-forge
pygments                  2.5.2                      py_0    conda-forge
pyjwt                     1.7.1                      py_0    conda-forge
pyopenssl                 19.0.0                   py37_0    conda-forge
pyrsistent                0.15.7           py37h516909a_0    conda-forge
pysocks                   1.7.1                    py37_0    conda-forge
python                    3.7.1             hd21baee_1001    conda-forge
python-daemon             2.1.2                    py37_0    conda-forge
python-dateutil           2.8.1                      py_0    conda-forge
python-editor             1.0.4                      py_0    conda-forge
python-graphviz           0.13.2                     py_0    conda-forge
python3-openid            3.1.0                 py37_1001    conda-forge
pytz                      2019.3                     py_0    conda-forge
pytzdata                  2019.3                     py_0    conda-forge
pyyaml                    5.3              py37h516909a_0    conda-forge
pyzmq                     18.1.1           py37h1768529_0    conda-forge
readline                  7.0               hf8c457e_1001    conda-forge
redis                     5.0.3                h7b6447c_0  
requests                  2.22.0                   py37_1    conda-forge
ruamel_yaml               0.15.80         py37h516909a_1000    conda-forge
send2trash                1.5.0                      py_0    conda-forge
setproctitle              1.1.10          py37h516909a_1001    conda-forge
setuptools                45.1.0                   py37_0    conda-forge
simplejson                3.17.0           py37h516909a_0    conda-forge
six                       1.14.0                   py37_0    conda-forge
skein                     0.8.0                    py37_0    conda-forge
sqlalchemy                1.3.13           py37h516909a_0    conda-forge
sqlalchemy-jsonfield      0.9.0                    py37_1    conda-forge
sqlite                    3.28.0               h8b20d00_0    conda-forge
tabulate                  0.8.6                      py_0    conda-forge
tenacity                  4.12.0                   py37_1    conda-forge
termcolor                 1.1.0                      py_2    conda-forge
terminado                 0.8.3                    py37_0    conda-forge
testpath                  0.4.4                      py_0    conda-forge
text-unidecode            1.2                        py_0    conda-forge
thrift                    0.11.0          py37he1b5a44_1001    conda-forge
tk                        8.6.10               hed695b0_0    conda-forge
tornado                   5.1.1           py37h14c3975_1000    conda-forge
tqdm                      4.42.0                     py_0    conda-forge
traitlets                 4.3.3                    py37_0    conda-forge
typing_extensions         3.7.4.1                  py37_0    conda-forge
tzcode                    2019a             h516909a_1002    conda-forge
tzlocal                   1.5.1                      py_0    conda-forge
unicodecsv                0.14.1                     py_1    conda-forge
urllib3                   1.25.7                   py37_0    conda-forge
vine                      1.3.0                      py_0    conda-forge
wcwidth                   0.1.8                      py_0    conda-forge
webencodings              0.5.1                      py_1    conda-forge
werkzeug                  0.16.1                     py_0    conda-forge
wheel                     0.34.2                   py37_0    conda-forge
wtforms                   2.2.1                      py_0    conda-forge
xorg-kbproto              1.0.7             h14c3975_1002    conda-forge
xorg-libice               1.0.10               h516909a_0    conda-forge
xorg-libsm                1.2.3             h84519dc_1000    conda-forge
xorg-libx11               1.6.9                h516909a_0    conda-forge
xorg-libxau               1.0.9                h14c3975_0    conda-forge
xorg-libxdmcp             1.1.3                h516909a_0    conda-forge
xorg-libxext              1.3.4                h516909a_0    conda-forge
xorg-libxpm               3.5.13               h516909a_0    conda-forge
xorg-libxrender           0.9.10            h516909a_1002    conda-forge
xorg-libxt                1.1.5             h516909a_1003    conda-forge
xorg-renderproto          0.11.1            h14c3975_1002    conda-forge
xorg-xextproto            7.3.0             h14c3975_1002    conda-forge
xorg-xproto               7.0.31            h14c3975_1007    conda-forge
xz                        5.2.4             h14c3975_1001    conda-forge
yaml                      0.2.2                h516909a_1    conda-forge
zeromq                    4.3.2                he1b5a44_2    conda-forge
zipp                      2.1.0                      py_0    conda-forge
zlib                      1.2.11            h516909a_1006    conda-forge
zope.deprecation          4.4.0                      py_0    conda-forge
zstd                      1.4.4                h3b9ef0a_1    conda-forge

Details about conda and system ( conda info ):

$ conda info

     active environment : base
    active env location : /data12/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/container_e98_1579285806855_310355_01_000005/env
       user config file : /tmp/postgres_42e7d79b-beea-444e-bf13-748704343f52/.condarc
 populated config files : 
          conda version : 4.8.2
    conda-build version : not installed
         python version : 3.7.1.final.0
       virtual packages : __glibc=2.12
       base environment : /data12/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/container_e98_1579285806855_310355_01_000005/env  (read only)
           channel URLs : https://repo.anaconda.com/pkgs/main/linux-64
                          https://repo.anaconda.com/pkgs/main/noarch
                          https://repo.anaconda.com/pkgs/r/linux-64
                          https://repo.anaconda.com/pkgs/r/noarch
          package cache : /data12/yarn/nm/usercache/atronchinjames/appcache/application_1579285806855_310355/container_e98_1579285806855_310355_01_000005/env/pkgs
                          /tmp/postgres_42e7d79b-beea-444e-bf13-748704343f52/.conda/pkgs
       envs directories : /tmp/postgres_42e7d79b-beea-444e-bf13-748704343f52/.conda/envs
               platform : linux-64
             user-agent : conda/4.8.2 requests/2.22.0 CPython/3.7.1 Linux/4.19.61-100.el6pie centos/6.9 glibc/2.12
                UID:GID : 99:99
             netrc file : None
           offline mode : False

@conda-forge-admin, please re-render

Issue:

Environment (conda list):

$ conda list

Details about conda and system ( conda info ):

$ conda info

PG_SYSROOT is baked into the conda package

This results in the sysroot from the build machine being baked in. Upstream recommends setting PG_SYSROOT=undefined to not do that.

cc @chrisburr

Installing `pg_stat_statements`

Hey guys, Is there a way to install this extension for use with the conda package?

OpenSSL 3.2 breaks postgres

The recent release of OpenSSL 3.2.0 has surfaced some latent problems with postgres, which are in the process of being fixed (there's an in-progress discussion, plus a draft patch available).

We probably need to repodatapatch all existing builds to use openssl <3.2. Going forward, we can either add that cap (until the patch is merged and released) or backport the patch.

PS. Upstream OpenSSL commented:

Bottom line: Postgres BIO API misuse that finally broke in practice. Not related to this issue.

Xref:
conda-forge/openssl-feedstock#144
Homebrew/homebrew-core#155651

CC @conda-forge/postgresql

Why ICU is disabled?

Comment:

I have some usecases where I use collation, and this feedstock doesn't support it. Any chance we might enable ICU support?

Unpin libxml2

Comment:

In #182 and #181

openssl 3.2 compatibility was fixed but libxml2 was pinned

we should work to unpin it.

.src_tree?

Appears there is some (broken?) submodule .src_tree in the feedstock. Should this be here? If so, should it be fixed somehow? If not, could it be dropped?

Travis-CI is returning a MD5MismatchError

This is odd. I am pulling this package and issuing a new build number in PR #11

Can't build /Users/travis/build/conda-forge/libgdal-feedstock/recipe due to environment creation error:
MD5MismatchError: Conda detected a mismatch between the expected content and downloaded content
for url 'https://conda.anaconda.org/conda-forge/osx-64/postgresql-9.6.3-0.tar.bz2'.
  download saved to: /Users/travis/miniconda3/pkgs/postgresql-9.6.3-0.tar.bz2
  expected md5 sum: 6b102d2d1190c722973e8e71b7ed7a68
  actual md5 sum: 9b02c8823fb9728d57e32c9ee6ecce91
MD5MismatchError: Conda detected a mismatch between the expected content and downloaded content
for url 'https://conda.anaconda.org/conda-forge/osx-64/postgresql-9.6.3-0.tar.bz2'.
  download saved to: /Users/travis/miniconda3/pkgs/postgresql-9.6.3-0.tar.bz2
  expected md5 sum: 6b102d2d1190c722973e8e71b7ed7a68
  actual md5 sum: 9b02c8823fb9728d57e32c9ee6ecce91
MD5MismatchError: Conda detected a mismatch between the expected content and downloaded content
for url 'https://conda.anaconda.org/conda-forge/osx-64/postgresql-9.6.3-0.tar.bz2'.
  download saved to: /Users/travis/miniconda3/pkgs/postgresql-9.6.3-0.tar.bz2
  expected md5 sum: 6b102d2d1190c722973e8e71b7ed7a68
  actual md5 sum: 9b02c8823fb9728d57e32c9ee6ecce91

Packaging 15.4

Looks like PostgreSQL recently released 15.4

postgresql-client output?

Would there be interest/support for adding an output for just the client binaries like psql, pg_dump and pg_restore? I'd personally find this extremely useful.

I'd like to duplicate the functionality of the postgresql-client Ubuntu package. (Note that the postgresql Ubuntu package depends on postgresql-client.)

For reference, some details of this Debian package are as follows:

The Debian control file is:

Package: postgresql-client-12
Source: postgresql-12
Version: 12.7-1.pgdg20.04+1
Architecture: amd64
Maintainer: Debian PostgreSQL Maintainers <[email protected]>
Installed-Size: 6087
Depends: libpq5 (>= 12.7), postgresql-client-common (>= 182~), sensible-utils, libc6 (>= 2.17), libedit2 (>= 3.1-20180525-0), zlib1g (>= 1:1.1.4)
Suggests: postgresql-12, postgresql-doc-12
Conflicts: postgresql-server-dev-12 (<< 12.1-2~)
Replaces: postgresql-server-dev-12 (<< 12.1-2~)
Provides: postgresql-client
Section: database
Priority: optional
Multi-Arch: foreign
Homepage: http://www.postgresql.org/
Description: front-end programs for PostgreSQL 12
 This package contains client and administrative programs for
 PostgreSQL: these are the interactive terminal client psql and
 programs for creating and removing users and databases.
 .
 This is the client package for PostgreSQL 12. If you install
 PostgreSQL 12 on a standalone machine, you need the server package
 postgresql-12, too. On a network, you can install this package on
 many client machines, while the server package may be installed on
 only one machine.
 .
 PostgreSQL is an object-relational SQL database management system.

and the subset of files which are installed to usr/lib/postgresql/12/ , is:

  usr/lib/postgresql/12/bin/clusterdb
  usr/lib/postgresql/12/bin/createdb
  usr/lib/postgresql/12/bin/createuser
  usr/lib/postgresql/12/bin/dropdb
  usr/lib/postgresql/12/bin/dropuser
  usr/lib/postgresql/12/bin/pg_basebackup
  usr/lib/postgresql/12/bin/pg_config
  usr/lib/postgresql/12/bin/pg_dump
  usr/lib/postgresql/12/bin/pg_dumpall
  usr/lib/postgresql/12/bin/pg_isready
  usr/lib/postgresql/12/bin/pg_receivewal
  usr/lib/postgresql/12/bin/pg_recvlogical
  usr/lib/postgresql/12/bin/pg_restore
  usr/lib/postgresql/12/bin/psql
  usr/lib/postgresql/12/bin/reindexdb
  usr/lib/postgresql/12/bin/vacuumdb
  usr/lib/postgresql/12/lib/pgxs/config/install-sh
  usr/lib/postgresql/12/lib/pgxs/config/missing
  usr/lib/postgresql/12/lib/pgxs/src/Makefile.global
  usr/lib/postgresql/12/lib/pgxs/src/Makefile.port
  usr/lib/postgresql/12/lib/pgxs/src/Makefile.shlib
  usr/lib/postgresql/12/lib/pgxs/src/makefiles/pgxs.mk
  usr/lib/postgresql/12/lib/pgxs/src/nls-global.mk
  usr/lib/postgresql/12/lib/pgxs/src/pl/plpython/regress-python3-mangle.mk
  usr/lib/postgresql/12/lib/pgxs/src/test/perl/PostgresNode.pm
  usr/lib/postgresql/12/lib/pgxs/src/test/perl/RecursiveCopy.pm
  usr/lib/postgresql/12/lib/pgxs/src/test/perl/SimpleTee.pm
  usr/lib/postgresql/12/lib/pgxs/src/test/perl/TestLib.pm
  usr/lib/postgresql/12/lib/pgxs/src/test/regress/pg_regress

postgresql 11.4 should have an explicit readline=8.0 requirement

Issue: I upgraded postgresql to 11.4 and readline was left at 7.0, running psql then fails with libreadline.so.8: cannot open shared object file: No such file or directory

Environment (conda list):

$ conda list
# packages in environment at /opt/miniconda3/envs/prod:
#
# Name                    Version                   Build  Channel
affine                    2.2.2                      py_0    conda-forge
alabaster                 0.7.12                     py_0    conda-forge
alembic                   1.0.10                     py_0    conda-forge
apiclient                 1.0.3                    pypi_0    pypi
appdirs                   1.4.3                      py_1    conda-forge
asn1crypto                0.24.0                py36_1003    conda-forge
astroid                   2.2.5                    py36_0    conda-forge
async_generator           1.10                       py_0    conda-forge
atk                       2.32.0               haf93ef1_0    conda-forge
atomicwrites              1.3.0                      py_0    conda-forge
attrs                     19.1.0                     py_0    conda-forge
automat                   0.7.0                    pypi_0    pypi
babel                     2.7.0                      py_0    conda-forge
backcall                  0.1.0                      py_0    conda-forge
bcrypt                    3.1.4            py36h470a237_0    conda-forge
beautifulsoup4            4.7.1                 py36_1001    conda-forge
bitstring                 3.1.5                    pypi_0    pypi
black                     18.6b4                   pypi_0    pypi
blas                      2.10                   openblas    conda-forge
bleach                    3.1.0                      py_0    conda-forge
blinker                   1.4                        py_1    conda-forge
bokeh                     1.2.0                    py36_0    conda-forge
boost-cpp                 1.68.0            h11c811c_1000    conda-forge
bottleneck                1.2.1           py36h3010b51_1001    conda-forge
boxsdk                    1.5.5                    pypi_0    pypi
bzip2                     1.0.6             h14c3975_1002    conda-forge
ca-certificates           2019.6.16            hecc5488_0    conda-forge
cachetools                2.1.0                    pypi_0    pypi
cairo                     1.16.0            ha4e643d_1000    conda-forge
cartopy                   0.17.0          py36h0aa2c8f_1004    conda-forge
cdo                       1.9.6             hd104f1c_1006    conda-forge
cdsapi                    0.1.3                    pypi_0    pypi
certifi                   2019.6.16                py36_0    conda-forge
certipy                   0.1.3                      py_0    conda-forge
cf_units                  2.0.1           py36h3010b51_1002    conda-forge
cffi                      1.12.3           py36h8022711_0    conda-forge
cfgrib                    0.9.7                      py_0    conda-forge
cftime                    1.0.3.4         py36hd352d35_1001    conda-forge
chardet                   3.0.4                 py36_1003    conda-forge
click                     7.0                        py_0    conda-forge
click-plugins             1.1.1                      py_0    conda-forge
cligj                     0.5.0                      py_0    conda-forge
cloudpickle               1.1.1                      py_0    conda-forge
cmarkgfm                  0.4.2            py36h14c3975_2    conda-forge
codecov                   2.0.15                   pypi_0    pypi
configurable-http-proxy   1.3.0                         0    conda-forge
consistent-hash-git       0.3                      pypi_0    pypi
constantly                15.1.0                     py_0    conda-forge
coverage                  4.5.3            py36h14c3975_0    conda-forge
coveralls                 1.8.1                      py_0    conda-forge
cryptography              2.7              py36h72c5cf5_0    conda-forge
cryptography-vectors      2.6.1                      py_0    conda-forge
curl                      7.64.1               hf8cf82a_0    conda-forge
cycler                    0.10.0                     py_1    conda-forge
cython                    0.29.10          py36he1b5a44_0    conda-forge
cytoolz                   0.9.0.1         py36h14c3975_1001    conda-forge
dask                      1.2.2                      py_2    conda-forge
dask-core                 1.2.2                      py_0    conda-forge
dbus                      1.13.6               he372182_0    conda-forge
decorator                 4.4.0                      py_0    conda-forge
defusedxml                0.5.0                      py_1    conda-forge
descartes                 1.1.0                      py_3    conda-forge
distributed               1.28.1                   py36_0    conda-forge
docopt                    0.6.2                      py_1    conda-forge
docutils                  0.14                  py36_1001    conda-forge
dropbox                   9.3.0                      py_0    conda-forge
eccodes                   2.12.3               h4fa793d_1    conda-forge
ecmwf_grib                1.14.7                        2    conda-forge
entrypoints               0.3                   py36_1000    conda-forge
enum34                    1.1.6                    pypi_0    pypi
ephem                     3.7.6.0         py36h14c3975_1001    conda-forge
esmf                      7.1.0             hdfb41a0_1004    conda-forge
expat                     2.2.5             hf484d3e_1002    conda-forge
feedgen                   0.7.0                    pypi_0    pypi
fftw                      3.3.8           nompi_h7f3a6c3_1105    conda-forge
fiona                     1.8.6            py36hf242f0b_3    conda-forge
flake8                    3.7.7                    py36_0    conda-forge
fontconfig                2.13.1            he4413a7_1000    conda-forge
freetype                  2.10.0               he983fc9_0    conda-forge
freexl                    1.0.5             h14c3975_1002    conda-forge
fribidi                   1.0.5             h14c3975_1000    conda-forge
future                    0.16.0                   pypi_0    pypi
g2clib                    1.6.0                hf3f1b0b_9    conda-forge
gdal                      2.4.1            py36hf242f0b_0    conda-forge
gdata                     3.0.0                    pypi_0    pypi
gdk-pixbuf                2.36.12           h49783d7_1002    conda-forge
geographiclib             1.49                       py_0    conda-forge
geojson                   2.4.1                      py_0    conda-forge
geopandas                 0.5.0                      py_2    conda-forge
geopy                     1.20.0                     py_0    conda-forge
geos                      3.7.1             hf484d3e_1000    conda-forge
geotiff                   1.4.3             h1105359_1000    conda-forge
gettext                   0.19.8.1          hc5be6a0_1002    conda-forge
giflib                    5.1.7                h516909a_1    conda-forge
glib                      2.58.3            hf63aee3_1001    conda-forge
gmp                       6.1.2             hf484d3e_1000    conda-forge
gobject-introspection     1.58.2          py36h2da5eee_1000    conda-forge
google-api-python-client  1.7.4                    pypi_0    pypi
google-auth               1.5.0                    pypi_0    pypi
google-auth-httplib2      0.0.3                    pypi_0    pypi
graphite2                 1.3.13            hf484d3e_1000    conda-forge
gsl                       2.4               h294904e_1006    conda-forge
gst-plugins-base          1.14.4            hdf3bae2_1001    conda-forge
gstreamer                 1.14.4            h66beb1c_1001    conda-forge
gtk2                      2.24.31           hb68c50a_1001    conda-forge
h5netcdf                  0.7.4                      py_0    conda-forge
h5py                      2.9.0           nompi_py36hf008753_1102    conda-forge
harfbuzz                  2.4.0                h37c48d4_1    conda-forge
hdf4                      4.2.13            h9a582f1_1002    conda-forge
hdf5                      1.10.4          nompi_h3c11f04_1106    conda-forge
hdfeos2                   2.20              h64bfcee_1000    conda-forge
hdfeos5                   5.1.16               hccfc538_4    conda-forge
heapdict                  1.0.0                 py36_1000    conda-forge
html5lib                  1.0.1                      py_0    conda-forge
httplib2                  0.11.3                   pypi_0    pypi
hyperlink                 17.3.1                     py_0    conda-forge
icu                       58.2              hf484d3e_1000    conda-forge
idna                      2.8                   py36_1000    conda-forge
iembot                    0.1.0                    pypi_0    pypi
imagesize                 1.1.0                      py_0    conda-forge
importlib_metadata        0.15                     py36_0    conda-forge
incremental               17.5.0                     py_0    conda-forge
inotify                   0.2.10                   pypi_0    pypi
intel-openmp              2019.4                      243  
ipykernel                 5.1.1            py36h24bf2e0_0    conda-forge
ipython                   7.5.0            py36h24bf2e0_0    conda-forge
ipython_genutils          0.2.0                      py_1    conda-forge
isort                     4.3.20                   py36_0    conda-forge
jasper                    1.900.1           h07fcdf6_1006    conda-forge
jdcal                     1.4.1                      py_0    conda-forge
jedi                      0.13.3                   py36_0    conda-forge
jenks                     1.0                      pypi_0    pypi
jinja2                    2.10.1                     py_0    conda-forge
jmespath                  0.9.4                      py_0    conda-forge
jpeg                      9c                h14c3975_1001    conda-forge
json-c                    0.13.1            h14c3975_1001    conda-forge
jsonschema                3.0.1                    py36_0    conda-forge
jupyter_client            5.2.4                      py_3    conda-forge
jupyter_core              4.4.0                      py_0    conda-forge
jupyterhub                1.0.0                    py36_0    conda-forge
jupyterlab                0.35.6                   py36_0    conda-forge
jupyterlab_launcher       0.13.1                     py_2    conda-forge
jupyterlab_server         0.2.0                      py_0    conda-forge
kealib                    1.4.10            h1978553_1003    conda-forge
keras                     2.2.4                    pypi_0    pypi
keras-applications        1.0.7                    pypi_0    pypi
keras-preprocessing       1.0.9                    pypi_0    pypi
kiwisolver                1.1.0            py36hc9558a2_0    conda-forge
krb5                      1.16.3            h05b26f9_1001    conda-forge
lazy-object-proxy         1.4.1            py36h516909a_0    conda-forge
libaec                    1.0.4                hf484d3e_0    conda-forge
libblas                   3.8.0               10_openblas    conda-forge
libcblas                  3.8.0               10_openblas    conda-forge
libcurl                   7.64.1               hda55be3_0    conda-forge
libdap4                   3.19.1            hd48c02d_1000    conda-forge
libedit                   3.1.20170329      hf8c457e_1001    conda-forge
libffi                    3.2.1             he1b5a44_1006    conda-forge
libgcc                    7.2.0                h69d50b8_2    conda-forge
libgcc-ng                 7.3.0                hdf63c60_0    conda-forge
libgdal                   2.4.1                hdb8f723_0    conda-forge
libgfortran               3.0.0                         1    conda-forge
libgfortran-ng            7.2.0                hdf63c60_3    conda-forge
libiconv                  1.15              h516909a_1005    conda-forge
libkml                    1.3.0             h328b03d_1009    conda-forge
liblapack                 3.8.0               10_openblas    conda-forge
liblapacke                3.8.0               10_openblas    conda-forge
libnetcdf                 4.6.2             hbdf4f91_1001    conda-forge
libopenblas               0.3.6                h6e990d7_2    conda-forge
libpng                    1.6.37               hed695b0_0    conda-forge
libpq                     11.4                 h4e4e079_0    conda-forge
libprotobuf               3.8.0                h8b12597_0    conda-forge
libsodium                 1.0.16            h14c3975_1001    conda-forge
libspatialindex           1.9.0                he1b5a44_1    conda-forge
libspatialite             4.3.0a            hb5ec416_1026    conda-forge
libssh2                   1.8.2                h22169c7_2    conda-forge
libstdcxx-ng              7.3.0                hdf63c60_0    conda-forge
libtiff                   4.0.10            h57b8799_1003    conda-forge
libuuid                   2.32.1            h14c3975_1000    conda-forge
libxcb                    1.13              h14c3975_1002    conda-forge
libxml2                   2.9.9                h13577e0_0    conda-forge
libxslt                   1.1.32            h4785a14_1002    conda-forge
locket                    0.2.0                      py_2    conda-forge
lxml                      4.3.3            py36h7ec2d77_0    conda-forge
lz4-c                     1.8.3             he1b5a44_1001    conda-forge
lzo                       2.10              h14c3975_1000    conda-forge
mako                      1.0.10                     py_0    conda-forge
mapclassify               2.0.1                      py_0    conda-forge
mapscript                 7.5.0                    pypi_0    pypi
markupsafe                1.1.1            py36h14c3975_0    conda-forge
matplotlib                3.1.0                    py36_1    conda-forge
matplotlib-base           3.1.0            py36hfd891ef_1    conda-forge
mccabe                    0.6.1                      py_1    conda-forge
metar                     1.6.0                    pypi_0    pypi
metpy                     0.10.0                py36_1001    conda-forge
mistune                   0.8.4           py36h14c3975_1000    conda-forge
mkl                       2019.4                      243  
mkl_fft                   1.0.13           py36h516909a_1    conda-forge
mkl_random                1.0.4            py36hf2d7682_0    conda-forge
mock                      3.0.5                    py36_0    conda-forge
mod-wsgi                  4.6.4                    pypi_0    pypi
more-itertools            4.3.0                 py36_1000    conda-forge
mpi                       1.0                       mpich    conda-forge
mpich                     3.2.1             hc99cbb1_1009    conda-forge
msgpack-python            0.6.1            py36h6bb024c_0    conda-forge
munch                     2.3.2                      py_0    conda-forge
nbconvert                 5.5.0                      py_0    conda-forge
nbformat                  4.4.0                      py_1    conda-forge
ncl                       6.6.2                h9ce15c7_1    conda-forge
nco                       4.8.0                hfb3d286_0    conda-forge
ncurses                   6.1               hf484d3e_1002    conda-forge
netcdf-fortran            4.4.5             hea25ff8_1000    conda-forge
netcdf4                   1.5.1.2          py36had58050_0    conda-forge
nodejs                    11.14.0              he1b5a44_1    conda-forge
nose                      1.3.7                 py36_1002    conda-forge
notebook                  5.7.8                    py36_1    conda-forge
numexpr                   2.6.9           py36h637b7d7_1000    conda-forge
numpy                     1.16.4           py36h95a1406_0    conda-forge
nwnserver                 0.2                      pypi_0    pypi
oauth                     1.0.1                    pypi_0    pypi
oauth2client              4.1.2                    pypi_0    pypi
oauthlib                  3.0.1                      py_0    conda-forge
odfpy                     1.3.6                    pypi_0    pypi
olefile                   0.46                       py_0    conda-forge
openblas                  0.3.6                h6e990d7_2    conda-forge
openjpeg                  2.3.1                h58a6597_0    conda-forge
openssl                   1.1.1b               h14c3975_1    conda-forge
ossuuid                   1.6.2             hf484d3e_1000    conda-forge
owslib                    0.17.1                     py_0    conda-forge
packaging                 19.0                       py_0    conda-forge
palettable                3.1.1                      py_0    conda-forge
pamela                    1.0.0                      py_0    conda-forge
pamqp                     2.3.0                    pypi_0    pypi
pandas                    0.24.2           py36hb3f55d8_0    conda-forge
pandoc                    2.7.2                         0    conda-forge
pandocfilters             1.4.2                      py_1    conda-forge
pango                     1.40.14           h4ea9474_1004    conda-forge
parso                     0.4.0                      py_0    conda-forge
partd                     0.3.9                      py_0    conda-forge
paste                     3.0.8                    py36_0    conda-forge
patsy                     0.5.1                      py_0    conda-forge
pbr                       5.2.0                      py_0    conda-forge
pcre                      8.41              hf484d3e_1003    conda-forge
pep8                      1.7.1                      py_0    conda-forge
pexpect                   4.7.0                    py36_0    conda-forge
pickleshare               0.7.5                 py36_1000    conda-forge
pika                      1.0.1                      py_0    conda-forge
pillow                    6.0.0            py36he7afcd5_0    conda-forge
pint                      0.8.1                      py_1    conda-forge
pip                       19.1.1                   py36_0    conda-forge
pixman                    0.34.0            h14c3975_1003    conda-forge
pkginfo                   1.5.0.1                    py_0    conda-forge
pluggy                    0.12.0                     py_0    conda-forge
pockets                   0.6.2                    pypi_0    pypi
pooch                     0.1+3.g5e21026           pypi_0    pypi
poppler                   0.67.0               h2ad7f00_6    conda-forge
poppler-data              0.4.9                         1    conda-forge
postgresql                11.4                 hbeee2d4_0    conda-forge
proj4                     5.2.0             he1b5a44_1003    conda-forge
prometheus_client         0.6.0                      py_0    conda-forge
prompt_toolkit            2.0.9                      py_0    conda-forge
protobuf                  3.8.0            py36he1b5a44_0    conda-forge
psutil                    5.6.2            py36h516909a_0    conda-forge
psycopg2                  2.8.3            py36h72c5cf5_0    conda-forge
pthread-stubs             0.4               h14c3975_1001    conda-forge
ptyprocess                0.6.0                   py_1001    conda-forge
py                        1.8.0                      py_0    conda-forge
pyasn1                    0.4.5                      py_0    conda-forge
pyasn1-modules            0.2.5                      py_0    conda-forge
pybufrkit                 0.2.7                    pypi_0    pypi
pycodestyle               2.5.0                      py_0    conda-forge
pycparser                 2.19                     py36_1    conda-forge
pycurl                    7.43.0.2         py36h16ce93b_0    conda-forge
pyepsg                    0.4.0                      py_0    conda-forge
pyflakes                  2.1.1                      py_0    conda-forge
pygments                  2.4.2                      py_0    conda-forge
pygrib                    2.0.4            py36hf3f1b0b_0    conda-forge
pyhamcrest                1.9.0                      py_2    conda-forge
pyiem                     0.11.0                   pypi_0    pypi
pyjwt                     1.7.1                      py_0    conda-forge
pykdtree                  1.3.1           py36h3010b51_1002    conda-forge
pyldm                     0.1.0                    pypi_0    pypi
pylint                    2.3.1                    py36_0    conda-forge
pyngl                     1.6.1            py36h24fcaf0_1    conda-forge
pynio                     1.5.5            py36h8b983ae_0    conda-forge
pyopenssl                 19.0.0                   py36_0    conda-forge
pypandoc                  1.4                      pypi_0    pypi
pyparsing                 2.4.0                      py_0    conda-forge
pyproj                    1.9.6           py36h516909a_1002    conda-forge
pyqt                      5.9.2            py36hcca6a23_0    conda-forge
pyrsistent                0.15.2           py36h516909a_0    conda-forge
pyrss2gen                 1.1                      pypi_0    pypi
pysal                     2.0.0                      py_0    conda-forge
pyshp                     2.1.0                      py_0    conda-forge
pysocks                   1.7.0                    py36_0    conda-forge
pytest                    4.6.3                    py36_0    conda-forge
pytest-cov                2.7.1                      py_0    conda-forge
pytest-mpl                0.10                       py_0    conda-forge
pytest-runner             5.1                        py_0    conda-forge
python                    3.6.7             h381d211_1004    conda-forge
python-dateutil           2.8.0                      py_0    conda-forge
python-editor             1.0.4                      py_0    conda-forge
python-memcached          1.59                       py_0    conda-forge
python-oauth2             1.1.0                      py_2    conda-forge
python-twitter            3.4.2                    pypi_0    pypi
pytz                      2019.1                     py_0    conda-forge
pyyaml                    5.1              py36h14c3975_0    conda-forge
pyzmq                     18.0.1           py36hc4ba49a_1    conda-forge
qt                        5.9.7                h52cfd70_2    conda-forge
rabbitpy                  2.0.0                    pypi_0    pypi
rasterio                  1.0.24           py36hdff7cfa_0    conda-forge
rasterstats               0.13.1                     py_0    conda-forge
readline                  7.0               hf8c457e_1001    conda-forge
readme_renderer           24.0                       py_0    conda-forge
reportlab                 3.5.23           py36h7d98c4e_0    conda-forge
requests                  2.22.0                   py36_0    conda-forge
requests-oauthlib         1.2.0                      py_0    conda-forge
requests-toolbelt         0.9.1                      py_0    conda-forge
rrdtool                   0.1.14                   pypi_0    pypi
rsa                       3.4.2                    pypi_0    pypi
rtree                     0.8.3           py36h666c49c_1002    conda-forge
scikit-learn              0.19.2                   pypi_0    pypi
scipy                     1.2.1            py36h09a28d5_1    conda-forge
seaborn                   0.9.0                      py_1    conda-forge
send2trash                1.5.0                      py_0    conda-forge
service_identity          18.1.0                     py_0    conda-forge
setuptools                41.0.1                   py36_0    conda-forge
setuptools-markdown       0.2                      pypi_0    pypi
shapely                   1.6.4           py36h06cd6f9_1005    conda-forge
simplegeneric             0.8.1                      py_1    conda-forge
simplejson                3.16.1           py36h470a237_0    conda-forge
sip                       4.19.8          py36hf484d3e_1000    conda-forge
siphon                    0.8.0                 py36_1001    conda-forge
six                       1.12.0                py36_1000    conda-forge
smartsheet-python-sdk     1.3.4.dev3+ga1559f8          pypi_0    pypi
snowballstemmer           1.2.1                      py_1    conda-forge
snuggs                    1.4.6                      py_0    conda-forge
sortedcontainers          2.1.0                      py_0    conda-forge
soupsieve                 1.9.1                    py36_0    conda-forge
sphinx                    2.1.2                      py_0    conda-forge
sphinxcontrib-applehelp   1.0.1                      py_0    conda-forge
sphinxcontrib-devhelp     1.0.1                      py_0    conda-forge
sphinxcontrib-htmlhelp    1.0.2                      py_0    conda-forge
sphinxcontrib-jsmath      1.0.1                      py_0    conda-forge
sphinxcontrib-napoleon    0.6.1                    pypi_0    pypi
sphinxcontrib-qthelp      1.0.2                      py_0    conda-forge
sphinxcontrib-serializinghtml 1.1.1                      py_0    conda-forge
sphinxcontrib-websupport  1.1.2                      py_0    conda-forge
sqlalchemy                1.3.4            py36h516909a_0    conda-forge
sqlite                    3.28.0               h8b20d00_0    conda-forge
statsmodels               0.9.0           py36h3010b51_1000    conda-forge
tblib                     1.4.0                      py_0    conda-forge
tempest-remap             2.0.3                h5f743cb_0    conda-forge
terminado                 0.8.2                    py36_0    conda-forge
testpath                  0.4.2                   py_1001    conda-forge
textgenrnn                1.5.0                    pypi_0    pypi
tk                        8.6.9             hed695b0_1002    conda-forge
tlslite                   0.4.9                    pypi_0    pypi
toml                      0.9.4                    pypi_0    pypi
toolz                     0.9.0                      py_1    conda-forge
tornado                   6.0.3            py36h516909a_0    conda-forge
tox                       3.4.0                    pypi_0    pypi
tqdm                      4.32.2                     py_0    conda-forge
traitlets                 4.3.2                 py36_1000    conda-forge
twine                     1.13.0                     py_1    conda-forge
twisted                   19.2.1           py36h516909a_0    conda-forge
twittytwister             0.1.3                    pypi_0    pypi
twython                   3.7.0                      py_0    conda-forge
txyam2                    0.5.1+weasyl.2           pypi_0    pypi
typed-ast                 1.4.0            py36h516909a_0    conda-forge
typing                    3.6.4                    py36_0    conda-forge
tzcode                    2019a             h516909a_1002    conda-forge
udunits2                  2.2.27.6          h4e0c4b3_1001    conda-forge
unidecode                 1.0.22                   pypi_0    pypi
unixodbc                  2.3.7             h227dcee_1000    conda-forge
uritemplate               3.0.0                      py_1    conda-forge
urllib3                   1.24.3                   py36_0    conda-forge
util-linux                2.21                          0  
verde                     0.0.1a0+72.g9ae9091          pypi_0    pypi
virtualenv                16.0.0                   pypi_0    pypi
wcwidth                   0.1.7                      py_1    conda-forge
webencodings              0.5.1                      py_1    conda-forge
wheel                     0.33.4                   py36_0    conda-forge
windrose                  1.6                      pypi_0    pypi
wordcloud                 1.5.0           py36h14c3975_1000    conda-forge
wrapt                     1.11.1           py36h516909a_0    conda-forge
wrf-python                1.3.2            py36h6091dcd_0    conda-forge
xarray                    0.12.1                     py_0    conda-forge
xerces-c                  3.2.2             hac72e42_1001    conda-forge
xlrd                      1.2.0                      py_0    conda-forge
xlsxwriter                1.1.8                      py_0    conda-forge
xlwt                      1.3.0                      py_1    conda-forge
xorg-imake                1.0.7                         0    conda-forge
xorg-kbproto              1.0.7             h14c3975_1002    conda-forge
xorg-libice               1.0.9             h516909a_1004    conda-forge
xorg-libsm                1.2.3             h84519dc_1000    conda-forge
xorg-libx11               1.6.7             h14c3975_1000    conda-forge
xorg-libxau               1.0.9                h14c3975_0    conda-forge
xorg-libxaw               1.0.13            h14c3975_1002    conda-forge
xorg-libxdmcp             1.1.3                h516909a_0    conda-forge
xorg-libxext              1.3.4                h516909a_0    conda-forge
xorg-libxmu               1.1.3                h516909a_0    conda-forge
xorg-libxpm               3.5.12            h14c3975_1002    conda-forge
xorg-libxrender           0.9.10            h516909a_1002    conda-forge
xorg-libxt                1.1.5             h516909a_1003    conda-forge
xorg-makedepend           1.0.6                he1b5a44_1    conda-forge
xorg-renderproto          0.11.1            h14c3975_1002    conda-forge
xorg-xextproto            7.3.0             h14c3975_1002    conda-forge
xorg-xproto               7.0.31            h14c3975_1007    conda-forge
xz                        5.2.4             h14c3975_1001    conda-forge
yaml                      0.1.7             h14c3975_1001    conda-forge
zeromq                    4.3.1             hf484d3e_1000    conda-forge
zict                      0.1.4                      py_0    conda-forge
zipp                      0.5.1                      py_0    conda-forge
zlib                      1.2.11            h14c3975_1004    conda-forge
zope.interface            4.6.0           py36h14c3975_1000    conda-forge
zstd                      1.4.0                h3b9ef0a_0    conda-forge

Details about conda and system ( conda info ):

     active environment : prod
    active env location : /opt/miniconda3/envs/prod
            shell level : 1
       user config file : /home/akrherz/.condarc
 populated config files : /home/akrherz/.condarc
          conda version : 4.6.14
    conda-build version : not installed
         python version : 3.6.7.final.0
       base environment : /opt/miniconda3  (writable)
           channel URLs : https://conda.anaconda.org/conda-forge/linux-64
                          https://conda.anaconda.org/conda-forge/noarch
                          https://repo.anaconda.com/pkgs/main/linux-64
                          https://repo.anaconda.com/pkgs/main/noarch
                          https://repo.anaconda.com/pkgs/free/linux-64
                          https://repo.anaconda.com/pkgs/free/noarch
                          https://repo.anaconda.com/pkgs/r/linux-64
                          https://repo.anaconda.com/pkgs/r/noarch
          package cache : /opt/miniconda3/pkgs
                          /home/akrherz/.conda/pkgs
       envs directories : /opt/miniconda3/envs
                          /home/akrherz/.conda/envs
               platform : linux-64
             user-agent : conda/4.6.14 requests/2.22.0 CPython/3.6.7 Linux/3.10.0-957.21.3.el7.x86_64 rhel/7.6 glibc/2.17
                UID:GID : 1000:1000
             netrc file : /home/akrherz/.netrc
           offline mode : False

Create a v13.x maintenance branch with a 13.5 build supporting openssl3

Issue

Presently within conda-forge, there is no libpq=13 + openssl3 build. There are some dependency combinations, like what I am finding in conda-forge/gdal-feedstock#590 that could use such a combination.

The Postgresql 13.5 Release Notes indicate openssl3 support was added with that point release.

Proposal

I'd like to create a v13.x maintenance branch with a 13.5 release and run the openssl3 migration with it.

I'm happy to do all the work here, just would need for somebody to kindly review the PRs...

Thanks for the consideration.

No resolvable combination of libpq=16 openssl=3.2 libxml2=2.11

Comment:

With the pain involved this week with #191 and the builds that got marked broken as a result, we are left with an unresolvable combination of this:

$ mamba create -n dev libpq=16 openssl=3.2 libxml2=2.11
Could not solve for environment specs
The following packages are incompatible
├─ libpq 16**  is installable with the potential options
│  ├─ libpq 16.0 would require
│  │  └─ openssl >=3.1.3,<3.2.0a0 , which can be installed;
│  ├─ libpq 16.1 would require
│  │  └─ libxml2 >=2.12.2,<2.13.0a0 , which can be installed;
│  └─ libpq 16.1 would require
│     └─ openssl >=3.1.4,<3.2.0a0 , which can be installed;
├─ libxml2 2.11**  is not installable because it conflicts with any installable versions previously reported;
└─ openssl 3.2**  is not installable because it conflicts with any installable versions previously reported.

This is not allowing gdal=3.8.1 to install, see conda-forge/gdal-feedstock#867

It may be helpful to make an intermediate build against libxml2 2.11, but can certainly understand if there isn't an appetite here to go messing with postgresql builds for a while :/

Please compile with readline support

I am thankful for the efforts made to provide postgresql for conda, but not having readline support make usage of psql not much fun :( I assume there is a valid reason for not including it, so am curious about it. Seems like readline is in conda already?

conda-forge / postgresql-feedstock Goto Github PK

postgresql-feedstock's Introduction

About postgresql-split-feedstock

About postgresql-split

About libpq

About postgresql

About postgresql-plpython

Current build status

Current release info

Installing postgresql-split

About conda-forge

Terminology

Updating postgresql-split-feedstock

Feedstock Maintainers

postgresql-feedstock's People

Contributors

Stargazers

Watchers

Forkers

postgresql-feedstock's Issues

Comment:

Comment:

Comment:

Comment:

Comment:

Comment:

Issue

Proposal

Comment:

Recommend Projects

Recommend Topics

Recommend Org