Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qdpBV-004qyn-32
	for pgsql-admin@arkaria.postgresql.org; Wed, 06 Sep 2023 09:50:53 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qdpBT-008qPA-1N
	for pgsql-admin@arkaria.postgresql.org; Wed, 06 Sep 2023 09:50:50 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ewie@ewie.name>)
	id 1qdpBS-008qOr-I8
	for pgsql-admin@lists.postgresql.org; Wed, 06 Sep 2023 09:50:50 +0000
Received: from mout-u-204.mailbox.org ([80.241.59.204])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ewie@ewie.name>)
	id 1qdpBO-003OJV-Ra
	for pgsql-admin@lists.postgresql.org; Wed, 06 Sep 2023 09:50:49 +0000
Received: from smtp1.mailbox.org (smtp1.mailbox.org
 [IPv6:2001:67c:2050:b231:465::1])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits)
 server-digest SHA256)
	(No client certificate requested)
	by mout-u-204.mailbox.org (Postfix) with ESMTPS id 4Rgd0g2VPWz9sQY;
	Wed,  6 Sep 2023 11:50:43 +0200 (CEST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ewie.name; s=MBO0001;
	t=1693993843;
	h=from:from:reply-to:subject:subject:date:date:message-id:message-id:
	 to:to:cc:cc:mime-version:mime-version:content-type:content-type:
	 content-transfer-encoding:content-transfer-encoding:
	 in-reply-to:in-reply-to:references:references;
	bh=uF6hy7wu1SjxPOe/Yyv5BtwcPyhvZNKyz7hwFpFicY8=;
	b=r8FD6dur0DGWxCsyiDYpafBqcYioG4D2A96SqvMWNKcqTUlRD0rgB861xydw7pu2z1eYTN
	v3iXDXm0bz0t6FGEU0pSr5KTjuXE3IGc8EZEyi+gS8694WBzRT1XMKqnOKZP6kaIFjONEX
	eMyz52hWwWHMi3AurLiuVF4ozlz94VKR3qQQ1WUJ+/NiRohGecLmiyWRcIerEXPVTTKUAK
	dpohbMAzG5eOdMLDFhIdp/rE2tuF0czJy9pgQp7jJU0xkonEvgFQjG09KwZIvEGWF/7oRE
	dt/zi0rOQ/QytqCFFz7DL+jQghjqXbb/coO6Y0VtauMutQXc+LWfYf7UwtnXQQ==
Date: Wed, 6 Sep 2023 11:50:42 +0200 (CEST)
From: Erik Wienhold <ewie@ewie.name>
To: Daulat <daulat.dba@gmail.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Message-ID: <680744501.329448.1693993842681@office.mailbox.org>
In-Reply-To: 
 <CALfOM6L9KvaaJC0hukfkr-W+a0cQLLMRYA78xjRtipWVjGnJFw@mail.gmail.com>
References: 
 <CALfOM6LjKQ4+YTo7eWivnfDny9iRCOvwTij4kQda6qJ=zWgLRw@mail.gmail.com>
 <1504262683.74455.1693661277706@office.mailbox.org>
 <CALfOM6L9KvaaJC0hukfkr-W+a0cQLLMRYA78xjRtipWVjGnJFw@mail.gmail.com>
Subject: Re: DBLINK Error
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Priority: 3
Importance: Normal
X-Rspamd-Queue-Id: 4Rgd0g2VPWz9sQY
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/680744501.329448.1693993842681%40office.mailbox.org>
Precedence: bulk

On 06/09/2023 10:01 CEST Daulat <daulat.dba@gmail.com> wrote:

> It is working fine after restarting the postgres server.

Did you modify pg_hba.conf or other configs?  Those must be reloaded with
pg_ctl reload  to have an effect.  Of course restarting works also but is only
necessary for some config parameters.

--
Erik