pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #18358: I am not able to change the existing SQL connection to Postgres connection in existing application 2+ messages / 2 participants [nested] [flat]
* BUG #18358: I am not able to change the existing SQL connection to Postgres connection in existing application @ 2024-02-22 05:25 PG Bug reporting form <noreply@postgresql.org> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2024-02-22 05:25 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: noordeen.sf3844@gmail.com The following bug has been logged on the website: Bug reference: 18358 Logged by: Noordeen zikutheen Email address: noordeen.sf3844@gmail.com PostgreSQL version: 16.2 Operating system: Windows Description: I changed the connection strings in the web.config file and added connection strings, Entity Framework code and System.Data code. But we are getting exception like this Keyword not supported: 'port' And when we tried to scaffold the PostgreSQL database in the dotnet 5, 6, 7 console app, we are getting error like this Exception data: Severity: FATAL SqlState: 28000 MessageText: no pg_hba.conf entry for host "10.136.66.234", user "doadmin", database "defaultdb", no encryption File: auth.c Line: 535 Routine: ClientAuthentication 28000: no pg_hba.conf entry for host "10.136.66.234", user "doadmin", database "defaultdb", no encryption enter image description here We have a project and class library in .NET 4.5 and we are using Microsoft SQL Server as database and we want to migrate the database into PostgresSQL. I tried but I'm unable to migrate with the existing DbContext file. I didn't get a solution for this yet I am currently trying with the new console app in dotnet 8 and from scaffolding method created models and DbContext file, again I am working from the beginning. And from other dotnet version I was unable to scaffold so gone with dotnet 8. Can I have any solution to migrate from Microsoft SQL Server to Postgres SQL? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18358: I am not able to change the existing SQL connection to Postgres connection in existing application @ 2024-02-22 10:15 Daniel Gustafsson <daniel@yesql.se> parent: PG Bug reporting form <noreply@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Daniel Gustafsson @ 2024-02-22 10:15 UTC (permalink / raw) To: noordeen.sf3844@gmail.com; pgsql-bugs@lists.postgresql.org > On 22 Feb 2024, at 06:25, PG Bug reporting form <noreply@postgresql.org> wrote: > Routine: ClientAuthentication 28000: no pg_hba.conf entry for host > "10.136.66.234", user "doadmin", database "defaultdb", no encryption > Can I have any solution to migrate from Microsoft SQL Server to Postgres > SQL? The error is fairly clear that Client Authentication failed when connecting, that might be a good place to start investigating. -- Daniel Gustafsson ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-02-22 10:15 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-02-22 05:25 BUG #18358: I am not able to change the existing SQL connection to Postgres connection in existing application PG Bug reporting form <noreply@postgresql.org> 2024-02-22 10:15 ` Daniel Gustafsson <daniel@yesql.se>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox