Windows error 0x0000274C, 10060

heroku pg:psql not working

I tried to connect to the Postgres database for my app on heroku by running the command "heroku pg:psql" and got the following error message: psql: could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "URL.com"(IP address) and accepting TCP/IP connections on port 5432? [...] read more

PostgreSQL Server doesn't listen: Tried everything and failed

When attempting to connect to PostgreSQL from a remote Windows server using pgAdmin 1.16.1 I get the dreaded 'Server doesn't listen' message with 'could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "xxx.xx.xxx.xx" and accepting TCP/IP connections on port 5432'. I'm running PostgreSQL 9.3 [...] read more

Postgresql Connection Timed out

when I am connecting to psql on remote server >psql -h {hostname} psql: could not connect to server: Connection timed out (0x0000274C/10060). Is the server running on host "{hostname}" (194.58.98.133) and accepting TCP/IP connections on port 5432? On server: netstat -nlp | grep 5432 tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN [...] read more

Connecting Python to a Database through SSH and SQLAlchemy

My current connection configuration is as follow, this is for redshift db con=('postgresql://username:password@hostname:port/databasename') server = SSHTunnelForwarder( ('ssh host', 22), ssh_username="-", ssh_password="-", remote_bind_address=('db host', port) ) server.start() local_port = str(server.local_bind_port) engine = sa.create_engine(con) ######## Reaches here then times out when reading the table df_read = pd.read_sql_table('tablename',engine) However, the redshift database also [...] read more

psql: could not connect to server... Is the server running on host ... and accepting TCP/IP connections on port 5432?

I know this is a popular question. I have tried everything suggested in similar threads. I am trying to connect remotely to a postgresql database on an azure windows server 2012 machine. I have tried the following... postgresql.conf listen_addresses = '*' pg_hba.conf # IPv4 local connections: host all all 0.0.0.0/0 [...] read more

PHP - Connection failed to PostgreSQL database in virtual machine

I am trying to connect to a PostgreSQL database in a virtual machine, through a php script, but being unsuccessful. I execute the php from the host (Windows 8.1) and the postgresql is at the virtual machine (Debian 8.6). I use VirtualBox. The error output from the browser is: Warning: [...] read more

PostgreSQL can't connect from python/psycopg

I'm having problem connecting to PostgreSQL through Python/Psycopg2. The PostgreSQL server is running on 192.168.1.6, CentOS 5.5. I can already connect through LAN workstations using Navicat, I'm pretty sure I had the right post opened in iptables. But when connecting from Python/psycopg2, I got this error conn = psycopg2.connect(database='test', user='sql', [...] read more

Cannot connect to PostgreSQL DB Via pgAdmin

So, I installed a minimal install of Fedora 15 to create a server for a web application. I also installed PostgreSQL 9.1 from pgrpms.org. PostgreSQL install went well. Locally, I was able to initdb, start and psql in to change the postgres password. Now, I have installed pgAdmin on a [...] read more

unable to connect to AWS RDS postgres instance from pgadmin4

I have created an AWS RDS postgres instance and i am trying to hit the db using postgres4 dashboard from my local machine but am unable to create a connection and it is throwing an error like Unable to connect to server: could not connect to server: Connection timed out [...] read more

why can't I access my postgres from remote?

I have a Postgres 10.3 Server installed on an Ubuntu Server. I did the necessary settings, which always had been enough to be able to access it from PGAdmin from my Laptop, but this time it doesn't work. I tried the following steps: listen_addresses = '*' host all all 0.0.0.0/0 [...] read more

Python3: Connect to Remote Postgres Database with SSL

I am in the process of setting up a remote PostgreSQL database. The server is running CentOS 7 and PostgreSQL-9.5. Currently, I am testing whether users can query the database. To this end, I have the following: import psycopg2 host = 'server1' dbname = 'test_db' user = 'test-user' sslcert = [...] read more

Remotely connecting PostgreSQL on Windows Server - psql: could not connect to server: Connection timed out

I am setting up PostgreSQL on the company's test VM. One is database VM running Windows Server 2016 contains other databases like SQL Server. I set up Postgres 10.15 and set listen_addresses = '*' in postgresql.conf and added these lines in pg_hba.conf host all all 0.0.0.0/0 trust host all all [...] read more

postgres connection refused in ubuntu

getting an error while connecting remotely and the error says something like could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host x and accepting TCP/IP connections on port 5432? please help me out read more

Unable to connect to Amazon RDS Postgres Database from my Django Web Application

I am trying to deploy a website using elastic beanstalk and connect it up to a Postgres Database. When trying to makemigrations in django I am getting an error. I have been able to successfully set up a local Postgres database. I have been trying for a while with no [...] read more

Cannot connect remotely to postgresql database hosted on amazon ec2 instance

I have a postgresql database hosted on my ec2 instance. I am trying to connect to it using Python from my local computer. import psycopg2 try: connection = psycopg2.connect(user="postgres", password="<password>", host="ec2-***-***-***-***.***-***-1.compute.amazonaws.com", port="5432", database="<db_name>") cursor = connection.cursor() cursor.execute(f"SELECT * FROM <tablename>;") record = cursor.fetchall() print(record, "\n") except (Exception, psycopg2.Error) as error: [...] read more

Can't connect remotely to PostGIS docker

I've created a PostGIS docker container with the following code: docker run --name=h4d -d -e POSTGRES_USER=h4d_user -e POSTGRES_PASS=password -e POSTGRES_DBNAME=gis -e ALLOW_IP_RANGE=0.0.0.0/0 -p 5432:5432 -v h4d_data:/var/lib/postgresql --restart=always kartoza/postgis:latest I can connect to the docker from my localhost, but I can't from another terminal. The error message says "could not connect [...] read more

Can not connect to Postgresql running at different port using Python

I have Postgres up and running on one of my machines. Its pg_hba.conf contains this string: host all all 0.0.0.0/0 md5 And postgresql.conf contains these lines: listen_addresses = '*' port = 5433 The machine on my local network has this IP address 192.168.234.137. I try to connect to Postgres from [...] read more

SOLVED: Laravel: connection to AWS RDS results in a timed out

I was trying to migrate the database to AWS RDS through Laravel using php artisan migrate, however, it gave me this error: Illuminate\Database\QueryException : SQLSTATE[08006] [7] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "xxxxxxxxx.xxxxxxxxx.us-east-2.rds.amazonaws.com" (xx.xxx.xxx.xxx) and accepting TCP/IP connections on port 5432? [...] read more

How to connect to a remote database in a digital ocean server

I have a rails application in a windows local machine and i have a postgresql remote database in digital ocean server [ubuntu server]. How to connect it, I tried like this: database.yml default: &default adapter: postgresql encoding: unicode host: xxx.xxx.xxx.xx username: username password: password schema_search_path: "public,shared_extensions" # For details on [...] read more

Connect to dockerized postgres from Windows Docker host

my setup is Docker for Windows (Version 18.09.2) on a Windows 10 Pro machine with installed postgres (not a database, only the command line tools). I run the official postgres image from docker hub with docker run -it -v D:/postgres:/home/dump --name some_postgres -e POSTGRES_PASSWORD=root -d postgres Afterwards I am able [...] read more

heroku postgresql could not connect to server: Connection timed out

I'm trying to connect to postgres database in heroku using heroku pg:psql postgresql-rigid-33416 --app murmuring-ocean-62645, however I got this message --> Connecting to postgresql-rigid-33416 psql: could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "ec2-50-17-225-140.compute-1.amazonaws.com" (50.17.225.140) and accepting TCP/IP connections on port 5432? I [...] read more

Can't connect to RDS Postgres locally after setting up NAT instance

I am working on a Django project that uses Zappa to host a serverless app on Lambda. It uses a Postgres database on the back and I've been able to use it flawlessly for some time. Recently I needed to use urllib, and so I needed a NAT instance (EC2 [...] read more

Cannot connect to PostgreSQL in Docker through PHP

I'm cant connect to PostgreSQL with php code. My Postgresql is docker container. I get an IP with: docker inspect toshi_db_1 How I'm trying to connect: $dbconn = pg_connect("host=172.17.0.2 port=5432 dbname=toshi_development")or die("Could not connect"); > Error: Warning: pg_connect(): Unable to connect to PostgreSQL server: could > not connect to server: [...] read more

postgres: client could not connect to server

For clarification, please note that I have found several similar questions on stackoverflow, but I could not fix my issue. psql: could not connect to server: Connection refused” Error when connecting to remote database psql: How to Allow Remote Access to PostgreSQL database I am trying to connect to a [...] read more

Unable to connect to server pgAdmin

I installed PostgreSQL on my Ubuntu virtual machine (ip: 192.168.195.95). Now, I'm trying to access the database from my physical machine Windows with pgAdmin (ip: 192.168.195.1). I know I have to make changes in postgresql.conf and pg_hba.conf to allow the client to connect, so I had added this: listen_addresses = [...] read more

Connect Heroku postgres from localclient

I'm trying to connet with psql -h ec2-23-23-227-54.compute-1.amazonaws.com -U igcmskkpsx igcmskkpsx but it answer: psql: no se pudo conectar con el servidor: Connection timed out (0x0000274C/10060) ¿Está el servidor en ejecución en el servidor «ec2-23-23-227-54.compute-1.amazonaws.com» y aceptando conexiones TCP/IP en el puerto 5432? Please any suggestion? read more

Using pgAdmin 4 to access a remote PostgreSQL server

Sorry for the long post.. I wanted to be as detailed as possible to make it easier to spot a problem.. So I've followed the instructions on the PostgreSQL download page and started running a PostgreSQL server running on port 5432 of my CentOS 7 VM. ## Install the repository [...] read more

Unable to connect to server PostgreSQL database with pgAdmin

I have a brand new Debian 10 and PostgreSQL installation on a remote server and I want to connect with pgAdmin to this database from my PC. When I create a server on pgAdmin I have (I hide my host) : > Unable to connect to server: > could not [...] read more

psycopg2.OperationalError: could not connect to server: Is the server running on host host_name" and accepting TCP/IP connections on port 5439?

I am getting following error while running a small program on pycharm. Here I am trying to fetch data from Redshift cluster.Actully I want to access Redshift from my localhost (window 7) . import psycopg2 con=psycopg2.connect("Connect_detail....") cur = con.cursor() cur.execute("SELECT * FROM 'test1';") cur.fetchall() cur.close() conn.close() Error psycopg2.OperationalError: could not [...] read more

How to generate python db model with SQLAlchemy for Aurora Serverless and DataAPI?

I've been trying to figure out if there's any way to have ORM functionalities (especially code model generation) for an Aurora Serverless (Postgresql) DB that's used through DataAPI ? Ultimately, I want to avoid using raw sql string queries in our Lambdas. I tried using sqlacodegen combined with sqlalchemy-aurora-data-api (which [...] read more

Connecting Amazon Redshift to PowerBI - Error Message

I am getting this message when connecting PowerBI to my Amazon Redshift account. Details: "ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "redshift-test-leo.ctwhewjldisv.us-east-2.redshift.amazonaws.com" (3.129.150.228) and accepting TCP/IP connections on [...] read more

Can't access the Db instance on RDS using pgAdmin

I created a DB instance on RDS with easy create following Create DB instance section, then I tried to connect to it using pgAdmin according to what is mentioned in Connecting to a DB Instance Running the PostgreSQL Database Engine section. When I create the sever on PgAdmin I got [...] read more

AWS - connect to PostgreSQL from Python not working

Sorry to bother you, but I have been struggling to use Python to connect to the AWS PostgreSQL database based on this instruction https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.Connecting.Python.html, as it always displays timeout error. I have also set up a config file in ~/.aws folder to configure the boto3, with the following: [default] aws_access_key_id [...] read more

Heroku postgresql connection error from cli

Do I need to create some connection with Amazon web server? Or due to running of the app from the local machine this error is occur? If so how to change environment PS C:\Users\Desktop\faceReg-API> heroku pg:psql --> Connecting to postgresql-horizontal-29850 psql: error: could not connect to server: could not connect [...] read more

Could not connect to Azure cloud hyperscale citus

i tried connecting my local postgresql to azure via hyperscale citus but got this error. > psql: error: could not connect to server: could not connect to server: > Connection timed out (0x0000274C/10060) Is the server running on host > "mydemo-c.postgres.database.azure.com" (20.42.29.217) and accepting TCP/IP > connections on port 5432? [...] read more

trying to connect to heroku database and even configured pg_hba.conf file with all credentials but getting this error

psql -h [hostname] -U [user] [database] psql: FATAL: no pg_hba.conf entry for host "..*.", user "[user]", database "[database]", SSL off psql -h ... -U [user] [database] psql: could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "..." and accepting TCP/IP connections on port 5432? read more

can we set more than one port in postgresql.config file?

Im trying to remote connect MsSQL from PostgreSQL using Pg-admin, but every time i try to connect using dblink_connect function, im not able to connect and the Pg-admin throw the error : ERROR: could not establish connection DETAIL: could not connect to server: Connection timed out (0x0000274C/10060) Is the server [...] read more

Cant access database from pgAdmin

I`m using postgresql database on my web server (ubuntu + nginx) and it works with backend app. I want to connect remotely using pgAdmin but it always throw this error: could not connect to server: Connection timed out(0x0000274C/10060) Is the server running on host "ip" and accepting TCP/IP connections on [...] read more

Connecting to a Redshift instance using R without using oVPN

I am relatively new to using both R and Redshift together. However, I was recently trying to find a way in which I can establish a connection to a particular Redshift instance using R. Consequently, I have been successful in using the redshiftTools package to achieve the above by using [...] read more

Remote access to postgresql server windows 10

As the title suggest I'm trying to configure a postgresql server to be accessible remotely. I've followed many guides and viewed some of the other answers here however I'm still having trouble. The details: os, windows 10 postgresql version on host is 11.6 postgresql version on remote is 11.2 with [...] read more

Unable to connect to postgresql remotely through pgadmin on port 8085 on Google Cloud

I've postgres server listening on all ip addresses at port 8085. Even after following the Google cloud instructions here to open the port 8085 (instead of default 5432 port) through firewall rules, I'm still getting the following error. I've set up both egress and ingress firewall rules with the same [...] read more

Can't connect to Postgres remotely due to "no pg_hba.conf entry for host"

EDIT: Original question was about connecting. Thanks to the comments, I was notified I had to add firewall rule. I did: sudo ufw allow 5432/tcp Now I get a different error FATAL: no pg_hba.conf entry for host "[my_ip]" Now sure why if I allowed all in that file? -------------------------------------------------------------------------------- ORIGINAL: [...] read more

Redshift Not Connecting to Host via Python Script

I currently have a .csv file in an S3 bucket that I'd like to append to a table in a Redshift database using a Python script. I have a separate file parser and upload to S3 that work just fine. The code I have for connecting to/copying into the table [...] read more

R: postgres connection keeps timing out or breaking

I am running a code in R, which connects to the postgresql database. The connection is defined outside the loop, but it times out and keeps breaking. If I put the connection inside the loop, and kill it each time I use it. We reach the limit on the connections. [...] read more

'Connection timed out' when connecting on heroku database using 'pg:psql' command

I am trying to connect to my database on heroku, which I would use on my app. I'm using either Command Line or Git Bash on windows. I have created database on heroku named postgresql-rectangular-87454 and installed Postgres without any errors. Typing heroku addons I'm making sure, database is set [...] read more

OperationalError Could Not Connect To Server -- Django/Heroku/AWS/Postgres

Im having an odd problem when trying to run my website on my local machine. If I type in python manage.py runserver, I get the following error and my site won't load. I tried to restart my Postgres database on my local machine and restarted the computer but having the [...] read more

Connect tableau to bitnami django stack postgres database

I am trying to connect the tableau to bitnami django stack which is being hosted on GCP instance with postgres database(included in bitnami django stack). Am trying to connect the tableau to my postgres for better analytics. I have already tried connecting to the local development system and that works [...] read more

Problems connecting to Postgresql server?

I am running a Postgresql server hosted on heroku as part of an app I am developing. I've been using PGAdmin as a frontend to set up my tables and also check to make sure the app is correctly writing data to the tables. When I am at home it [...] read more

Enable PostgreSQL remote access- nothing seems to work

I have tried everything I can find to enable to remote access to a postgresql 8.1 database on a centos server. I am trying to connect from my windows 10 PC using pgAdmin 3. I keep getting: > The server doesn't accept connections: the connection library reports could > not [...] read more

Odoo-postgreSQL access through Python

We are trying to access the database of Odoo running on 104.154.90.232 through Python. I have used psycopg2 to connect. My code is like this: import psycopg2 import sys import pprint conn_string = "host='104.154.90.232' dbname='dbname' user='user' password='password'" print "connecting to the database\n ->%s"%(conn_string) conn = psycopg2.connect(conn_string) cursor = conn.cursor() cursor.execute("SELECT [...] read more

Postgres PgAdmin 3: Server doesn't listen - Tried everything

I tried opening ports in IPTables, Set Listen address to * Added host all all 23.81.27.0/24 trust and even host all all 0.0.0.0/0 trust YouGetSignal shows the port is closed, and i can't connect to my DB via PgAdmin. I get > could not connect to server: Connection timed out [...] read more

Postgresql wont accept remote connections

I tried opening ports in IP Tables,, Set Listen address to '*' Added host all all 23.81.27.0/24 trust and host all all 0.0.0.0/0 trust YouGetSignal shows the port is closed, and i can't connect to my DB via PgAdmin. I get > could not connect to server: Connection timed out [...] read more

SSHTunnel for remote access of postgres server

I'm new to using postgres as well as ssh and am having some trouble understanding what I need to do to get remote clients accessing a postgres server. Right now I've got one computer with a server running that I can access using psycopg2 but now I want to query [...] read more

Query Redshift Database from localhost web app?

I'm trying to connect my html/css/js web app on my localhost to a separate redshift database. I don't have access to the key/secret, so the SDK for PHP won't work for me. Are there alternative options? I feel like I'm on the wrong track. I'm trying to query the redshift [...] read more

can't connect to vertica from a remote computer

I setup a one node instance using vertica community edition. I ran install like this: /opt/vertica/sbin/install_vertica --hosts 127.0.0.1 --rpm /home/ec2-user/vertica-7.1.2-0.x86_64.RHEL5.rpm --dba-user dbadmin --data-dir /home/ec2-user/vertica1 install ran correctly...I created a db...loaded data...but did it all from the box. My problem is that I can't connect to it from a remote computer. [...] read more

Python: unable connect with database

Python 3.4 with psycopg2 I used this guide to set up a basic psycopg2 connection like so: #!/usr/bin/python import psycopg2 import sys import pprint def main(): conn_string = "dbname='CIBTST' host='XX.XX.XXX.XX' port='XXXX' user='XXXXX' password='XXXX'" conn = psycopg2.connect(conn_string) cursor = conn.cursor() cursor.execute("My_select") records = cursor.fetchall() pprint.pprint(records) if __name__ == "__main__": main() I [...] read more