Can’t connect the postgreSQL with psycopg2

by

Your libpq, which is used by psycopg2 expects Postgres socket to be in /var/run/postgresql/ but when you install Postgres from source it is by default it in /tmp/.

Check if there is a file /tmp/.s.PGSQL.5432 instead of /var/run/postgresql/.s.PGSQL.5432. Try:

conn=psycopg2.connect(
  database="mydb",
  user="postgres",
  host="/tmp/",
  password="123"
)

More Related Contents:

  1. SQLAlchemy, Psycopg2 and Postgresql COPY
  2. Setting application_name on Postgres/SQLAlchemy
  3. How to reset postgres’ primary key sequence when it falls out of sync?
  4. PostgreSQL LIKE query performance variations
  5. How to import CSV file data into a PostgreSQL table
  6. The forgotten assignment operator “=” and the commonplace “:=”
  7. Equivalent to unpivot() in PostgreSQL
  8. Passing user id to PostgreSQL triggers
  9. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  10. I forgot the password I entered during postgres installation
  11. Do nullable columns occupy additional space in PostgreSQL?
  12. Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
  13. How to configure PostgreSQL to accept all incoming connections
  14. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  15. Disable PostgreSQL foreign key checks for migrations
  16. Prevent recursive trigger in PostgreSQL
  17. Returning from a function with OUT parameter
  18. How do you create a random string that’s suitable for a session ID in PostgreSQL?
  19. Joining Results from Two Separate Databases
  20. PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement
  21. Update timestamp when row is updated in PostgreSQL
  22. Postgresql query array of objects in JSONB field
  23. How to add a conditional unique index on PostgreSQL
  24. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  25. input file appears to be a text format dump. Please use psql
  26. Hashing a String to a Numeric Value in PostgreSQL
  27. Spring Docker container cannot access Postgres Docker container
  28. Format specifier for integer variables in format() for EXECUTE?
  29. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  30. PostgreSQL composite primary key

Leave a Comment