Feedback-ID: i76984098:Fastmail
Message-ID: <e5db1c33-bed0-4a28-8d3b-8814e1ae03c5@aklaver.com>
Date: Fri, 2 Aug 2024 08:05:33 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Connection Issue
To: Andy Hartman <hartman60home@gmail.com>, pgsql-general@lists.postgresql.org
References: <CAEZv3cqiwtn+QnPSvjtia1Tr8aVZuGBpmtMEOy-g6+6zVwrS-Q@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAEZv3cqiwtn+QnPSvjtia1Tr8aVZuGBpmtMEOy-g6+6zVwrS-Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/e5db1c33-bed0-4a28-8d3b-8814e1ae03c5%40aklaver.com>
Precedence: bulk

On 8/2/24 07:56, Andy Hartman wrote:
> I'm using a Powershell script to connect to a remote 16.3(windows) 
> version of the DB.
> 
> Add-type -path 'C:\Program Files 
> (x86)\PostgreSQL\Npgsql\bin\net451\Npgsql.dll'
> 
> # Define connection strings for MS SQL and PostgreSQL
> $pgsqlConnectionString = 
> "Host=xxxxxx;Port=5432;Username=xxx;Password=xx;Database=xxx;"
> 
> # Create connection to PostgreSQL
> $pgsqlConn = New-Object Npgsql.NpgsqlConnection
> $pgsqlConn.ConnectionString = $pgsqlConnectionString
> $pgsqlConn.Open()
> 
> 
> When this statement hits I get an error:
> 
> Exception calling "Open" with "0" argument(s): "Authentication method 
> not supported (Received: 10)"

Best bet old library that does not understand scram-sha-256 authentication.


> 
> Any ideas?
> 
> Thanks.

-- 
Adrian Klaver
adrian.klaver@aklaver.com