Entity Framework with database-computed identity values don't work with Redshift, since it doesn't support sequencesĭigitalOcean's Managed Database services requires you to connect to PostgreSQL over SSL.If you want to connect over SSL, your connection string must contain Server Compatibility Mode=Redshift, otherwise you'll get a connection.
We try to support Redshift as much as we can, please let us know about issues you run across.įirst, check out Amazon's page about Redshift and PostgreSQL whichĬontains lots of useful compatibility information. In addition, due to its nature some features have been removed and others changed in ways that make them incompatible with PostgreSQL. Amazon RedshiftĪmazon Redshift is a cloud-based data warehouse originally based on PostgreSQL 8.0.2. In addition, the Visual Studio extension (VSIX) and the MSI GAC installer have been discontinued. Starting with this version, we no longer run regression tests on. NET Standard 2.0 which allows it to run on.
Please let us know if you notice any non-standard behavior.NET Framework/.NET Core/mono
#Redshift postgres drivers#
NET database drivers and should behave the same. Npgsql is an ADO.NET-compatible provider, so it has the same APIs as other. We aim to be compatible with all currently supported PostgreSQL versions, which means 5 years back.Įarlier versions may still work but we don't perform continuous testing on them or commit to resolving issues on them. This page centralizes Npgsql's compatibility status with PostgreSQL and other components, and documents some important gotchas.
0 kommentar(er)
