installation guide for usage with AWS RDS PostgreSQL

[riazXrazor]

Hi, i wana install pgsync on my server to connect to AWS RDS PostgreSQL instead of the local PostgreSQL , any guide would be helpful.

currently getting the below error:

 running egg_info
    creating pip-egg-info/psycopg2_binary.egg-info
    writing pip-egg-info/psycopg2_binary.egg-info/PKG-INFO
    writing dependency_links to pip-egg-info/psycopg2_binary.egg-info/dependency_links.txt
    writing top-level names to pip-egg-info/psycopg2_binary.egg-info/top_level.txt
    writing manifest file 'pip-egg-info/psycopg2_binary.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
    <https://www.psycopg.org/docs/install.html>).


    ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-310njhsw/psycopg2-binary/

[toluaina]

How are you trying to install this? are you installing through pip

[nazihkalo]

I'd also appreciate a guide on setup with AWS RDS & running on EC2 instance within same VPC as the aurora postgres db 🙏

[noahrotheray]

For those still having this issue.

Installing libpq-dev (Debian) fixed this issue for me.