Hi, i try to add postgres as load with this comman...
# troubleshooting
m
Hi, i try to add postgres as load with this command and got this error: ➜ test meltano add loader target-postgres --variant meltano 2022-01-26T203159.842894Z [info ] ascii passed initial chaos probing. Mean measured chaos is 0.720000 % 2022-01-26T203159.843241Z [info ] ascii is most likely the one. Stopping the process. Added loader ‘target-postgres’ to your Meltano project Variant: meltano Repository: https://github.com/meltano/target-postgres Documentation: https://hub.meltano.com/loaders/postgres--meltano.html Installing loader ‘target-postgres’... Loader ‘target-postgres’ could not be installed: failed to install plugin ‘target-postgres’. Running command git clone --filter=blob:none -q https://github.com/meltano/target-postgres.git /private/var/folders/80/f2zdrts94ys84slpzfpv5vdw0000gn/T/pip-req-build-d08_z2no WARNING: Built wheel for target-postgres is invalid: Metadata 1.2 mandates PEP 440 version, but ‘meltano.1.1.11’ is not ERROR: Command errored out with exit status 1:
e
Hi @michael! You're probably missing a system dependency. If you're on mac, can you try
Copy code
$ brew install openssl
export LDFLAGS="-L/usr/local/opt/openssl/lib"
export CPPFLAGS="-I/usr/local/opt/openssl/include"

$ meltano add loader target-postgres --variant meltano
m
Hi @edgar_ramirez_mondragon, thanks for your quick reply. Yes i am on a mac and i tried what you mentioned, but it is still the same: ➜ test meltano add loader target-postgres --variant meltano 2022-01-27T072811.914768Z [info ] ascii passed initial chaos probing. Mean measured chaos is 0.720000 % 2022-01-27T072811.915113Z [info ] ascii is most likely the one. Stopping the process. Loader ‘target-postgres’ already exists in your Meltano project To add it to your project another time so that each can be configured differently, add a new plugin inheriting from the existing one with its own unique name: meltano add loader target-postgres--new --inherit-from target-postgres Installing loader ‘target-postgres’... Loader ‘target-postgres’ could not be installed: failed to install plugin ‘target-postgres’. Running command git clone --filter=blob:none -q https://github.com/meltano/target-postgres.git /private/var/folders/80/f2zdrts94ys84slpzfpv5vdw0000gn/T/pip-req-build-nrwqv0e2 WARNING: Built wheel for target-postgres is invalid: Metadata 1.2 mandates PEP 440 version, but ‘meltano.1.1.11’ is not ERROR: Command errored out with exit status 1: command: /Users/michael/meltano/meltano-projects/test/.meltano/loaders/target-postgres/venv/bin/python -u -c ‘import io, os, sys, setuptools, tokenize; sys.argv[0] = ‘“’”‘/private/var/folders/80/f2zdrts94ys84slpzfpv5vdw0000gn/T/pip-install-if654vjb/psycopg2_d865e3fffae94d6d9bc5c372865d59aa/setup.py’“‘”’; file=‘“’”‘/private/var/folders/80/f2zdrts94ys84slpzfpv5vdw0000gn/T/pip-install-if654vjb/psycopg2_d865e3fffae94d6d9bc5c372865d59aa/setup.py’“‘”’;f = getattr(tokenize, ‘“’”‘open’“‘”’, open)(file) if os.path.exists(file) else io.StringIO(‘“’”‘from setuptools import setup; setup()‘“’”‘);code = f.read().replace(‘“’”‘\r\n’“‘”’, ‘“’”‘\n’“‘”’);f.close();exec(compile(code, file, ‘“’”‘exec’“‘”’))' bdist_wheel -d /private/var/folders/80/f2zdrts94ys84slpzfpv5vdw0000gn/T/pip-wheel-22egw98c cwd: /private/var/folders/80/f2zdrts94ys84slpzfpv5vdw0000gn/T/pip-install-if654vjb/psycopg2_d865e3fffae94d6d9bc5c372865d59aa/