Re: listen_addresses = '*' postgresql 9.5 does not allow local connect

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: kschindl <chuck666xx@xxxxxxxxx>
Subject: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Sat, 3 Jun 2017 20:07:41 -0700
Arc-authentication-results: i=1; mx.google.com; dkim=pass header.i=@gmail.com; spf=pass (google.com: best guess record for domain of pgsql-admin-owner+m46728=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-admin-owner+M46728=spinic=gmail.com@xxxxxxxxxxxxxx; dmarc=pass (p=NONE sp=NONE dis=NONE) header.from=gmail.com
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=sender:precedence:list-unsubscribe:list-subscribe:list-post :list-owner:list-id:list-help:list-archive:cc:to:subject:message-id :date:from:references:in-reply-to:mime-version:dkim-signature :arc-authentication-results; bh=jdg1spy9uDEMh2QKAYWMZ/OLV2/8fq32FI/lUdehaj8=; b=luSlQyhZ/LVXfzX2aZaS5zTMmudH1coP+SSFAAt7e21/I/L2/oDq+JoXkEFoSn92Ta pYp7fpTrUGxIdFlhkX7JvUQvPT5hCzkSNUwZdOEDeAq9F16Wxk+PIQBkHHbmbqErLK2j vfO0t2n76pJcU2f7e3vSZLBSDm+e8ZcgsvuFsKuSDw+gZd9RtfDSrVlM+CEKtRIqTRIH w9lPQNSjh/f7rf1gaTpUPZxqBc1dAOIQoL0YZonP/lRE+OM1rGXrL3giNY/J/uDB4s2b Zw5rQz7G3CuhZl40+PxV5Lx+AT8tZyySd+s7jHvayhPMnnCTmKThQLxEYLPBKJ+dfRnV BGrg==
Arc-seal: i=1; a=rsa-sha256; t=1496545704; cv=none; d=google.com; s=arc-20160816; b=RYzN5SvGfU+NJ2Z2bhOav1CDS7SqP2O2gBJXNO+aSh1Fl3UnWUHIDnItGo1WyjbVVg Mfx54o1Jz4RwGC9UWvQS4zwfUl9NNOcrKgq790ut/oSdFemfC5U8fGE7gllk5HMLcUsj mgEuJvLdr9s+RcbaABhBCSRCG/wh/lN+7i8bxnNWgrRKnkC/HICeBhlfwNePb7VUZ4s3 DaVrv25Gg4+ZyIczdypFromjb5tWuvj9DSN+unCXJxyVAIGAsn4/pfucfEJ/8e6a5NJa ntqyaE4owU/8s+XoDXzHgEK4CpgwdOW3bOxTsEZKw9eqNCXaw0FLgKVOGHzmw+NeqM7m a9Ug==
Cc: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <1496544711321-5964669.post@n3.nabble.com>
References: <1496544711321-5964669.post@n3.nabble.com>

On Saturday, June 3, 2017, kschindl <chuck666xx@xxxxxxxxx> wrote:

when i add the listen_addresses = '*' i cannot connect local (with or without
pgadmin)
as soon as i comment this out i can connect local where the server is
installed

Please show some psql commands and resultant error messages.

David J.

Follow-Ups:
- Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
  - From: kschindl

References:
- listen_addresses = '*' postgresql 9.5 does not allow local connect
  - From: kschindl

Prev by Date: listen_addresses = '*' postgresql 9.5 does not allow local connect
Next by Date: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
Previous by thread: listen_addresses = '*' postgresql 9.5 does not allow local connect
Next by thread: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]