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 1halpY-0005Ke-GH for pgsql-admin@arkaria.postgresql.org; Tue, 11 Jun 2019 18:49:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1haloZ-0006nT-Da for pgsql-admin@arkaria.postgresql.org; Tue, 11 Jun 2019 18:48:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1haloZ-0006nM-1a for pgsql-admin@lists.postgresql.org; Tue, 11 Jun 2019 18:48:11 +0000 Received: from mail-qk1-x743.google.com ([2607:f8b0:4864:20::743]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1haloW-00056a-By for pgsql-admin@postgresql.org; Tue, 11 Jun 2019 18:48:09 +0000 Received: by mail-qk1-x743.google.com with SMTP id a132so8306213qkb.13 for ; Tue, 11 Jun 2019 11:48:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:openpgp:autocrypt:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=QUurbQUyD+HnTDY1N0l9IV3HCHRjHUko0tYkiNq2xo0=; b=odk0pSOGcq/uYRuqijDhDY5sQoaJouvfJ7CC249u6eSKXBJfC+mBnVSSSiZNpIdaXD 9zEXGKUm6qry1WEwVZgRJPdGvGh706+zr6KXUruOPpqiKIMmtlULk23EgM7w57KbC60g F7ZPi9nlT1ypDs4AWHJV6XsRyNc4gy/ZOwv+Ed0PXhbms+s6RRE0XUIukTmqQmPChzRs 8JwZ/w8N1kn6ugieAZjNqqptpgBrfQQQPYGz7vBst33+c5uXuNf2ptiuaO/XqEjPDlJQ claysLLWWhRutTVigxcv+N9noUfA1mjhf9U9d3oBQUjwR0MLZXES1I3GC3KI6GNFAQF3 DK0A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:openpgp:autocrypt :message-id:date:user-agent:mime-version:in-reply-to :content-language:content-transfer-encoding; bh=QUurbQUyD+HnTDY1N0l9IV3HCHRjHUko0tYkiNq2xo0=; b=lnr4EiBWx1n1rVtEMsoCvy6NqPmxsx1hGZCQwdzAh4Hphp/qw4NLrvlB03OKGIP8IZ 1gFEVXKUksISHeS++RgjnE6m3t2i0fAUPNwb8F4P7wqRz8m/D/nGDmkGh9Z1iHz3b7M4 REX3UqJnymcXw+S5+OZOLVyp23w5e8jn9hMwIbV/qeQcGqzHw96oUfzg5+tf3/sVpayg H+X/1yoksBwJV3Pm0bws1JwaLxXO/ji8IY62IQd1aD1QuXZ1h3Rs78Mn8BF3O3MhkLRc Ck2EOCugCQo8UvR6JaOjdmJAmfBXZVIJl1joR/ONRxUSH8Mqhp35CgH+W9RrnavYAOP1 k7RQ== X-Gm-Message-State: APjAAAXffCwXubwa+1aLqgSq/bR/4+mxbv0qC+GyWZ8Hm/AW7hivGDNl JATyQKkZWWUs0mO4j1d0eQUJdisYIuC4eHLMNH3p1RNrf88Tv99EOhuAqHNlYEm0Pixpf4UHA04 3L7b3wkfPKML0lVfKaD+TV0tNOsUGbaDSO941PLfBvzRxZD9K4gOGKjpoQeR0/wgET0iF+Kh9wN i4 X-Google-Smtp-Source: APXvYqzAQhMsACzM1nauBrBtn8PpqFdFANAPuuSgEEIPXEiOEJgItk9cIpvwqP9RWPjbABuQRMt3DA== X-Received: by 2002:ae9:ee0b:: with SMTP id i11mr54998161qkg.96.1560278887113; Tue, 11 Jun 2019 11:48:07 -0700 (PDT) Received: from hoth.marques (host23.186-109-211.telecom.net.ar. [186.109.211.23]) by smtp.googlemail.com with ESMTPSA id n7sm7033343qkd.53.2019.06.11.11.48.04 (version=TLS1_3 cipher=AEAD-AES128-GCM-SHA256 bits=128/128); Tue, 11 Jun 2019 11:48:06 -0700 (PDT) Subject: =?UTF-8?Q?Re=3a_=5bMASSMAIL=5dAyuda_T=c3=a9cnica?= To: Manuel Garcia , =?UTF-8?Q?Departamento_Soporte_T=c3=a9cnico?= Cc: "pgsql-es-ayuda@postgresql.org" , postgres admin References: <5a21de4ac9c1e611df4a82f1a33b819c@etecsa.cu> From: =?UTF-8?Q?Mart=c3=adn_Marqu=c3=a9s?= Openpgp: preference=signencrypt Autocrypt: addr=martin@2ndquadrant.com; prefer-encrypt=mutual; keydata= mQENBFGQ9akBCAC+rCultjweJUjKgFfj0s3XQULnyNrC3N8C7Y2v5xPEw+EZAD6+kVDimItf jY2oZGdP8+dmfr79zVSx7IBN+BPXiz+8k+DnGrHchIrGoVcXbOomqqKBYDQYA1DvGU4Nfu3+ g7Iu3FFRdOuJkhW6mP+uXLs3VudM36Ksu9nnWSAtZ7+1k4klstwQEIJk+8xDIi2azJnLstY7 mPOEG2jOIhC0w2Wl6BWIQi0pJr/EjfZRgta4ZrbHnROJZubRcdaZxZmT1bWjrAdPRo3taJzm A82hIh4gTkaFRmiyDvMu8Iu1k1dw1bA4ranrs1MwBbnXZFjLpjXrtc82+btU7yQN4Kb9ABEB AAG0OU1hcnTDrW4gTWFycXXDqXMgKERCQSBBcmdlbnRpbmEpIDxtYXJ0aW5AMm5kcXVhZHJh bnQuY29tPokBPgQTAQIAKAIbAwYLCQgHAwIGFQgCCQoLBBYCAwECHgECF4AFAlsCpfUFCQ00 FzQACgkQewO0SAEAVNKFygf+O2tIEXklaoSUhx2XM62NX7Ao8VaTaVBFZv1PFyKjqK96NZL6 oGjqO9z7LXjIWUatXVBH3Cxa4j/RNovWh0eNykIHZQN/gAYNB9eE8TmRRtj+S3D/rukwnu2s 16ALzEu5x2OABFEgj+/hH3JFViSC1mBnibFLYtTm4ydzL/URpObffgCeHXxBrHZ0o7XZsTBk 8UwNcsFpblSEdEpCZj/14UwAlEs5DPEMqn0I0hNHcVbliPKhy7CETJSet0hbpJvFqaJTbb0d p6i/Z8bHP0IrmYJWpkX5vH9oexYyPRM+nc1FXJnich3MtHfA/fTtGrM9XLWCt+NX5pdkHIUE ApfLXLkBDQRRkPWpAQgAoNxnsp7AIiOBT8ufUbTGFWNbOsViwFT7kMnQixNaR69S/YBxkWit BdogJA9D0y0j/qBEzY+XwZGVPLi4eYYRl0+u6qobpmgy2fIGaIyW8H20Zi8RYcjbixfLNrZV W0Wj4RDgiv1wnJqlTTu6sNtv1pHXfxnTxB27DHbQnNiBt/NC4gvy3TRIEzAECOg+unFtOxhS jx6uNRllU/uo7iPYUyJT5HyTNxYQQRK3h6wGhtMlxPi+0mY7TvsS0Pmvi5wWPQRRRs+waYbX A7lYXO1a1SCeR4KgTm3AXcj0iTPL7xxsMZQuPIaJMf/p9x4Ay4M9V6Mn02AvA6TQezL7NVsO gwARAQABiQElBBgBAgAPAhsMBQJbAqZ8BQkNNBfPAAoJEHsDtEgBAFTSItoH/2l15R9tmcRv zuNpsoYxpI2u+hvItRiXTN0Q5cOiiR7t03I1LjqSu66DhpvNCpWcQ05KUyrUH6S/GrDHHkbX 461XwdTjJDjQB8DiKmLRduf/CLD9uhpKDocGiazN0rJrLwDIok73YjCBiOV5CRmEyCoK1mNW suMNC6sMjNdBUi2ZOFAcrvG+RotsjDDGc0fRAV9UhykJuZuiE+no6f/WDu/iV2bAU832+/m1 5Nh06IDKazVMw/Twfkxm1NTTL6W/wcQIk0LjAFSDzgYud0i0lbe67R+Al94n+Zfp5slgsB4u xGH9NyG1PkFOSA8WyXSEWXbLPgXmZh/E6FqefUbHnjA= Message-ID: <6baf3ee6-60fd-3528-b78c-5bfc032e5956@2ndquadrant.com> Date: Tue, 11 Jun 2019 15:48:02 -0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: es-AR Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk El 11/6/19 a las 12:46, Manuel Garcia escribió: > Hola, > > utiliza el comando netstat -nptl para saber si tu servidor esta com la > ip y la puerta como listen puedes tentar dar un status en el servicio de > postgersql o ver el log para mas informaciones > te dejare un ejemplo basico de configuracion del postgresql.conf > > listen_addresses = '8.8.8.8' > port = 5432                        > max_connections = 100  > superuser_reserved_connections = 3  > unix_socket_directories = '/var/run/postgresql' > unix_socket_permissions = 0777 Yo te recomendaría empezar mirando las reglas de firewall, ver si el puerto 5432 esta abierto a los nodos desde los que te querés conectar. -- Martín Marqués http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services