Ошибка 3d000 postgresql

I am trying to use Npgsql.EntityFramework with the Amazon Redshift database.
Following comments in issue #163 I downloaded a match to lc_monetary fix from here:
https://build.npgsql.org/viewLog.html?buildId=14051&tab=artifacts&buildTypeId=npgsql_All22
I no longer get the lc_monetary error, but I do get the following exception:
Npgsql.NpgsqlException: FATAL: 3D000: database «postgres» does not exist

Redshift does not have a database named «postgres», why is Npgsql.EntityFramework looking for this database?

System.Data.Entity.Core.ProviderIncompatibleException: An error occurred accessing the database. This usually means that the connection to the database failed. Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application’s config file. See http://go.microsoft.com/fwlink/?LinkId=386386 for information on DbContext and connections. See the inner exception for details of the failure. —> System.Data.Entity.Core.ProviderIncompatibleException: The provider did not return a ProviderManifestToken string. —> Npgsql.NpgsqlException: FATAL: 3D000: database «postgres» does not exist
Result StackTrace:
at Npgsql.NpgsqlState.d__0.MoveNext() in c:devTeamCitybuildAgentwork45caad201a245970NpgsqlNpgsqlNpgsqlState.BackendResponse.cs:line 143
at Npgsql.NpgsqlState.ProcessAndDiscardBackendResponses(NpgsqlConnector context) in c:devTeamCitybuildAgentwork45caad201a245970NpgsqlNpgsqlNpgsqlState.cs:line 283
at Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context, NpgsqlConnectionStringBuilder settings) in c:devTeamCitybuildAgentwork45caad201a245970NpgsqlNpgsqlNpgsqlConnectedState.cs:line 47
at Npgsql.NpgsqlConnector.Open() in c:devTeamCitybuildAgentwork45caad201a245970NpgsqlNpgsqlNpgsqlConnector.cs:line 801
at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection) in c:devTeamCitybuildAgentwork45caad201a245970NpgsqlNpgsqlNpgsqlConnectorPool.cs:line 393
at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection) in c:devTeamCitybuildAgentwork45caad201a245970NpgsqlNpgsqlNpgsqlConnectorPool.cs:line 236
at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection) in c:devTeamCitybuildAgentwork45caad201a245970NpgsqlNpgsqlNpgsqlConnectorPool.cs:line 180
at Npgsql.NpgsqlConnection.Open() in c:devTeamCitybuildAgentwork45caad201a245970NpgsqlNpgsqlNpgsqlConnection.cs:line 639
at Npgsql.NpgsqlServices.UsingPostgresDBConnection(NpgsqlConnection connection, Action1 action) in c:devTeamCitybuildAgentwork45caad201a245970Npgsql.EntityFrameworkNpgsqlServices.cs:line 164 at Npgsql.NpgsqlServices.GetDbProviderManifestToken(DbConnection connection) in c:devTeamCitybuildAgentwork45caad201a245970Npgsql.EntityFrameworkNpgsqlServices.cs:line 102 at System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection) --- End of inner exception stack trace --- at System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection) at System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection) --- End of inner exception stack trace --- at System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection) at System.Data.Entity.Infrastructure.DefaultManifestTokenResolver.<>c__DisplayClass1.<ResolveManifestToken>b__0(Tuple3 k)
at System.Collections.Concurrent.ConcurrentDictionary2.GetOrAdd(TKey key, Func2 valueFactory)
at System.Data.Entity.Infrastructure.DefaultManifestTokenResolver.ResolveManifestToken(DbConnection connection)
at System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest& providerManifest)
at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
at System.Data.Entity.Internal.RetryLazy2.GetValue(TInput input) at System.Data.Entity.Internal.LazyInternalContext.InitializeContext() at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType) at System.Data.Entity.Internal.Linq.InternalSet1.Initialize()
at System.Data.Entity.Internal.Linq.InternalSet1.get_InternalContext() at System.Data.Entity.Infrastructure.DbQuery1.System.Linq.IQueryable.get_Provider()
at System.Linq.Queryable.Where[TSource](IQueryable1 source, Expression1 predicate)
at Minerva.Tests.Models.DiagnosisDbContextTest.DrugCodes_ByProductName_ReturnsMany() in c:UsersAndrewSourceReposMinervaMinerva.TestsModelsEntitiesDiagnosisDbContextTest.cs:line 56

1. 10-12-2018, 01:04 AM

   
   

   #1

   

   
   Junior Member
   

   ---

   ERROR FATAL: 3D000:database «postgres» does not exist
   

   This is the message I’m getting. I’ve accidently deleted something important from «postgres». It doesn’t seem to reload. Help please.

   More Info: When troubleshooting your postgres video, when I Start Server it says «System error 5 has occured»

   Last edited by matter17; 10-12-2018 at 01:19 AM.

   ---

2. 10-12-2018, 05:16 PM

   
   

   #2

   

   
   You’re out!
   

   

   ---

   
   

   Don’t delete anything in Postgres.

   It appears there might be an issue with PostgreSQL and reinstalling it should help resolve this.

   Make sure windows is fully updated until ‘No New Important Updates are Found’ (this may require multiple restarts and multiple ‘check for updates’), including Internet Explorer (even if you use a different web browser). This is important because it will install critical updates that affect PostgreSQL and maybe related to the issues you are seeing.

   Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database — http://hm2faq.holdemmanager.com/ques…onfigs+work%3F

   If you cannot access the database in HM2 then you can backup your database using this method: http://hm2faq.holdemmanager.com/ques…nced+Method%29 but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.

   Once you have backed up your previous database(s) then follow the instructions below to uninstall and reinstall PostgreSQL.

   1) Uninstall PostgreSQL from the Windows Control Panel.

   2) Delete the PostgreSQL8.xdata folder that is left behind.

   3) Delete the sub-folder(s) in c:usersusernameappdataroamingHoldemManagerDa tabase (XP — c:documents and settingsusernameapplication dataHoldemManagerDatabase).

   4) Restart your PC

   5) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloa…er_2_Setup.exe

   Start HM2 again and create a New Database.

   ---

3. 10-14-2018, 04:29 AM

   
   

   #3

   

   
   Junior Member
   

   ---

   
   

   I deleted Postgres but when I use the combo installer it doesn’t allow the option of installing Postgres, it says it’s already installed. Then, of course, it can’t connect to it when I try to start HM2. (because it doen’t exist obv.)

   ---

4. 10-14-2018, 10:07 PM

   
   

   #4

   

   
   You’re out!
   

   

   ---

   
   

   Make sure you do not have more installed.

   Did you delete the Postgres user?

   Did you install Postgres from their website?

   ---

5. 10-14-2018, 10:39 PM

   
   

   #5

   

   
   Junior Member
   

   ---

   
   

   I searched my computer and deleted all the postgres files found. I don’t know what the «postgres user » is. Yes, I installed from their website, but deleted that as well. Still no luck.

   ---

6. 10-15-2018, 06:14 PM

   
   

   #6

   

   
   You’re out!
   

   

   ---

   
   

   Make sure windows is fully updated until ‘No New Important Updates are Found’ (this may require multiple restarts and multiple ‘check for updates’), including Internet Explorer (even if you use a different web browser).

   Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database as a precaution in case you cannot reconnect after reinstalling PostgreSQL — http://hm2faq.holdemmanager.com/ques…onfigs+work%3F

   If you cannot access the database in HM2 then you can backup your database using this method: http://hm2faq.holdemmanager.com/ques…nced+Method%29 but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.

   1) Uninstall PostgreSQL from the Windows Control Panel.

   2) Delete the PostgreSQLX.xdata folder that is left behind.

   3) Delete the sub-folder(s) in c:usersusernameappdataroamingHoldemManagerDa tabase (XP — c:documents and settingsusernameapplication dataHoldemManagerDatabase).

   4) run the command — start > programs > accessories > command prompt > right-click > run as administrator

   net user postgres /delete

   After you click ‘Enter’ for the code above also do that same for this code:

   sc delete postgresql-8.4

   and click ‘Enter’ again.

   5) Restart your PC

   6) Install PostgreSQL 9.3 from http://www.enterprisedb.com/products…wnload#windows

   7) Once installed you should disable the postgresql logging as instructed here — http://hm2faq.holdemmanager.com/ques…arge+Log+Files

   If there is still an issue, we need to know the error — it is in the temp folder — bitrockinstaller.txt file. If you can’t see it, turn off the windows option that is hiding that directory. http://faq.holdemmanager.com/questio…es+in+Windows+

   ---

7. 10-17-2018, 09:09 PM

   
   

   #7

   

   
   Junior Member
   

   ---

   
   

   Step 4 is beyond me, and 2 other people I’ve asked. To «run the command» do I left=click the windows icon, select run, because that didn’t like «start». If I right click that icon, choose start then programs then accessories isn’t an option.

   ---

8. 10-18-2018, 06:09 AM

   
   

   #8

   

   
   You’re out!
   

   

   ---

   
   

   Where did you get stuck?

   Did you choose the way that is appropriate for your operating system?

   ---

9. 03-25-2019, 02:38 AM

   
   

   #9

   

   
   Junior Member
   

   ---

   
   

   Last edited by matter17; 03-25-2019 at 08:22 AM.

   Reason: elsewhere

   ---

10. 03-25-2019, 02:41 AM

    
    

    #10

    

    
    Junior Member
    

    ---

    
    

    Last edited by matter17; 03-25-2019 at 08:22 AM.

    ---