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 1qujjh-001UOt-8Y for pgsql-admin@arkaria.postgresql.org; Mon, 23 Oct 2023 01:28:05 +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 1qujje-003Otp-Uo for pgsql-admin@arkaria.postgresql.org; Mon, 23 Oct 2023 01:28:03 +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 1qujjd-003Opg-Jp for pgsql-admin@lists.postgresql.org; Mon, 23 Oct 2023 01:28:03 +0000 Received: from mail-bn7nam10olkn20823.outbound.protection.outlook.com ([2a01:111:f400:7e8a::823] helo=NAM10-BN7-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qujjb-001pLg-0X for pgsql-admin@lists.postgresql.org; Mon, 23 Oct 2023 01:28:00 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Jn61LO+iJw3Jax1yY7nMNy23tCKMq1TAZArMg6XfCR9jETFG+wIIIljn2SUOFfo57r1/iVhdACPXBcNYuEEj5v5sBSNIT4TVnAgCC8fKd5+GwEMx7ot2ylT08Aa+mtaQktaT0ZptNI3v1m7mtGtvYf1z0WwiBrjcNRk5yo4FCcZFIYUJ1vJjpNXBeK8xhkJF2IP6Tp203ELff0j5fkv99+YcHcgVXrZ/Mme9U7Fe1eArOyiJZMb4uSbzsYMr36Z+Q6dWjC2/x0ruCPnw8Iv8WUKtpCXKP8lSOIHLYLM24Z28YFwdWdSbzQkFrbPeg8CJmm6bA7r49prg6L0tqo/OLg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=xsmSqyaKzJPVnTCl2enZVuwCMw4srZ4FClC979kO/eE=; b=PaV6p3qfT2ayS4A3Fd/FIVk03LojZmxrLevEzphReb8zNFiCyjqCyiGU8bATKPjf/iLugQWxM1UTwjDpACVm49laoxVMXgaWerHqP8Wxb0sGBAMzScrJD0/biWfkYxLUHy0BRyj5tHI34XA7aXYDYIA9HK9Yb6sWmAkDrnkNiYqmhrpJ9zxG19WwP3DVgUjuUh9l8OpzOApPMo3UNLpvgoMBrMf089IMr6JSH69jJ50wxJ/MN8RiXF6zG42qg7DL0TTckp5ljkjNOQNmibOafLZAazndrKfgzqlldvVV7qEHiVYQiu565bNwYUXfPAFdzZ9A+ZGwoVSkmn/xkAd6jA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=xsmSqyaKzJPVnTCl2enZVuwCMw4srZ4FClC979kO/eE=; b=aW4QdR05p1YHd6SpJ1GdIxlgVLR527j9MDOADwrNdAWJNBfZyCBRqOS4ttZxZcEQqk4vf+tywhfZs274HjRhqRTvO0Zf6rOWTQ/VOd5bwA4OhNYTREt2e/OIhYauODNxSttizBslECrHyky3zWqAshLGXwkLL90ZLUxGsLKGXi9v/nb3+ENmY9bCPZs8Fa3KWlNB8aR3W05i4LaNB58mOuKVhUsuDRRr/wiRUVfhA4B2YGV6nFt5nZP1n7DhEaIISXO2MWzYyUhHedCooHMpFg+fsLohvtpbuqr5jM06YOHGSl+IVYHsF5Ir7tJ4fl+6zAOvbNnQ/ULNtbGux+U5RQ== Received: from DM4PR19MB5978.namprd19.prod.outlook.com (2603:10b6:8:6a::18) by PH7PR19MB5991.namprd19.prod.outlook.com (2603:10b6:510:1de::16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6907.29; Mon, 23 Oct 2023 01:27:55 +0000 Received: from DM4PR19MB5978.namprd19.prod.outlook.com ([fe80::5812:5a6b:a25:42c8]) by DM4PR19MB5978.namprd19.prod.outlook.com ([fe80::5812:5a6b:a25:42c8%4]) with mapi id 15.20.6907.030; Mon, 23 Oct 2023 01:27:55 +0000 From: M Sarwar To: Erik Wienhold CC: Ron , "pgsql-admin@lists.postgresql.org" Subject: Re: Need to run pg_dump from the laptop without entering the password Thread-Topic: Need to run pg_dump from the laptop without entering the password Thread-Index: AQHaBCkvxiQORYUkvkuWeChIb9XRV7BUW2EAgAIBclyAABdNgIAAIr/D Date: Mon, 23 Oct 2023 01:27:55 +0000 Message-ID: References: <2194a8e8-f1cc-4c72-96cb-710dcd973094@gmail.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [Ewe3eDeQwiED9RSFwP/wSYGQWVOQTiIVWNhpykaS2rbLuF/tTQwuPXmauuXX1IYY] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DM4PR19MB5978:EE_|PH7PR19MB5991:EE_ x-ms-office365-filtering-correlation-id: f4469eb4-64a2-4be7-9d51-08dbd36748bb x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 9FCwwqbpPqiazXA6qZye3CkL78A9ECdBVxLMHsms5PA/Lo/zakpUsHcm1qLDbDxIZuLoFlVuAskw+fJgxo6+556nt+2S8IOy+M8tvWkfisTrGaJ4s3PdQ01mOrpAqmjrdREQTIikh6b+hcSsai9VZnrdgQoiXghnM39y/jutDvNCQfU0u+HsTAPo7wxTA36CPWL0NslOZKfZ4wc9ZbiiohNNHyrfjW47wyVk9E1LxuE/Eg3uk0HUxFNwpyhJ08RqbeI57xZ6eUXkvNmAkPSCCLr9vIjLIahSTIPaKxjHDXAdoPuUGEn7h9gH7Y5X4Fh/nyj98VoeHUqb9gDIyADC0cI0rTGAPstIdMBy0vMgshNKLmVgAY788hVu9b3Mxp990LNZ/8/RMIOm5MszuwS0i8pdcMiJAPSRB1rW7hAqZ7NMGDKxCBvrVf3+1nJOANwA2vIDq6gspAm5CL7P7NsyJ9AZT69mUGh/OKHJV/FNhNGMlkCK2qJO1jAefpgwobHZmuXLfWFd8TVBOE17NOPppNjCEDxLaD3YwyBnhZjDwzK7QlYaQspdFUSWjTGLel5/ x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?3nmY2K+vXPHQdjxSGaxV1jNPuO/HNiKo2xnGA8h60e9CMKEWzl/YT9PWVU?= =?iso-8859-1?Q?zKEEvBPCd0sGrgiiAjAsDmIWVUlKDYNNWbZHJRW+skwEdAhYRkQQcoad8K?= =?iso-8859-1?Q?5gKvK/Iox33l9Xmht4GEHe0Ms1sn553h3QpByySZS1m/5VCuwKzsRGh1QO?= =?iso-8859-1?Q?xY/2v2sGoi98NrkB8oLkRMeCRUSsuuR0GRVtdr7UkT7wf9MX8hQtaO6XsE?= =?iso-8859-1?Q?4y4GODkDxEiIAqU5nhBE9tKIPA/Gncm4hdDZoZXLkDxeAurW3Q+8pJhRRy?= =?iso-8859-1?Q?reyXhI3edV708cDNU/m4sLMJg9ZvgEKTDUdIIrWF9nug3/ek33HmeeKPOQ?= =?iso-8859-1?Q?USqyzuuHqVxNGnIpQgCqAjDWCnWYHfSiefrdhfJaEWc0kQ7othNqpbyXF2?= =?iso-8859-1?Q?YaM5+UbDg4Sp7opK0nwfbrxPtgzZdpB3x+8vvPyzPjj4uli8NYndk2sx5R?= =?iso-8859-1?Q?Wo1SwT8LPqCUOUvpU05wUTtqtoRFaI6eJ+dRrEXnkK8dGZRHvvrUZXl/Mh?= =?iso-8859-1?Q?ROBfkiyeMG50KCFsti2UTVKxdpP0041VXTrzc+JzBw6E362pRpViPkS2ID?= =?iso-8859-1?Q?7BZOi06hvONaOps6NRDtlRJPOLuof8irJbdz9MycsF+/sa7p+12+uPMWGS?= =?iso-8859-1?Q?VX8fvmNAePUCEmwdAX2E/AsewR6B5rNNJUsUvo3IosxFx3qnWXscD7e8oU?= =?iso-8859-1?Q?62sfxw4fP1UudwdJME4+xrDgh582I8SfpCW7YIhBTTs5Dy8kiHmestut2l?= =?iso-8859-1?Q?+O/5fqRKcCIP0V7Q+HwNpcKBSSXNLR5L5xMOA2QgM05DafD97aLJxpsDm5?= =?iso-8859-1?Q?w+Mi6c1AESw9HaOOLAKN3T9R2TDg5UdiuSNhmb2WIfu1sISn4MgbujhZA8?= =?iso-8859-1?Q?HpmzOZquC78tjavXZVK39A3AoQO8aXqLXmvQdZgmYpYKVm0Sx1cTeWUNWf?= =?iso-8859-1?Q?8LBGB7Pgy1H8JC8McxpKh0ycpkC0587Y2wZW3xfNgDtXeAj3pYHBxfoodk?= =?iso-8859-1?Q?vKpaY4dw7a8a29FqIcQefH4lRId0q/3v9WMvoFP7KlECnBl9RJp8L4QT7E?= =?iso-8859-1?Q?gpqfT3A8YMEOEAr84CIAMn9H+IBB4xW1xAMLHX2GMRxyYtqhLJPchC0DZd?= =?iso-8859-1?Q?wIy7tWhYMtpdPPGFHQ4Pq0EY0L5AcxmA2PcuEHwrB/4BxibClaT6YqVgWi?= =?iso-8859-1?Q?fT3U/DF+bgz89TN54VzuC/+PmBcxN+nfY+RqCpaMNcJutRqvfa54HUDPZ1?= =?iso-8859-1?Q?cZcTEBvHqz2397zo7GUtf7zehpJjT1tawPgN7LbPdYALomWq8cjMXhjx0v?= =?iso-8859-1?Q?u3zE/DkdwtXXa+W97qf93v9iuw=3D=3D?= Content-Type: multipart/alternative; boundary="_000_DM4PR19MB59780C2425E2D6B8DB5AC26ED3D8ADM4PR19MB5978namp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DM4PR19MB5978.namprd19.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: f4469eb4-64a2-4be7-9d51-08dbd36748bb X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Oct 2023 01:27:55.8059 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: PH7PR19MB5991 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DM4PR19MB59780C2425E2D6B8DB5AC26ED3D8ADM4PR19MB5978namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Erik, 1. After seeing your email, I have verified another time now. It is a RD= S endpoint. I see that host naming convention followed correct. Case sensitivity is not= an issue. 1. Yes, N28068 is the user. At this time, I am running the script manua= lly. My plan is to schedule the script thru a job and the owner is going to= be N28068 . Thanks, Sarwar ________________________________ From: Erik Wienhold Sent: Sunday, October 22, 2023 7:19 PM To: M Sarwar Cc: Ron ; pgsql-admin@lists.postgresql.org Subject: Re: Need to run pg_dump from the laptop without entering the passw= ord On 2023-10-23 00:31 +0200, M Sarwar wrote: > Now Error Message:- "pg_dump: error: connection to database "ngbrpesb" fa= iled: fe_sendauth: no password supplied" Could be that the hostname in pgpass.conf does not match the hostname in the connection parameters. The hostname in pgpass.conf is case-sensitive (not mentioned in the docs), so it must match the exact spelling as in the connection parameters. > File names attempted:- > > 1. C:\Users\N28068\AppData\Roaming\pgAdmin\pgpass.conf > 2. C:\Users\N28068\AppData\Roaming\pgAdmin\.pgpass > 3. C:\Users\N28068\AppData\Roaming\postgresql\pgpass.conf Path #3 should be the correct one if user N28068 runs pg_dump. You also wrote that you want to schedule the execution of pg_dump. Does the scheduled job also run as that user? -- Erik --_000_DM4PR19MB59780C2425E2D6B8DB5AC26ED3D8ADM4PR19MB5978namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi Erik,
  1. After seeing your ema= il, I have verified another time now. It is a RDS endpoint.
I see that host naming convention followed correct. Case sensitivity i= s not an issue.

  1. Yes, N28068  is the user. At this time, I am running the script manually. My plan is to= schedule the script thru a job and the owner is going to be N28068 .<= /span>
Thanks,
Sarwar


From: Erik Wienhold &l= t;ewie@ewie.name>
Sent: Sunday, October 22, 2023 7:19 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresq= l.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Need to run pg_dump from the laptop without entering th= e password
 
On 2023-10-23 00:31 +0200, M Sarwar wrote:
> Now Error Message:- "pg_dump: error: connection to database "= ;ngbrpesb" failed: fe_sendauth: no password supplied"

Could be that the hostname in pgpass.conf does not match the hostname in the connection parameters.  The hostname in pgpass.conf is
case-sensitive (not mentioned in the docs), so it must match the exact
spelling as in the connection parameters.

> File names attempted:-
>
>   1.  C:\Users\N28068\AppData\Roaming\pgAdmin\pgpass.co= nf
>   2.  C:\Users\N28068\AppData\Roaming\pgAdmin\.pgpass >   3.  C:\Users\N28068\AppData\Roaming\postgresql\pgpass= .conf

Path #3 should be the correct one if user N28068 runs pg_dump.  You al= so
wrote that you want to schedule the execution of pg_dump.  Does the scheduled job also run as that user?

--
Erik
--_000_DM4PR19MB59780C2425E2D6B8DB5AC26ED3D8ADM4PR19MB5978namp_--