Amazon Redshift Error: database "postgress" does not found

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
dburtsev
Posts: 8
Joined: Wed 18 Jan 2017 19:57

Amazon Redshift Error: database "postgress" does not found

Post by dburtsev » Tue 13 Aug 2019 14:30

Express Edition 2.1.97
=========================
General
=========================
Application: dbForge Studio 2019 for PostgreSQL
Product: Devart dbForge Studio 2019 for PostgreSQL
Product Edition: Express
Product Locale: English
Trial Info: Activated
HardwareID: D8EA-03FC-282D-68E9-DD00
Assembly: dbforgepostgresql, Version=2.1.97.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\dbForge Studio for PostgreSQL\dbforgepostgresql.exe
Global cache: False
Framework: 4.6.2 or later
=========================
Window Layout
=========================
No active document window
Active window: 'Database Explorer'
No documents

Toolwindows (visible or have been shown in current session):
Caption: 'Database Explorer', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Error List', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Output', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Properties', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Start Page', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Tabbed

=========================
Connections
=========================
opencontracts.mocsdata.cluster-cc0hirzntjdw.us-east-1.rds.amazonaws.com - 'User Id=dburtsev;Host=mocsdata.cluster-cc0hirzntjdw.us-east-1.rds.amazonaws.com;Database=opencontracts;Unicode=True;Integrated Security=False'
redmocs.cbzkr8tp4hxq.us-east-1.redshift.amazonaws.com:5439 (current) - 'User Id=mocsdw;Host=redmocs.cbzkr8tp4hxq.us-east-1.redshift.amazonaws.com;Port=5439;Unicode=True;Connection Timeout=15;Default Command Timeout=30;Integrated Security=False'

=========================
Execution History
=========================
Store queries: True
Store period : 60 (days)
Available period : 60 (days)
Folder: %appdata%\Devart\dbForge Studio for PostgreSQL\ExecutedQueries
Max script size: 1024 (KB)
Initial interval: Week
History folder content:
C:\Users\dburtsev\AppData\Roaming\Devart\dbForge Studio for PostgreSQL\ExecutedQueries\ExecutedQueries.db (32768 B)

=========================
Loaded Assemblies
=========================
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Accessibility\v4.0_4.0.0.0__b03f5f7f11d50a3a
Accessibility.dll
Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\Program Files\Devart\dbForge Studio for PostgreSQL
Autofac.dll
Autofac, Version=4.2.1.0, Culture=neutral, PublicKeyToken=09af7300eec23701
dbforgepostgresql.exe
dbforgepostgresql, Version=2.1.97.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Antlr3.Runtime.dll
Devart.Antlr3.Runtime, Version=1.0.10.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Ad.dll
Devart.DbForge.Ad, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Common.PostgreSql.dll
Devart.DbForge.Common.PostgreSql, Version=2.1.97.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.CommonServices.dll
Devart.DbForge.CommonServices, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Compare.dll
Devart.DbForge.Compare, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Data.Interfaces.dll
Devart.DbForge.Data.Interfaces, Version=5.0.21.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Data.PostgreSql.dll
Devart.DbForge.Data.PostgreSql, Version=6.1.117.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DataEditor.dll
Devart.DbForge.DataEditor, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DataExportImport.dll
Devart.DbForge.DataExportImport, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DbObjectControllers.dll
Devart.DbForge.DbObjectControllers, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DbObjectModels.PostgreSql.dll
Devart.DbForge.DbObjectModels.PostgreSql, Version=2.1.97.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DbObjects.dll
Devart.DbForge.DbObjects, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DbObjects.PostgreSql.dll
Devart.DbForge.DbObjects.PostgreSql, Version=2.1.97.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DbObjectsUI.dll
Devart.DbForge.DbObjectsUI, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DbObjectsUI.PostgreSql.dll
Devart.DbForge.DbObjectsUI.PostgreSql, Version=2.1.97.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DeclarationRepository.dll
Devart.DbForge.DeclarationRepository, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.ExecutionHistory.dll
Devart.DbForge.ExecutionHistory, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Interfaces.dll
Devart.DbForge.Interfaces, Version=4.0.84.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.LanguageService.dll
Devart.DbForge.LanguageService, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.LanguageService.PostgreSql.dll
Devart.DbForge.LanguageService.PostgreSql, Version=2.1.97.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.ObjectExplorer.dll
Devart.DbForge.ObjectExplorer, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.PostgreSql.dll
Devart.DbForge.PostgreSql, Version=2.1.97.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Provider.dll
Devart.DbForge.Provider, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Resources.dll
Devart.DbForge.Resources, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Resources.PostgreSql.dll
Devart.DbForge.Resources.PostgreSql, Version=2.1.97.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.SchemaTools.dll
Devart.DbForge.SchemaTools, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.SchemaTools.PostgreSql.dll
Devart.DbForge.SchemaTools.PostgreSql, Version=2.1.97.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.SqlComplete.dll
Devart.DbForge.SqlComplete, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.SqlComplete.PostgreSql.dll
Devart.DbForge.SqlComplete.PostgreSql, Version=2.1.97.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.TextComparer.dll
Devart.DbForge.TextComparer, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.UI.dll
Devart.DbForge.UI, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Utils.dll
Devart.DbForge.Utils, Version=6.1.1547.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Shell.Core.dll
Devart.Shell.Core, Version=2.1.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Shell.Resources.dll
Devart.Shell.Resources, Version=2.1.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Shell.Studio.dll
Devart.Shell.Studio, Version=2.1.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Shell.UI.dll
Devart.Shell.UI, Version=2.1.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Data.v18.1.dll
DevExpress.Data.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Mvvm.v18.1.dll
DevExpress.Mvvm.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Printing.v18.1.Core.dll
DevExpress.Printing.v18.1.Core, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Utils.v18.1.dll
DevExpress.Utils.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Xpf.Core.v18.1.dll
DevExpress.Xpf.Core.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Xpf.Themes.VS2017Dark.v18.1.dll
DevExpress.Xpf.Themes.VS2017Dark.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.XtraBars.v18.1.dll
DevExpress.XtraBars.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.XtraEditors.v18.1.dll
DevExpress.XtraEditors.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.XtraGrid.v18.1.dll
DevExpress.XtraGrid.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.XtraLayout.v18.1.dll
DevExpress.XtraLayout.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.XtraVerticalGrid.v18.1.dll
DevExpress.XtraVerticalGrid.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Ionic.Zip.dll
Ionic.Zip, Version=1.9.1.8, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c
LiteDB.dll
LiteDB, Version=3.1.4.0, Culture=neutral, PublicKeyToken=4ee40123013c9f27
Newtonsoft.Json.dll
Newtonsoft.Json, Version=11.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed
C:\Windows\Microsoft.NET\Framework64\v4.0.30319
mscorlib.dll
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_64\PresentationCore\v4.0_4.0.0.0__31bf3856ad364e35
PresentationCore.dll
PresentationCore, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework\v4.0_4.0.0.0__31bf3856ad364e35
PresentationFramework.dll
PresentationFramework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework.Aero2\v4.0_4.0.0.0__31bf3856ad364e35
PresentationFramework.Aero2.dll
PresentationFramework.Aero2, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework-SystemData\v4.0_4.0.0.0__b77a5c561934e089
PresentationFramework-SystemData.dll
PresentationFramework-SystemData, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework-SystemXml\v4.0_4.0.0.0__b77a5c561934e089
PresentationFramework-SystemXml.dll
PresentationFramework-SystemXml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\SMDiagnostics\v4.0_4.0.0.0__b77a5c561934e089
SMDiagnostics.dll
SMDiagnostics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089
System.dll
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ComponentModel.Composition\v4.0_4.0.0.0__b77a5c561934e089
System.ComponentModel.Composition.dll
System.ComponentModel.Composition, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ComponentModel.DataAnnotations\v4.0_4.0.0.0__31bf3856ad364e35
System.ComponentModel.DataAnnotations.dll
System.ComponentModel.DataAnnotations, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a
System.Configuration.dll
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089
System.Core.dll
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_64\System.Data\v4.0_4.0.0.0__b77a5c561934e089
System.Data.dll
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.Linq\v4.0_4.0.0.0__b77a5c561934e089
System.Data.Linq.dll
System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a
System.Drawing.dll
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Management\v4.0_4.0.0.0__b03f5f7f11d50a3a
System.Management.dll
System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Net.Http\v4.0_4.0.0.0__b03f5f7f11d50a3a
System.Net.Http.dll
System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Numerics\v4.0_4.0.0.0__b77a5c561934e089
System.Numerics.dll
System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089
System.Runtime.Serialization.dll
System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel\v4.0_4.0.0.0__b77a5c561934e089
System.ServiceModel.dll
System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Internals\v4.0_4.0.0.0__31bf3856ad364e35
System.ServiceModel.Internals.dll
System.ServiceModel.Internals, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089
System.Windows.Forms.dll
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xaml\v4.0_4.0.0.0__b77a5c561934e089
System.Xaml.dll
System.Xaml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089
System.Xml.dll
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\UIAutomationClient\v4.0_4.0.0.0__31bf3856ad364e35
UIAutomationClient.dll
UIAutomationClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\UIAutomationTypes\v4.0_4.0.0.0__31bf3856ad364e35
UIAutomationTypes.dll
UIAutomationTypes, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\WindowsBase\v4.0_4.0.0.0__31bf3856ad364e35
WindowsBase.dll
WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\WindowsFormsIntegration\v4.0_4.0.0.0__31bf3856ad364e35
WindowsFormsIntegration.dll
WindowsFormsIntegration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35

Dynamic Assemblies :
C:\Windows\Microsoft.Net\assembly\GAC_64\mscorlib\v4.0_4.0.0.0__b77a5c561934e089
mscorlib.dll
Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null
C:\Program%20Files\Devart\dbForge%20Studio%20for%20PostgreSQL
Devart.Shell.Core.dll
Devart.BrowseObjects, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null
DevExpress.Xpf.Core.v18.1.dll
ReflectionHelperTypesPublicWrappers, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089
System.Xml.dll
Microsoft.GeneratedCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null

=========================
Thread Information
=========================
Name:
Priority: Normal
ThreadState: Running
CurrentCulture:
ApartmentState: STA
IsThreadPoolThread: False
IsAlive: True
IsBackground: False

=========================
System Information
=========================
Processor architecture: amd64
Processor quantity: 4
Intel(R) Xeon(R) Platinum 8175M CPU @ 2.50GHz Intel64 Family 6 Model 85 Stepping 4
Intel(R) Xeon(R) Platinum 8175M CPU @ 2.50GHz Intel64 Family 6 Model 85 Stepping 4
Intel(R) Xeon(R) Platinum 8175M CPU @ 2.50GHz Intel64 Family 6 Model 85 Stepping 4
Intel(R) Xeon(R) Platinum 8175M CPU @ 2.50GHz Intel64 Family 6 Model 85 Stepping 4

Total physical memory: 16195Mb
Total available paginal memory: 13620Mb
Process available virtual memory: 134216687Mb
Process private memory size: 169Mb
Display1: 1920x1080, 100% DPI

Operating System Name: Windows Server 2016 Datacenter
Operating System Version: Microsoft Windows NT 10.0.14393.0
UAC status: Enabled
UAC level: Notify when app try to make changes
Is user in admin group: True
Is run as admin: False
Is process elevated: False
Elevation type: Limited
Integrity level: Medium

Instances: 2
Culture: English (United States)
Process started at 08/13/2019 10:25:21
Report created at 08/13/2019 10:30:18

alexa

Re: Amazon Redshift Error: database "postgress" does not found

Post by alexa » Tue 13 Aug 2019 18:38

Please try specifying a database in the 'Database' drop-down menu on the 'General' tab of the Database Connection Properties dialog box (right-click the connection in Database Explorer and select 'Modify Connection...' from the popup menu).

dburtsev
Posts: 8
Joined: Wed 18 Jan 2017 19:57

Re: Amazon Redshift Error: database "postgress" does not found

Post by dburtsev » Thu 15 Aug 2019 17:38

It works. Thank you.

alexa

Re: Amazon Redshift Error: database "postgress" does not found

Post by alexa » Mon 19 Aug 2019 09:32

Thank you for updating us on this issue.

Please let us know if any questions arise.

Post Reply