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 ) id 1tOjMz-008MMI-KV for pgsql-general@arkaria.postgresql.org; Fri, 20 Dec 2024 20:13:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tOjMz-00GF65-0g for pgsql-general@arkaria.postgresql.org; Fri, 20 Dec 2024 20:13:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tOjMy-00GF5x-MF for pgsql-general@lists.postgresql.org; Fri, 20 Dec 2024 20:13:08 +0000 Received: from fhigh-b4-smtp.messagingengine.com ([202.12.124.155]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tOjMw-000bs4-3y for pgsql-general@postgresql.org; Fri, 20 Dec 2024 20:13:07 +0000 Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46]) by mailfhigh.stl.internal (Postfix) with ESMTP id 81ABE2540139; Fri, 20 Dec 2024 15:13:05 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-06.internal (MEProxy); Fri, 20 Dec 2024 15:13:05 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1734725585; x=1734811985; bh=XC7clXMVAmy+n0duHNT3jS7QHXXA+gS1WS1VGIUHUKQ=; b= Q0TxZu0EDodYhULurcr/yMqAXfOV2ZywJjbvbFWdSOx9HCXuCeyHm0JKv7mLXo82 mTyZwegcyiiYenB6DwdPgNP/s6CKsvoMvwNAZbaPPJ0xwPqam0qj6w8A1Cu9JJeK KdMXaq3AawaSLSMvAKAgY+z/Veq1VuVXfqXwtjC3IoduY6at2CAYXkY1aDOlFN2y vt44U8yyR5t3zM71Gi8HaM78CUs1mbiSy7WP3s7PMyvOrIsgcPY+3T7+SzA6r2ck 1hTq57SUmm7kXzQ6/axojWyBEtxJeNSE6//XKaiiv4IgTxYWt/tFy2T0lYRxCfs2 TcUqjLGfy89DVKk3fHr0ow== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1734725585; x=1734811985; bh=X C7clXMVAmy+n0duHNT3jS7QHXXA+gS1WS1VGIUHUKQ=; b=maRduvOnh3o7Yi6HC nsMLjlZfWLgwGuQaHRzFz1bcAkxjW5hgRpsCyifMkdDdJWXQGQTcGZz+SSKk79/p dS8gpRo9Hhreh/NO4L/VCiaVBmD1XKkzi+WWh6yoD/NZr1WkFRCghcGpN2f98ewW M1qz+OmCk8wbKSKM4ImYOm0UOAUH3nw2O7qVebeJ9USGlSUqyZ53Weyk0YLxDmzj uqJwUD/PLGMRTZ9jKNVoMCyQj1q673z0hh208ULysYhD0FzYY+NAs97X3PI0QZ/K Kk4G9NzhatZIrfhO0evqoeCP0cDccNNC02tVOmVEUW+pELpEFJHL/2L8pekNI5C9 Y6rsg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddruddtvddgudefudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecunecujfgurhepkfffgg gfuffvfhfhjggtgfesthekredttddvjeenucfhrhhomheptegurhhirghnucfmlhgrvhgv rhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrg htthgvrhhnpeffleegieefgfevudehtdfhkeeutdffjeevgeffgeejvedthefgudeiteef heejheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe grughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpdhnsggprhgtphhtthho pedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehmrghilhgsshhvseihrghhoh hordgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlhesphhoshhtghhrvghs qhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 20 Dec 2024 15:13:04 -0500 (EST) Message-ID: Date: Fri, 20 Dec 2024 12:13:03 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: any tips to have restricted inbound and getting connected with postgresql dB To: Y_Bharani_mbsv , pgsql-general References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <273a88dc-4134-47d5-bc19-30ff5f97926c@aklaver.com> <498dfb34-4dd7-4f48-8188-355e1488d7e6@aklaver.com> <1061066336.5835157.1733316137292@mail.yahoo.com> <1918413683.2239751.1733944364448@mail.yahoo.com> <037a8338-3434-47d4-aaad-ef186d4d3250@aklaver.com> <101139100.4053671.1734383960480@mail.yahoo.com> <1875422740.4095620.1734388259706@mail.yahoo.com> <1528119631.4096246.1734390318281@mail.yahoo.com> <2033286177.1733661.1734651404850@mail.yahoo.com> <8833d8c7-3713-4d6f-9eab-35270e769564@aklaver.com> <1392047062.5689697.1734710997053@mail.yahoo.com> <783439164.5695290.1734713539262@mail.yahoo.com> <928427177.4710979.1734722745840@mail.yahoo.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <928427177.4710979.1734722745840@mail.yahoo.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12/20/24 11:25, Y_Bharani_mbsv wrote: >  Team > I have the need to have postgresql db running in multiuser mode and do > my needed tasks for few mins. What are the tasks and why do you think they can't be run concurrently with other users? > > How to restrict all the application layer , not to get connected with > the postgres db , > during my specific time window > I am aware of their application layer - username > > Changing password is the last option > > Any tips > -- Adrian Klaver adrian.klaver@aklaver.com