Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQcOf-000534-No for pgsql-admin@arkaria.postgresql.org; Sat, 24 Nov 2018 18:11:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gQcOd-0004O2-5x for pgsql-admin@arkaria.postgresql.org; Sat, 24 Nov 2018 18:11:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQcOc-0004Nv-Rb for pgsql-admin@lists.postgresql.org; Sat, 24 Nov 2018 18:11:10 +0000 Received: from mail-oi1-x242.google.com ([2607:f8b0:4864:20::242]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQcOV-0006eS-PE for pgsql-admin@lists.postgresql.org; Sat, 24 Nov 2018 18:11:10 +0000 Received: by mail-oi1-x242.google.com with SMTP id j21so12371284oii.8 for ; Sat, 24 Nov 2018 10:11:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=eqKC2mFnlgmxe6MER30T0gQ0+OG2mLZrgvKDXyQgIas=; b=P9LDIivMViI3Eaq/oOoSvBXoFhLQwNWmCAAmYWvNItPbFIfoBdK29qOa2XdUrMNWR4 XNeiHTHCYGCe1fuqQK/WnMuMvl6y/8vq/Hnfpv/CFePreak7KO57miM+Uap/5fVNb1ku LIBSFeTQZ5uQCZP6meMmaFSjVzzmFsV8sRIrLl9+nzNlq4WbT7BAbfnhp4dW0smBCiMA uIvxMFd8ywhTg0yDsOwxH4i4zi8qzM5prItuEN0+twqmiKAcecQjSDDzCoyf6J+WRRN+ PG6tBRBZnSj3WiLkzL36vZZpkj0vgGUx6KrR7M4BMTZJZo6hR1vh9SZLAQK+IOwFOAR/ mwpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=eqKC2mFnlgmxe6MER30T0gQ0+OG2mLZrgvKDXyQgIas=; b=Ia2j/3lRPVY7xAMjmZUQVacEUBDbLvZJpf2qT2PLKHpY3pHjHiv0UnRw72TUoe1zp0 OZ7XBDKo0VfG82y2YiYU7CazLe3LKfcm3+e9lcmANF1+mZwXgGrWKUY7KuIC5S5d90B4 j/bvprpAQruWyKr3Dyp6MSRUO+bz0YkkgC4vdUs3Hix6MVo/k00uyzNuxCn9BLA025sB NxJ1v4h1QBXHXgxiOQB61qoJClSm1krBB2Pr+33pAXWuqV68Y+8bI3bttu0/MRpbQQF2 6vahxoDAhdEeAZ0Xog5KaJE/IcD0eASWzVjvqZLxSQYSPm0dI0ehvCv0SWi8KX/mAGzd psUA== X-Gm-Message-State: AGRZ1gJvj/Lf4rogfOsj2qqgR+Fd33gn/EcU+9BLb78HTTV6+ATOtHrx RVSHjdnCwvA3fRRH2OzJvQmMLf/W X-Google-Smtp-Source: AJdET5eD3/YlFe/GP/cFhXLb9QtiXXent/kh7qAC//vLDhg8krTSaSdpKjRbY4x5P17h2VKY2ssvog== X-Received: by 2002:aca:430b:: with SMTP id q11-v6mr10590365oia.37.1543083060882; Sat, 24 Nov 2018 10:11:00 -0800 (PST) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id f127sm4968472oia.19.2018.11.24.10.10.59 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sat, 24 Nov 2018 10:11:00 -0800 (PST) Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL To: "pgsql-admin@lists.postgresql.org" References: <964914383.8186.1543026683916@wamui-moana.atl.sa.earthlink.net> From: Ron Message-ID: <5160c16f-6b7d-5342-3c69-ca0b198a21b9@gmail.com> Date: Sat, 24 Nov 2018 12:10:58 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------3D824B5D4D5E5CBCCCD82955" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------3D824B5D4D5E5CBCCCD82955 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit By default??? On 11/24/2018 06:16 AM, Ricardo Martin Gomez wrote: > 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 > > ---------------------------------------------------------------------------- > *From:* Ron > *Sent:* Saturday, November 24, 2018 3:25:02 AM > *To:* pgsql-admin@lists.postgresql.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. -- Angular momentum makes the world go 'round. --------------3D824B5D4D5E5CBCCCD82955 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit By default???

On 11/24/2018 06:16 AM, Ricardo Martin Gomez wrote:
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.


From: Ron <ronljohnsonjr@gmail.com>
Sent: Saturday, November 24, 2018 3:25:02 AM
To: pgsql-admin@lists.postgresql.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.

--
Angular momentum makes the world go 'round.
--------------3D824B5D4D5E5CBCCCD82955--