conda-forge / psycopg2-feedstock

A conda-smithy repository for psycopg2.

About psycopg-split-feedstock

Feedstock license: BSD-3-Clause

Home: https://psycopg.org/psycopg3/

Package license: LGPL-3.0-or-later

Summary: PostgreSQL database adapter for Python

Development: https://github.com/psycopg/psycopg/

Documentation: https://www.psycopg.org/psycopg3/docs/

Psycopg 3 is a newly designed PostgreSQL database adapter for the Python programming language. Psycopg 3 presents a familiar interface for everyone who has used Psycopg 2 or any other DB-API 2.0 database adapter, but allows to use more modern PostgreSQL and Python features.

Current build status

Azure

Variant Status linux_64_python3.10.____cpython linux_64_python3.11.____cpython linux_64_python3.12.____cpython linux_64_python3.8.____cpython linux_64_python3.9.____cpython linux_aarch64_python3.10.____cpython linux_aarch64_python3.11.____cpython linux_aarch64_python3.12.____cpython linux_aarch64_python3.8.____cpython linux_aarch64_python3.9.____cpython linux_ppc64le_python3.10.____cpython linux_ppc64le_python3.11.____cpython linux_ppc64le_python3.12.____cpython linux_ppc64le_python3.8.____cpython linux_ppc64le_python3.9.____cpython osx_64_python3.10.____cpython osx_64_python3.11.____cpython osx_64_python3.12.____cpython osx_64_python3.8.____cpython osx_64_python3.9.____cpython osx_arm64_python3.10.____cpython osx_arm64_python3.11.____cpython osx_arm64_python3.12.____cpython osx_arm64_python3.8.____cpython osx_arm64_python3.9.____cpython win_64_python3.10.____cpython win_64_python3.11.____cpython win_64_python3.12.____cpython win_64_python3.8.____cpython win_64_python3.9.____cpython

Current release info

Name	Downloads	Version	Platforms

Installing psycopg-split

Installing psycopg-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, psycopg, psycopg-c can be installed with conda:

conda install psycopg psycopg-c

or with mamba:

mamba install psycopg psycopg-c

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

conda search psycopg --channel conda-forge

or with mamba:

mamba search psycopg --channel conda-forge

Alternatively, mamba repoquery may provide more information:

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

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

# List dependencies of `psycopg`:
mamba repoquery depends psycopg --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 psycopg-split-feedstock

If you would like to improve the psycopg-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/psycopg-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

• @msarahan
• @ocefpaf
• @xylar

psycopg2-feedstock's Issues

psycopg3 was released, is there a plan to put it on a feedstock?

• I read the conda-forge documentation and could not find the solution for my problem there.

Issue:
I don't know where the correct place to ask is. Psycopg3 was released in October 2021. Is the plan to update this feedstock to 3 or to open a new one in parallel with this one?

psycopg-binary and psycopg-pool

Comment:

If upstream requires both psycopg-binary and psycopg-pool, are these currently provided by this feedstock at all implicitly?

Ref here:

No option for python=3.8 postgresql=12 and psycopg2

On Linux64 I try:

$ conda create -n py38 python=3.8 postgresql=12 psycopg2
Collecting package metadata (current_repodata.json): done
Solving environment: failed with repodata from current_repodata.json, will retry with next repodata source.
Collecting package metadata (repodata.json): done
Solving environment: \ 
Found conflicts! Looking for incompatible packages.
This can take several minutes.  Press CTRL-C to abort.
failed                                                                                                                                                                                                     

UnsatisfiableError: The following specifications were found to be incompatible with each other:

Output in format: Requested package -> Available versions

Package libpq conflicts for:
postgresql=12 -> libpq==12.1=hd9ab2ff_0
psycopg2 -> libpq[version='>=10.3,<11.0a0|>=10.5,<11.0a0|>=10.6,<11.0a0|>=11.2,<12.0a0|>=11.3,<12.0a0|>=11.5,<12.0a0|>=11.1,<12.0a0|>=9.6.6']

Package libedit conflicts for:
python=3.8 -> sqlite[version='>=3.30.1,<4.0a0'] -> libedit[version='>=3.1.20181209,<3.2.0a0']
postgresql=12 -> krb5[version='>=1.16.3,<1.17.0a0'] -> libedit[version='>=3.1.20170329,<4.0a0|>=3.1.20181209,<3.2.0a0|>=3.1.20181209,<4.0a0']

Package ncurses conflicts for:
psycopg2 -> python[version='>=3.8,<3.9.0a0'] -> ncurses[version='5.9|5.9.*|>=6.1,<6.2.0a0|>=6.1,<7.0a0|>=6.0,<7.0a0|6.0.*']
python=3.8 -> readline[version='>=7.0,<8.0a0'] -> ncurses[version='5.9.*|>=6.0,<7.0a0|6.0.*']
postgresql=12 -> readline[version='>=8.0,<9.0a0'] -> ncurses[version='>=6.1,<6.2.0a0']
python=3.8 -> ncurses[version='>=6.1,<6.2.0a0|>=6.1,<7.0a0']

Package openssl conflicts for:
psycopg2 -> openssl[version='1.0.*|>=1.0.2o,<1.0.3a|>=1.0.2p,<1.0.3a|>=1.1.1a,<1.1.2a|>=1.1.1d,<1.1.2a|>=1.0.2n,<1.0.3a|>=1.0.2m,<1.0.3a']
psycopg2 -> python[version='>=3.7,<3.8.0a0'] -> openssl[version='>=1.0.2l,<1.0.3a|>=1.1.1b,<1.1.2a|>=1.1.1c,<1.1.2a']

Package python conflicts for:
python=3.8
psycopg2 -> python[version='2.7.*|3.5.*|3.6.*|>=2.7,<2.8.0a0|>=3.7,<3.8.0a0|>=3.8,<3.9.0a0|>=3.6,<3.7.0a0|>=3.5,<3.6.0a0|3.4.*']
Note that strict channel priority may have removed packages required for satisfiability.

It would appear that the combination of postgresql=12 and psycopg2 is not possible with conda-forge ? thanks

[warning] failed package validation and/or copy for commit 82b9ec2da69af26da27370e67990dbf2abd64c39

Hi @conda-forge/psycopg2! This is the friendly automated conda-forge-webservice!

It appears that one or more of your feedstock's outputs did not copy from the
staging channel (cf-staging) to the production channel (conda-forge). :(

This failure can happen for a lot of reasons, including an outdated feedstock
token. Below we have put some information about the failure to help you debug it.

Rerendering the feedstock will usually fix these problems.

If you have any issues or questions, you can find us on gitter in the
community chat room or you can bump us right here.

error messages:

• invalid feedstock token

Figure out a way to shim psycopg2-binary?

Thanks for packaging psycopg2!

On a number of complex feedstocks, e.g. https://github.com/conda-forge/dagster-feedstock, we can't use pip check because psycopg2-binary is not available as a distribution, even though they both populate site-packages/psycopg2.

This has also lead to further confusion, including a new staged-recipes PR: conda-forge/staged-recipes#12071

Perhaps there would be a way to make a psycopg2-binary in outputs (with a basically-empty distribution) that hard-pinned to the psycopg2 version? Seems kind of dirty, and might create other problems, I guess...

psycopg 3.1.9 pip installing typing-extensions and tzdata overwriting conda dependencies

Solution to issue cannot be found in the documentation.

• I checked the documentation.

Issue

I create a new environment containing just psycopg 3.1.9, e.g.

mamba create -n test -c conda-forge psycopg=3.1.9

I see all the listed dependencies are from conda-forge.

After the environment is created though, when I list the installed packages I see the typing-extensions has been overwritten by a lower version of the pypi package, and tzdata has also been replaced by a pypi package. See screenshots below:

Installed packages

N/A

Environment info

active environment : test
    active env location : C:\Users\OwenLamont\miniconda3\envs\test
            shell level : 4
       user config file : C:\Users\OwenLamont\.condarc
 populated config files : C:\Users\OwenLamont\.condarc
          conda version : 23.3.1
    conda-build version : not installed
         python version : 3.11.3.final.0
       virtual packages : __archspec=1=x86_64
                          __win=0=0
       base environment : C:\Users\OwenLamont\miniconda3  (writable)
      conda av data dir : C:\Users\OwenLamont\miniconda3\etc\conda
  conda av metadata url : None
           channel URLs : https://conda.anaconda.org/conda-forge/win-64
                          https://conda.anaconda.org/conda-forge/noarch
          package cache : C:\Users\OwenLamont\miniconda3\pkgs
                          C:\Users\OwenLamont\.conda\pkgs
                          C:\Users\OwenLamont\AppData\Local\conda\conda\pkgs
       envs directories : C:\Users\OwenLamont\miniconda3\envs
                          C:\Users\OwenLamont\.conda\envs
                          C:\Users\OwenLamont\AppData\Local\conda\conda\envs
               platform : win-64
             user-agent : conda/23.3.1 requests/2.31.0 CPython/3.11.3 Windows/10 Windows/10.0.22621
          administrator : False
             netrc file : None
           offline mode : False

Break the hard links in the recipe

The recipe (if I'm reading it correctly) uses install_name_tool on Mac to change some files from other packages. It should break the hard links first, so that if someone builds this package it doesn't corrupt their package cache.

See https://github.com/conda-forge/staged-recipes/pull/1162/files/a12ed4978c2b215d2583d324547113bebe53aa2a#r75533371

update to version 2.7

Psycopg2 segfaults with openssl == 3.2.0

Solution to issue cannot be found in the documentation.

• I checked the documentation.

Issue

Upstream postgres had a bug in its usage of openssl that caused it segfault with OpenSSL 3.2.0. This was fixed: conda-forge/postgresql-feedstock#178 . However, I still see the segfault when using psycopg2. Is the binary statically linked or some such?

Installed packages

# Name                    Version                   Build  Channel
_libgcc_mutex             0.1                 conda_forge    conda-forge
_openmp_mutex             4.5                       2_gnu    conda-forge
_r-mutex                  1.0.1               anacondar_1    conda-forge
annotated-types           0.6.0              pyhd8ed1ab_0    conda-forge
astor                     0.8.1              pyh9f0ad1d_0    conda-forge
aws-c-auth                0.7.7                h4faf3ed_1    conda-forge
aws-c-cal                 0.6.9                h3b91eb8_1    conda-forge
aws-c-common              0.9.8                hd590300_0    conda-forge
aws-c-compression         0.2.17               hfd9eb17_6    conda-forge
aws-c-event-stream        0.3.2                h1fff966_7    conda-forge
aws-c-http                0.7.14               hc86c171_2    conda-forge
aws-c-io                  0.13.36              hc23c90e_0    conda-forge
aws-c-mqtt                0.9.10               hba57965_1    conda-forge
aws-c-s3                  0.4.1                hfadff92_0    conda-forge
aws-c-sdkutils            0.1.12               hfd9eb17_5    conda-forge
aws-checksums             0.1.17               hfd9eb17_5    conda-forge
aws-crt-cpp               0.24.7               h97e63c7_6    conda-forge
aws-sdk-cpp               1.11.182             h8beafcf_7    conda-forge
bash-completion           2.11                 ha770c72_1    conda-forge
bcrypt                    4.0.1            py39h9fdd4d6_1    conda-forge
beautifulsoup4            4.12.2             pyha770c72_0    conda-forge
binutils                  2.40                 hdd6e379_0    conda-forge
binutils_impl_linux-64    2.40                 hf600244_0    conda-forge
binutils_linux-64         2.40                 hbdbef99_2    conda-forge
boltons                   23.0.0             pyhd8ed1ab_0    conda-forge
brotli-python             1.1.0            py39h3d6467e_1    conda-forge
bwidget                   1.9.14               ha770c72_1    conda-forge
bzip2                     1.0.8                hd590300_5    conda-forge
c-ares                    1.22.1               hd590300_0    conda-forge
ca-certificates           2023.11.17           hbcca054_0    conda-forge
cached-property           1.5.2                hd8ed1ab_1    conda-forge
cached_property           1.5.2              pyha770c72_1    conda-forge
cairo                     1.18.0               h3faef2a_0    conda-forge
cctools                   949.0.1              h22b1bf0_7    conda-forge
cctools_osx-64            949.0.1              h5a3fd96_7    conda-forge
cffi                      1.16.0           py39h7a31438_0    conda-forge
chardet                   5.2.0            py39hf3d152e_1    conda-forge
click                     8.1.7           unix_pyh707e725_0    conda-forge
cmdstan                   2.33.1               hff4ab46_0    conda-forge
cmdstanpy                 1.2.0              pyhd8ed1ab_0    conda-forge
colorama                  0.4.6              pyhd8ed1ab_0    conda-forge
conda                     23.9.0           py39hf3d152e_0    conda-forge
conda-build               3.27.0           py39hf3d152e_0    conda-forge
conda-index               0.2.3              pyhd8ed1ab_0    conda-forge
conda-package-handling    2.2.0              pyh38be061_0    conda-forge
conda-package-streaming   0.9.0              pyhd8ed1ab_0    conda-forge
conda-tree                1.1.0              pyhd8ed1ab_2    conda-forge
coreutils                 9.4                  hd590300_0    conda-forge
cryptography              41.0.5           py39hd4f0224_0    conda-forge
curl                      8.4.0                hca28451_0    conda-forge
docker-py                 6.1.3              pyhd8ed1ab_0    conda-forge
docstring_parser          0.15               pyhd8ed1ab_0    conda-forge
expat                     2.5.0                hcb278e6_1    conda-forge
font-ttf-dejavu-sans-mono 2.37                 hab24e00_0    conda-forge
font-ttf-inconsolata      3.000                h77eed37_0    conda-forge
font-ttf-source-code-pro  2.038                h77eed37_0    conda-forge
font-ttf-ubuntu           0.83                 h77eed37_1    conda-forge
fontconfig                2.14.2               h14ed4e7_0    conda-forge
fonts-conda-ecosystem     1                             0    conda-forge
fonts-conda-forge         1                             0    conda-forge
formulaic                 0.6.6              pyhd8ed1ab_0    conda-forge
freetype                  2.12.1               h267a509_2    conda-forge
fribidi                   1.0.10               h36c2ea0_0    conda-forge
gcc                       12.3.0               h8d2909c_2    conda-forge
gcc_impl_linux-64         12.3.0               he2b93b0_3    conda-forge
gcc_linux-64              12.3.0               h76fc315_2    conda-forge
gdb                       12.1             py39hf8bf4ad_0    conda-forge
gettext                   0.21.1               h27087fc_0    conda-forge
gflags                    2.2.2             he1b5a44_1004    conda-forge
gfortran                  12.3.0               h499e0f7_2    conda-forge
gfortran_impl_linux-64    12.3.0               hfcedea8_3    conda-forge
glog                      0.6.0                h6f12383_0    conda-forge
gmp                       6.3.0                h59595ed_0    conda-forge
gmpy2                     2.1.2            py39h376b7d2_1    conda-forge
graphite2                 1.3.13            h58526e2_1001    conda-forge
graphlib-backport         1.0.3              pyhd8ed1ab_0    conda-forge
gxx                       12.3.0               h8d2909c_2    conda-forge
gxx_impl_linux-64         12.3.0               he2b93b0_3    conda-forge
gxx_linux-64              12.3.0               h8a814eb_2    conda-forge
harfbuzz                  8.3.0                h3d44ed6_0    conda-forge
icu                       73.2                 h59595ed_0    conda-forge
idna                      3.4                pyhd8ed1ab_0    conda-forge
importlib-metadata        6.8.0              pyha770c72_0    conda-forge
inflect                   7.0.0              pyhd8ed1ab_0    conda-forge
interface_meta            1.3.0              pyhd8ed1ab_0    conda-forge
jinja2                    3.1.2              pyhd8ed1ab_1    conda-forge
jsonpatch                 1.33               pyhd8ed1ab_0    conda-forge
jsonpointer               2.4              py39hf3d152e_3    conda-forge
kernel-headers_linux-64   2.6.32              he073ed8_16    conda-forge
keyutils                  1.6.1                h166bdaf_0    conda-forge
krb5                      1.21.2               h659d440_0    conda-forge
lazy-object-proxy         1.9.0            py39hd1e30aa_1    conda-forge
ld64                      530                           7    conda-forge
ld64_osx-64               530                  h3104ce3_7    conda-forge
ld_impl_linux-64          2.40                 h41732ed_0    conda-forge
lerc                      4.0.0                h27087fc_0    conda-forge
libabseil                 20230802.1      cxx17_h59595ed_0    conda-forge
libarchive                3.7.2                h039dbb9_0    conda-forge
libarrow                  14.0.1           h2b6da2a_4_cpu    conda-forge
libarrow-acero            14.0.1           h59595ed_4_cpu    conda-forge
libarrow-dataset          14.0.1           h59595ed_4_cpu    conda-forge
libarrow-flight           14.0.1           h120cb0d_4_cpu    conda-forge
libarrow-flight-sql       14.0.1           h61ff412_4_cpu    conda-forge
libarrow-gandiva          14.0.1           hacb8726_4_cpu    conda-forge
libarrow-substrait        14.0.1           h61ff412_4_cpu    conda-forge
libblas                   3.9.0           20_linux64_openblas    conda-forge
libbrotlicommon           1.1.0                hd590300_1    conda-forge
libbrotlidec              1.1.0                hd590300_1    conda-forge
libbrotlienc              1.1.0                hd590300_1    conda-forge
libcblas                  3.9.0           20_linux64_openblas    conda-forge
libcrc32c                 1.1.2                h9c3ff4c_0    conda-forge
libcurl                   8.4.0                hca28451_0    conda-forge
libdeflate                1.19                 hd590300_0    conda-forge
libedit                   3.1.20191231         he28a2e2_2    conda-forge
libev                     4.33                 h516909a_1    conda-forge
libevent                  2.1.12               hf998b51_1    conda-forge
libexpat                  2.5.0                hcb278e6_1    conda-forge
libffi                    3.4.2                h7f98852_5    conda-forge
libgcc-devel_linux-64     12.3.0             h8bca6fd_103    conda-forge
libgcc-ng                 13.2.0               h807b86a_3    conda-forge
libgfortran-ng            13.2.0               h69a702a_3    conda-forge
libgfortran5              13.2.0               ha4646dd_3    conda-forge
libgit2                   1.7.1                hca3a8ce_0    conda-forge
libglib                   2.78.1               hebfc3b9_0    conda-forge
libgomp                   13.2.0               h807b86a_3    conda-forge
libgoogle-cloud           2.12.0               h5206363_4    conda-forge
libgrpc                   1.59.3               hd6c4280_0    conda-forge
libhwloc                  2.9.3           default_h554bfaf_1009    conda-forge
libiconv                  1.17                 h166bdaf_0    conda-forge
libjpeg-turbo             3.0.0                hd590300_1    conda-forge
liblapack                 3.9.0           20_linux64_openblas    conda-forge
liblief                   0.12.3               h27087fc_0    conda-forge
libllvm10                 10.0.1               he513fc3_3    conda-forge
libllvm15                 15.0.7               h5cf9203_3    conda-forge
libnghttp2                1.58.0               h47da74e_0    conda-forge
libnsl                    2.0.1                hd590300_0    conda-forge
libnuma                   2.0.16               h0b41bf4_1    conda-forge
libopenblas               0.3.25          pthreads_h413a1c8_0    conda-forge
libparquet                14.0.1           h352af49_4_cpu    conda-forge
libpng                    1.6.39               h753d276_0    conda-forge
libpq                     16.1                 hfc447b1_0    conda-forge
libprotobuf               4.24.4               hf27288f_0    conda-forge
libre2-11                 2023.06.02           h7a70373_0    conda-forge
libsanitizer              12.3.0               h0f45ef3_3    conda-forge
libsodium                 1.0.18               h36c2ea0_1    conda-forge
libsqlite                 3.44.2               h2797004_0    conda-forge
libssh2                   1.11.0               h0841786_0    conda-forge
libstdcxx-devel_linux-64  12.3.0             h8bca6fd_103    conda-forge
libstdcxx-ng              13.2.0               h7e041cc_3    conda-forge
libthrift                 0.19.0               hb90f79a_1    conda-forge
libtiff                   4.6.0                ha9c0a0a_2    conda-forge
libunwind                 1.6.2                h9c3ff4c_0    conda-forge
libutf8proc               2.8.0                h166bdaf_0    conda-forge
libuuid                   2.38.1               h0b41bf4_0    conda-forge
libuv                     1.46.0               hd590300_0    conda-forge
libv8                     8.9.83               ha8e4f12_4    conda-forge
libwebp-base              1.3.2                hd590300_0    conda-forge
libxcb                    1.15                 h0b41bf4_0    conda-forge
libxml2                   2.11.6               h232c23b_0    conda-forge
libzlib                   1.2.13               hd590300_5    conda-forge
lz4-c                     1.9.4                hcb278e6_0    conda-forge
lzo                       2.10              h516909a_1000    conda-forge
make                      4.3                  hd18ef5c_1    conda-forge
markupsafe                2.1.3            py39hd1e30aa_1    conda-forge
meson                     1.2.3              pyhd8ed1ab_0    conda-forge
more-itertools            10.1.0             pyhd8ed1ab_0    conda-forge
mpc                       1.3.1                hfe3b2da_0    conda-forge
mpfr                      4.2.1                h9458935_0    conda-forge
mpmath                    1.3.0              pyhd8ed1ab_0    conda-forge
ncurses                   6.4                  h59595ed_2    conda-forge
ninja                     1.11.1               h924138e_0    conda-forge
nodejs                    20.8.1               h1990674_0    conda-forge
numpy                     1.24.4           py39h6183b62_0    conda-forge
openjdk                   8.0.382              hd590300_0    conda-forge
openssl                   3.1.4                hd590300_0    conda-forge
orc                       1.9.2                h4b38347_0    conda-forge
packaging                 23.2               pyhd8ed1ab_0    conda-forge
pandas                    2.1.3            py39hddac248_0    conda-forge
pandoc                    3.1.3                h32600fe_0    conda-forge
pango                     1.50.14              ha41ecd1_2    conda-forge
paramiko                  3.3.1              pyhd8ed1ab_0    conda-forge
patch                     2.7.6             h7f98852_1002    conda-forge
patchelf                  0.17.2               h58526e2_0    conda-forge
patsy                     0.5.3              pyhd8ed1ab_0    conda-forge
pcre2                     10.40                hc3806b6_0    conda-forge
pip                       23.3.1             pyhd8ed1ab_0    conda-forge
pipdeptree                2.9.1              pyhd8ed1ab_0    conda-forge
pixman                    0.42.2               h59595ed_0    conda-forge
pkginfo                   1.9.6              pyhd8ed1ab_0    conda-forge
pluggy                    1.3.0              pyhd8ed1ab_0    conda-forge
psutil                    5.9.5            py39hd1e30aa_1    conda-forge
psycopg2                  2.9.7            py39h89197e3_1    conda-forge
pthread-stubs             0.4               h36c2ea0_1001    conda-forge
py-lief                   0.12.3           py39h5a03fae_0    conda-forge
py-spy                    0.3.14               h87a5ac0_0    conda-forge
pyarrow                   14.0.1          py39h6925388_4_cpu    conda-forge
pycosat                   0.6.6            py39hd1e30aa_0    conda-forge
pycparser                 2.21               pyhd8ed1ab_0    conda-forge
pydantic                  2.5.2              pyhd8ed1ab_0    conda-forge
pydantic-core             2.14.5           py39h9fdd4d6_0    conda-forge
pygments                  2.17.2             pyhd8ed1ab_0    conda-forge
pynacl                    1.5.0            py39hd1e30aa_3    conda-forge
pyopenssl                 23.3.0             pyhd8ed1ab_0    conda-forge
pysocks                   1.7.1              pyha2e5f31_6    conda-forge
python                    3.9.18          h0755675_0_cpython    conda-forge
python-dateutil           2.8.2              pyhd8ed1ab_0    conda-forge
python-libarchive-c       5.0              py39hf3d152e_2    conda-forge
python-tzdata             2023.3             pyhd8ed1ab_0    conda-forge
python_abi                3.9                      4_cp39    conda-forge
pytz                      2023.3.post1       pyhd8ed1ab_0    conda-forge
pywin32-on-windows        0.1.0              pyh1179c8e_3    conda-forge
pyyaml                    6.0.1            py39hd1e30aa_1    conda-forge
r-arrow                   14.0.1            r43h59595ed_0    conda-forge
r-askpass                 1.2.0             r43h57805ef_0    conda-forge
r-assertthat              0.2.1             r43hc72bb7e_4    conda-forge
r-backports               1.4.1             r43h57805ef_2    conda-forge
r-base                    4.3.2                h93585b2_0    conda-forge
r-base64enc               0.1_3           r43h57805ef_1006    conda-forge
r-bigd                    0.2.0             r43hc72bb7e_1    conda-forge
r-bit                     4.0.5             r43h57805ef_1    conda-forge
r-bit64                   4.0.5             r43h57805ef_2    conda-forge
r-bitops                  1.0_7             r43h57805ef_2    conda-forge
r-brew                    1.0_8             r43hc72bb7e_2    conda-forge
r-brio                    1.1.3             r43h57805ef_2    conda-forge
r-bslib                   0.6.1             r43hc72bb7e_0    conda-forge
r-cachem                  1.0.8             r43h57805ef_1    conda-forge
r-callr                   3.7.3             r43hc72bb7e_1    conda-forge
r-caret                   6.0_94            r43h57805ef_1    conda-forge
r-class                   7.3_22            r43h57805ef_1    conda-forge
r-cli                     3.6.1             r43ha503ecb_1    conda-forge
r-clipr                   0.8.0             r43hc72bb7e_2    conda-forge
r-clock                   0.7.0             r43ha503ecb_1    conda-forge
r-codetools               0.2_19            r43hc72bb7e_1    conda-forge
r-colorspace              2.1_0             r43h57805ef_1    conda-forge
r-commonmark              1.9.0             r43h57805ef_1    conda-forge
r-conquer                 1.3.3             r43h08d816e_2    conda-forge
r-cpp11                   0.4.6             r43hc72bb7e_0    conda-forge
r-crayon                  1.5.2             r43hc72bb7e_2    conda-forge
r-credentials             2.0.1             r43hc72bb7e_0    conda-forge
r-curl                    5.1.0             r43hf9611b0_0    conda-forge
r-cyclocomp               1.1.1             r43hc72bb7e_0    conda-forge
r-data.table              1.14.8            r43h029312a_2    conda-forge
r-desc                    1.4.2             r43hc72bb7e_2    conda-forge
r-devtools                2.4.5             r43hc72bb7e_2    conda-forge
r-diagram                 1.6.5             r43ha770c72_2    conda-forge
r-diffobj                 0.3.5             r43h57805ef_2    conda-forge
r-digest                  0.6.33            r43ha503ecb_0    conda-forge
r-downlit                 0.4.3             r43hc72bb7e_0    conda-forge
r-dplyr                   1.1.4             r43ha503ecb_0    conda-forge
r-e1071                   1.7_13            r43ha503ecb_1    conda-forge
r-ellipsis                0.3.2             r43h57805ef_2    conda-forge
r-evaluate                0.23              r43hc72bb7e_0    conda-forge
r-fansi                   1.0.5             r43h57805ef_0    conda-forge
r-farver                  2.1.1             r43ha503ecb_2    conda-forge
r-fastmap                 1.1.1             r43ha503ecb_1    conda-forge
r-fontawesome             0.5.2             r43hc72bb7e_0    conda-forge
r-forcats                 1.0.0             r43hc72bb7e_1    conda-forge
r-foreach                 1.5.2             r43hc72bb7e_2    conda-forge
r-fs                      1.6.3             r43ha503ecb_0    conda-forge
r-future                  1.33.0            r43hc72bb7e_0    conda-forge
r-future.apply            1.11.0            r43hc72bb7e_1    conda-forge
r-generics                0.1.3             r43hc72bb7e_2    conda-forge
r-gert                    2.0.0             r43hc25a090_0    conda-forge
r-ggplot2                 3.4.4             r43hc72bb7e_0    conda-forge
r-gh                      1.4.0             r43hc72bb7e_1    conda-forge
r-gitcreds                0.1.2             r43hc72bb7e_2    conda-forge
r-glmnet                  4.1_8             r43hcf54a89_0    conda-forge
r-globals                 0.16.2            r43hc72bb7e_1    conda-forge
r-glue                    1.6.2             r43h57805ef_2    conda-forge
r-gower                   1.0.1             r43h57805ef_1    conda-forge
r-gsdesign                3.6.0             r43h57805ef_0    conda-forge
r-gt                      0.10.0            r43hc72bb7e_0    conda-forge
r-gtable                  0.3.4             r43hc72bb7e_0    conda-forge
r-hardhat                 1.3.0             r43hc72bb7e_1    conda-forge
r-highr                   0.10              r43hc72bb7e_1    conda-forge
r-htmltools               0.5.7             r43ha503ecb_0    conda-forge
r-htmlwidgets             1.6.3             r43hc72bb7e_0    conda-forge
r-httpuv                  1.6.12            r43ha503ecb_0    conda-forge
r-httr                    1.4.7             r43hc72bb7e_0    conda-forge
r-httr2                   1.0.0             r43hc72bb7e_0    conda-forge
r-ini                     0.3.1           r43hc72bb7e_1005    conda-forge
r-ipred                   0.9_14            r43h57805ef_1    conda-forge
r-irdisplay               1.1               r43hd8ed1ab_2    conda-forge
r-irkernel                1.3.2             r43h785f33e_1    conda-forge
r-isoband                 0.2.7             r43ha503ecb_2    conda-forge
r-iterators               1.0.14            r43hc72bb7e_2    conda-forge
r-jquerylib               0.1.4             r43hc72bb7e_2    conda-forge
r-jsonlite                1.8.7             r43h57805ef_0    conda-forge
r-juicyjuice              0.1.0             r43hc72bb7e_1    conda-forge
r-kernsmooth              2.23_22           r43h13b3f57_0    conda-forge
r-knitr                   1.45              r43hc72bb7e_0    conda-forge
r-labeling                0.4.3             r43hc72bb7e_0    conda-forge
r-later                   1.3.1             r43ha503ecb_1    conda-forge
r-lattice                 0.22_5            r43h57805ef_0    conda-forge
r-lava                    1.7.3             r43hc72bb7e_0    conda-forge
r-lazyeval                0.2.2             r43h57805ef_4    conda-forge
r-lifecycle               1.0.4             r43hc72bb7e_0    conda-forge
r-lintr                   3.1.1             r43hc72bb7e_0    conda-forge
r-listenv                 0.9.0             r43hc72bb7e_1    conda-forge
r-lobstr                  1.1.2             r43ha503ecb_3    conda-forge
r-lubridate               1.9.3             r43h57805ef_0    conda-forge
r-magrittr                2.0.3             r43h57805ef_2    conda-forge
r-markdown                1.11              r43hc72bb7e_0    conda-forge
r-mass                    7.3_60            r43h57805ef_1    conda-forge
r-matrix                  1.6_3             r43h316c678_0    conda-forge
r-matrixmodels            0.5_3             r43hc72bb7e_0    conda-forge
r-matrixstats             1.1.0             r43h57805ef_0    conda-forge
r-memoise                 2.0.1             r43hc72bb7e_2    conda-forge
r-mgcv                    1.9_0             r43h316c678_0    conda-forge
r-mime                    0.12              r43h57805ef_2    conda-forge
r-miniui                  0.1.1.1         r43hc72bb7e_1004    conda-forge
r-modelmetrics            1.2.2.2           r43ha503ecb_3    conda-forge
r-munsell                 0.5.0           r43hc72bb7e_1006    conda-forge
r-mvtnorm                 1.2_4             r43hd9ac46e_0    conda-forge
r-nlme                    3.1_164           r43h61816a4_0    conda-forge
r-nnet                    7.3_19            r43h57805ef_1    conda-forge
r-numderiv                2016.8_1.1        r43hc72bb7e_5    conda-forge
r-openssl                 2.1.1             r43hb353fa6_0    conda-forge
r-parallelly              1.36.0            r43hc72bb7e_1    conda-forge
r-pbdzmq                  0.3_10            r43ha81a24b_0    conda-forge
r-pillar                  1.9.0             r43hc72bb7e_1    conda-forge
r-pkgbuild                1.4.2             r43hc72bb7e_0    conda-forge
r-pkgconfig               2.0.3             r43hc72bb7e_3    conda-forge
r-pkgdown                 2.0.7             r43hc72bb7e_1    conda-forge
r-pkgload                 1.3.3             r43hc72bb7e_0    conda-forge
r-plyr                    1.8.9             r43ha503ecb_0    conda-forge
r-praise                  1.0.0           r43hc72bb7e_1007    conda-forge
r-prettyunits             1.2.0             r43hc72bb7e_0    conda-forge
r-proc                    1.18.5            r43ha503ecb_0    conda-forge
r-processx                3.8.2             r43h57805ef_0    conda-forge
r-prodlim                 2023.08.28        r43ha503ecb_0    conda-forge
r-profvis                 0.3.8             r43h57805ef_3    conda-forge
r-progressr               0.14.0            r43hc72bb7e_0    conda-forge
r-promises                1.2.1             r43ha503ecb_0    conda-forge
r-proxy                   0.4_27            r43h57805ef_2    conda-forge
r-ps                      1.7.5             r43h57805ef_1    conda-forge
r-purrr                   1.0.2             r43h57805ef_0    conda-forge
r-quantreg                5.97              r43hd9ac46e_0    conda-forge
r-r2rtf                   1.1.1             r43hc72bb7e_0    conda-forge
r-r6                      2.5.1             r43hc72bb7e_2    conda-forge
r-ragg                    1.2.6             r43h73ae6e3_0    conda-forge
r-rappdirs                0.3.3             r43h57805ef_2    conda-forge
r-rcmdcheck               1.4.0             r43h785f33e_2    conda-forge
r-rcolorbrewer            1.1_3             r43h785f33e_2    conda-forge
r-rcpp                    1.0.11            r43h7df8631_0    conda-forge
r-rcpparmadillo           0.12.6.4.0        r43h08d816e_0    conda-forge
r-rcppeigen               0.3.3.9.4         r43h08d816e_0    conda-forge
r-rcppparallel            5.1.6             r43ha503ecb_1    conda-forge
r-reactable               0.4.4             r43hc72bb7e_1    conda-forge
r-reactr                  0.5.0             r43hc72bb7e_0    conda-forge
r-recipes                 1.0.8             r43hc72bb7e_0    conda-forge
r-rematch2                2.1.2             r43hc72bb7e_3    conda-forge
r-remotes                 2.4.2.1           r43hc72bb7e_0    conda-forge
r-repr                    1.1.6             r43h785f33e_1    conda-forge
r-reshape2                1.4.4             r43ha503ecb_3    conda-forge
r-rex                     1.2.1             r43hc72bb7e_2    conda-forge
r-rlang                   1.1.2             r43ha503ecb_0    conda-forge
r-rmarkdown               2.25              r43hc72bb7e_0    conda-forge
r-roxygen2                7.2.3             r43ha503ecb_1    conda-forge
r-rpart                   4.1.21            r43h57805ef_0    conda-forge
r-rprojroot               2.0.4             r43hc72bb7e_0    conda-forge
r-rstudioapi              0.15.0            r43hc72bb7e_0    conda-forge
r-rversions               2.1.2             r43hc72bb7e_2    conda-forge
r-sandwich                3.0_2             r43hc72bb7e_2    conda-forge
r-sass                    0.4.7             r43ha503ecb_0    conda-forge
r-scales                  1.3.0             r43hc72bb7e_0    conda-forge
r-sessioninfo             1.2.2             r43hc72bb7e_2    conda-forge
r-shape                   1.4.6             r43ha770c72_2    conda-forge
r-shiny                   1.8.0             r43h785f33e_0    conda-forge
r-sourcetools             0.1.7_1           r43ha503ecb_1    conda-forge
r-sparsem                 1.81              r43h61816a4_2    conda-forge
r-squarem                 2021.1            r43hc72bb7e_2    conda-forge
r-stringi                 1.8.2             r43h9facbd6_0    conda-forge
r-stringr                 1.5.1             r43h785f33e_0    conda-forge
r-survival                3.5_7             r43h57805ef_0    conda-forge
r-sys                     3.4.2             r43h57805ef_1    conda-forge
r-systemfonts             1.0.5             r43haf97adc_0    conda-forge
r-testthat                3.2.0             r43ha503ecb_0    conda-forge
r-textshaping             0.3.7             r43hd87b9d6_0    conda-forge
r-tibble                  3.2.1             r43h57805ef_2    conda-forge
r-tidyr                   1.3.0             r43ha503ecb_1    conda-forge
r-tidyselect              1.2.0             r43hc72bb7e_1    conda-forge
r-timechange              0.2.0             r43ha503ecb_1    conda-forge
r-timedate                4022.108          r43hc72bb7e_1    conda-forge
r-tinytex                 0.49              r43hc72bb7e_0    conda-forge
r-tzdb                    0.4.0             r43ha503ecb_1    conda-forge
r-urlchecker              1.0.1             r43hc72bb7e_2    conda-forge
r-usethis                 2.2.2             r43hc72bb7e_0    conda-forge
r-utf8                    1.2.4             r43h57805ef_0    conda-forge
r-uuid                    1.1_1             r43h57805ef_0    conda-forge
r-v8                      4.4.0             r43h432ea70_0    conda-forge
r-vctrs                   0.6.4             r43ha503ecb_0    conda-forge
r-viridislite             0.4.2             r43hc72bb7e_1    conda-forge
r-waldo                   0.5.2             r43hc72bb7e_0    conda-forge
r-whisker                 0.4.1             r43hc72bb7e_1    conda-forge
r-withr                   2.5.2             r43hc72bb7e_0    conda-forge
r-xfun                    0.41              r43ha503ecb_0    conda-forge
r-xml2                    1.3.5             r43h1ad5fc0_0    conda-forge
r-xmlparsedata            1.0.5             r43hc72bb7e_2    conda-forge
r-xopen                   1.0.0           r43hc72bb7e_1005    conda-forge
r-xtable                  1.8_4             r43hc72bb7e_5    conda-forge
r-yaml                    2.3.7             r43h57805ef_1    conda-forge
r-zip                     2.3.0             r43h57805ef_1    conda-forge
r-zoo                     1.8_12            r43h57805ef_1    conda-forge
rdma-core                 28.9                 h59595ed_1    conda-forge
re2                       2023.06.02           h2873b5e_0    conda-forge
readline                  8.2                  h8228510_1    conda-forge
requests                  2.31.0             pyhd8ed1ab_0    conda-forge
ripgrep                   13.0.0               he8a937b_3    conda-forge
rpy2                      3.5.11          py39r43h44dd56e_3    conda-forge
rpy2-arrow                0.0.7              pyhd8ed1ab_0    conda-forge
ruamel.yaml               0.17.39          py39hd1e30aa_0    conda-forge
ruamel.yaml.clib          0.2.7            py39hd1e30aa_2    conda-forge
s2n                       1.3.56               h06160fa_0    conda-forge
scipy                     1.11.4           py39h474f0d3_0    conda-forge
sed                       4.8                  he412f7d_0    conda-forge
setuptools                68.2.2             pyhd8ed1ab_0    conda-forge
simplegeneric             0.8.1                      py_1    conda-forge
six                       1.16.0             pyh6c4a22f_0    conda-forge
snappy                    1.1.10               h9fff704_0    conda-forge
soupsieve                 2.5                pyhd8ed1ab_1    conda-forge
spec-classes              1.2.5              pyhd8ed1ab_0    conda-forge
stanio                    0.3.0              pyhd8ed1ab_0    conda-forge
statsmodels               0.14.0           py39h44dd56e_2    conda-forge
sympy                     1.12            pypyh9d50eac_103    conda-forge
sysroot_linux-64          2.12                he073ed8_16    conda-forge
tapi                      1000.10.8            hc9558a2_4    conda-forge
tbb                       2021.10.0            h00ab1b0_2    conda-forge
tbb-devel                 2021.10.0            h00ab1b0_2    conda-forge
tk                        8.6.13          noxft_h4845f30_101    conda-forge
tktable                   2.10                 h0c5db8f_5    conda-forge
tomli                     2.0.1              pyhd8ed1ab_0    conda-forge
tqdm                      4.66.1             pyhd8ed1ab_0    conda-forge
typing-extensions         4.8.0                hd8ed1ab_0    conda-forge
typing_extensions         4.8.0              pyha770c72_0    conda-forge
tzdata                    2023c                h71feb2d_0    conda-forge
tzlocal                   5.2              py39hf3d152e_0    conda-forge
ucx                       1.15.0               h64cca9d_0    conda-forge
urllib3                   1.26.18            pyhd8ed1ab_0    conda-forge
websocket-client          1.6.4              pyhd8ed1ab_0    conda-forge
wheel                     0.42.0             pyhd8ed1ab_0    conda-forge
wrapt                     1.16.0           py39hd1e30aa_0    conda-forge
xorg-kbproto              1.0.7             h7f98852_1002    conda-forge
xorg-libice               1.1.1                hd590300_0    conda-forge
xorg-libsm                1.2.4                h7391055_0    conda-forge
xorg-libx11               1.8.7                h8ee46fc_0    conda-forge
xorg-libxau               1.0.11               hd590300_0    conda-forge
xorg-libxdmcp             1.1.3                h7f98852_0    conda-forge
xorg-libxext              1.3.4                h0b41bf4_2    conda-forge
xorg-libxrender           0.9.11               hd590300_0    conda-forge
xorg-libxt                1.3.0                hd590300_1    conda-forge
xorg-renderproto          0.11.1            h7f98852_1002    conda-forge
xorg-xextproto            7.3.0             h0b41bf4_1003    conda-forge
xorg-xproto               7.0.31            h7f98852_1007    conda-forge
xz                        5.2.6                h166bdaf_0    conda-forge
yaml                      0.2.5                h7f98852_2    conda-forge
zeromq                    4.3.5                h59595ed_0    conda-forge
zipp                      3.17.0             pyhd8ed1ab_0    conda-forge
zlib                      1.2.13               hd590300_5    conda-forge
zstd                      1.5.5                hfc55251_0    conda-forge

Environment info

active environment : xp-env
    active env location : <<REDACTED>>
            shell level : 2
       user config file : <<HOME>>/.condarc
 populated config files : <<REDACTED>>/.condarc
                          <<REDACTED>>/condarc
          conda version : 23.3.1
    conda-build version : 3.25.0
         python version : 3.10.12.final.0
       virtual packages : __archspec=1=x86_64
                          __glibc=2.38=0
                          __linux=6.6.3=0
                          __unix=0=0
       base environment : <<REDACTED>>  (writable)
      conda av data dir : <<REDACTED>>/etc/conda
  conda av metadata url : None
           channel URLs : https://conda.anaconda.org/conda-forge/linux-64
                          https://conda.anaconda.org/conda-forge/noarch
          package cache : <<REDACTED>>/pkgs
                          <<HOME>>/.conda/pkgs
       envs directories : <<REDACTED>>/envs
                          <<HOME>>/.conda/envs
               platform : linux-64
             user-agent : conda/23.3.1 requests/2.31.0 CPython/3.10.12 Linux/6.6.3-arch1-1 arch/ glibc/2.38
                UID:GID : 1000:1000
             netrc file : None
           offline mode : False

issue related psycopg2

I am a beginner and I am facing issue in psycopg2 installation in my pycharm (venv) on my windows. How to solve it...

error

(venv) C:\Users\Vishal\PycharmProjects\website>pip install psycopg2
Collecting psycopg2
Using cached https://files.pythonhosted.org/packages/84/d7/6a93c99b5ba4d4d22daa3928b983cec66df4536ca50b22ce5dcac65e4e71/psycopg2-2.8.4.tar.gz
Complete output from command python setup.py egg_info:
running egg_info
creating pip-egg-info\psycopg2.egg-info
writing pip-egg-info\psycopg2.egg-info\PKG-INFO
writing dependency_links to pip-egg-info\psycopg2.egg-info\dependency_links.txt
writing top-level names to pip-egg-info\psycopg2.egg-info\top_level.txt
writing manifest file 'pip-egg-info\psycopg2.egg-info\SOURCES.txt'

Error: pg_config executable not found.

pg_config is required to build psycopg2 from source. Please add the directory
containing pg_config to the $PATH or specify the full executable path with the
option:

python setup.py build_ext --pg-config /path/to/pg_config build ...

or with the pg_config option in 'setup.cfg'.

If you prefer to avoid building psycopg2 from source, please install the PyPI
'psycopg2-binary' package instead.

For further information please check the 'doc/src/install.rst' file (also at
http://initd.org/psycopg/docs/install.html).

---

Command "python setup.py egg_info" failed with error code 1 in C:\Users\Vishal\AppData\Local\Temp\pip-install-yhws7zqc\psycopg2\

@conda-forge-admin, please update circle

@conda-forge-admin, please update circle