Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

From: Ricardo Martin Gomez <rimartingomez(at)hotmail(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, Ron <ronljohnsonjr(at)gmail(dot)com>
Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Date: 2018-11-24 12:16:10
Message-ID: RO1P15201MB2267F8DCC9F82D673BA8818CA3D50@RO1P15201MB2267.LAMP152.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin pgsql-hackers

Hello,
You must be check postgres.conf file in order to see the particular port.
Sometimes postgres is running but in another port 5433, 5434, etc.

Obtener Outlook para Android<https://aka.ms/ghei36>

________________________________
From: Ron <ronljohnsonjr(at)gmail(dot)com>
Sent: Saturday, November 24, 2018 3:25:02 AM
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

On 11/23/2018 08:31 PM, Anne Marie Harm wrote:
Hello,

Unfortunately I'm unable to operate pgAdmin/PostgreSQL; first of all I can only install version 9.5 (tried versions 11, 10, and 9.6 -- but cannot install).

How come. (Are you running a really old distro version?)

When I launch pgAdmin in order to try to use PostgreSGL 9.5, here is the full text of the error message I receive (also, screenshot attached):

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?

Well, is Postgres running? You installed Pg but did you start it? These two commands will tell you:

pg_ctl status # when logged in as user postgres
sudo netstat -an | grep 5432

--
Angular momentum makes the world go 'round.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Malik Rumi 2018-11-24 13:26:58 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Previous Message Ron 2018-11-24 06:25:02 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

Browse pgsql-admin by date

  From Date Subject
Next Message Malik Rumi 2018-11-24 13:26:58 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Previous Message Shreeyansh Dba 2018-11-24 11:23:36 Re: canceling statement coming in slave instance

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2018-11-24 12:17:59 Re: [HACKERS] Block level parallel vacuum
Previous Message Michael Paquier 2018-11-24 12:15:05 Centralize use of PG_INTXX_MIN/MAX for integer limits