This is probably not the correct interpretation of this error.
The Win32 error above is more likely to indicate the actual problem.
Flags
Severity
Success
This code indicates success, rather than an error.
This may not be the correct interpretation of this code,
or possibly the program is handling errors incorrectly.
I'm recently setting up and running a Windows 2008 r2 server with VMware Workstation 8. I'm running a Centos 6.2 virtual linux box with Postgresql 9.1. Everything seems ok locally and I can connect to the CentOS box via a bridged network connection. I have followed David Ghedini's walkthrough for [...] read more
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
I'm using Docker on Windows to use in local a postgres database. I made two docker container: one for the database called pg and another called pgadmin with pgadmin4. After inspected pg, I connected pgadmin4 in 172.17.0.3:5432 and it works. Now time to code but... psycopg2.OperationalError: could not connect to [...] read more
I have a 4GB local postgres database that I want to migrate to an AWS RDS database instance. Here is what I have done: 1. On the aws rds console, I created a database instance called "testdatabase" 2. I added my IP address to a security group to allow for [...] read more
http://imgur.com/a/kzeVm I have followed the guide, disabled my firewall, verified my security group allows access to everything (initially set to public). Still, 2 installs of mysql won't let ssms connect. No idea why this doesn't work ACL 100 ALL Traffic ALL ALL 0.0.0.0/0 ALLOW * ALL Traffic ALL ALL 0.0.0.0/0 [...] read more