Styjun

Disordered Cryptic Orders

Painting the backpack

Why do Computer Science degrees contain a high proportion of mathematics?

Will Schnorr Multi-signatures completely replace ECDSA?

Function of 令 in this sentence (cantonese)

How to see time in ~/.bash_history file

In the comics, have any of the Robins called their costume "target attraction" for villains?

Wrap the real right around the trigonometric circle (Metapost)

How to plot two axis bar chart side by side

How to print and use a command output in a one-liner?

How to treat unhandled exceptions? (Terminate the application vs. Keep it alive)

Novel with a mix of real world and gods

Why do adjectives come before nouns in English?

Can digital computers understand infinity?

How to protect my Wi-Fi password from being displayed by Android phones when sharing it with QR code?

A fast aquatic predator with multiple eyes and pupils. Would these eyes be possible?

Do businesses save their customers' credit card information until the payment is finalized?

When did 5 foot squares become standard in D&D?

Should I avoid "big words" when writing to a younger audience?

What does the British parliament hope to achieve by requesting a third Brexit extension?

What does すきすき mean here?

Why does b+=(4,) work and b = b + (4,) doesn't work when b is a list?

The travel to a friend

"A tin of biscuits" vs "A biscuit tin"

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused

PostgreSQL database serviceDBI::OperationalError: could not connect to server: Connection refusedConnect qt in mac with postgres in windowsunable to connect to server for PostgresPostgresql connection refused error on Windows 10Django heroku connection refusedDocker - Postgres and pgAdmin 4 : Connection refusedpgAdmin4 - postgresql application server could not be contactedBd Postgres connection to Laravel?PostgreSQL 11: could not connect to server: TCP/IP connections on port 5432

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;

0

1

After starting up postgres on docker any attempt to connect to the database results in the following;

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused (0x0000274D/10061)
 Is the server running on host "localhost" (::1) and accepting
 TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
 Is the server running on host "localhost" (127.0.0.1) and accepting
 TCP/IP connections on port 5432?

Background on this error at: http://sqlalche.me/e/e3q8

I have looked at similar issues and my ports are assigned as such;

ports:
 - 5432:5432

Details

• Flask server using venv


• Windows 10

Additional Details

Dockerfile (for postgres)

FROM postgres:9.6-alpine

COPY init-db /docker-entrypoint-initdb.d/

application file (FLASK_APP) THIS IS THE COMMAND THAT BREAKS IT

@application.cli.command(with_appcontext=True)
def create_db():
 db.engine.execute("CREATE EXTENSION IF NOT EXISTS fuzzystrmatch;")

 db.drop_all()
 db.create_all()

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f04ca2725c96 taxai_ml "gunicorn --worker-c…" 3 hours ago Up 3 hours 0.0.0.0:8900->5000/tcp taxai_ml_1
032fd31432af stripemock/stripe-mock "/stripe-mock -http-…" 3 hours ago Up 3 hours 0.0.0.0:12111-12112->12111-12112/tcp taxai_stripe_1
795b2ff4d7d5 redis:3.2.11-alpine "docker-entrypoint.s…" 3 hours ago Up 3 hours 0.0.0.0:6379->6379/tcp taxai_redis_1

postgresql docker

share|improve this question

edited Mar 28 at 23:50

Robert

asked Mar 28 at 21:22

RobertRobert

733 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  could you provide additional information? like Dockerfile for your postgres and your flask? the output of docker ps or any other docker commands that might be relevant
  
  – Ikaro0
  Mar 28 at 21:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The output of the docker-compose up -d is succesful. It is only when I run the create_db() command that the error message pops up.
  
  – Robert
  Mar 28 at 23:46
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What I was saying is that more information looks like to be required in order to fully understand the problem. Knowing how your service is defined will help, is this a compose of app and db? is your app connecting to an existing db elsewhere? before calling the cli command how is your connection against database being defined? have you tested your python code outside docker?, etc
  
  – Ikaro0
  Mar 29 at 9:02
  

  
  
  
  

add a comment
 | 

0

1

After starting up postgres on docker any attempt to connect to the database results in the following;

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused (0x0000274D/10061)
 Is the server running on host "localhost" (::1) and accepting
 TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
 Is the server running on host "localhost" (127.0.0.1) and accepting
 TCP/IP connections on port 5432?

Background on this error at: http://sqlalche.me/e/e3q8

I have looked at similar issues and my ports are assigned as such;

ports:
 - 5432:5432

Details

• Flask server using venv


• Windows 10

Additional Details

Dockerfile (for postgres)

FROM postgres:9.6-alpine

COPY init-db /docker-entrypoint-initdb.d/

application file (FLASK_APP) THIS IS THE COMMAND THAT BREAKS IT

@application.cli.command(with_appcontext=True)
def create_db():
 db.engine.execute("CREATE EXTENSION IF NOT EXISTS fuzzystrmatch;")

 db.drop_all()
 db.create_all()

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f04ca2725c96 taxai_ml "gunicorn --worker-c…" 3 hours ago Up 3 hours 0.0.0.0:8900->5000/tcp taxai_ml_1
032fd31432af stripemock/stripe-mock "/stripe-mock -http-…" 3 hours ago Up 3 hours 0.0.0.0:12111-12112->12111-12112/tcp taxai_stripe_1
795b2ff4d7d5 redis:3.2.11-alpine "docker-entrypoint.s…" 3 hours ago Up 3 hours 0.0.0.0:6379->6379/tcp taxai_redis_1

postgresql docker

share|improve this question

edited Mar 28 at 23:50

Robert

asked Mar 28 at 21:22

RobertRobert

733 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  could you provide additional information? like Dockerfile for your postgres and your flask? the output of docker ps or any other docker commands that might be relevant
  
  – Ikaro0
  Mar 28 at 21:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The output of the docker-compose up -d is succesful. It is only when I run the create_db() command that the error message pops up.
  
  – Robert
  Mar 28 at 23:46
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What I was saying is that more information looks like to be required in order to fully understand the problem. Knowing how your service is defined will help, is this a compose of app and db? is your app connecting to an existing db elsewhere? before calling the cli command how is your connection against database being defined? have you tested your python code outside docker?, etc
  
  – Ikaro0
  Mar 29 at 9:02
  

  
  
  
  

add a comment
 | 

After starting up postgres on docker any attempt to connect to the database results in the following;

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused (0x0000274D/10061)
 Is the server running on host "localhost" (::1) and accepting
 TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
 Is the server running on host "localhost" (127.0.0.1) and accepting
 TCP/IP connections on port 5432?

Background on this error at: http://sqlalche.me/e/e3q8

I have looked at similar issues and my ports are assigned as such;

ports:
 - 5432:5432

Details

• Flask server using venv


• Windows 10

Additional Details

Dockerfile (for postgres)

FROM postgres:9.6-alpine

COPY init-db /docker-entrypoint-initdb.d/

application file (FLASK_APP) THIS IS THE COMMAND THAT BREAKS IT

@application.cli.command(with_appcontext=True)
def create_db():
 db.engine.execute("CREATE EXTENSION IF NOT EXISTS fuzzystrmatch;")

 db.drop_all()
 db.create_all()

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f04ca2725c96 taxai_ml "gunicorn --worker-c…" 3 hours ago Up 3 hours 0.0.0.0:8900->5000/tcp taxai_ml_1
032fd31432af stripemock/stripe-mock "/stripe-mock -http-…" 3 hours ago Up 3 hours 0.0.0.0:12111-12112->12111-12112/tcp taxai_stripe_1
795b2ff4d7d5 redis:3.2.11-alpine "docker-entrypoint.s…" 3 hours ago Up 3 hours 0.0.0.0:6379->6379/tcp taxai_redis_1

postgresql docker

share|improve this question

edited Mar 28 at 23:50

Robert

asked Mar 28 at 21:22

RobertRobert

733 bronze badges

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused (0x0000274D/10061)
 Is the server running on host "localhost" (::1) and accepting
 TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
 Is the server running on host "localhost" (127.0.0.1) and accepting
 TCP/IP connections on port 5432?

ports:
 - 5432:5432

FROM postgres:9.6-alpine

COPY init-db /docker-entrypoint-initdb.d/

@application.cli.command(with_appcontext=True)
def create_db():
 db.engine.execute("CREATE EXTENSION IF NOT EXISTS fuzzystrmatch;")

 db.drop_all()
 db.create_all()

share|improve this question

edited Mar 28 at 23:50

Robert

asked Mar 28 at 21:22

RobertRobert

733 bronze badges

share|improve this question

edited Mar 28 at 23:50

Robert

asked Mar 28 at 21:22

RobertRobert

733 bronze badges

asked Mar 28 at 21:22

RobertRobert

733 bronze badges

asked Mar 28 at 21:22

RobertRobert

733 bronze badges