getting error connection error 08006 or Error: No such host is known
Hi, We got an error on and off as "connection error 08006" or "Error: No such host is known" when we try to run some report . But if we re-run the same report again, then no error will be shown. Do you have an idea what causing the issue? below is a sample
Will dbForge for Postgresql filter out comments when submitting queries?
Will dbForge for Postgresql filter out comments when submitting queries? If filtering is applied, it is recommended not to do so, as certain features of Alibaba Cloud Polardb may become completely ineffective. pg_hint_plan - PolarDB - Alibaba Cloud Documentation
memory leak
memory leak problem is very serious,memory uses will continue grow to several GB level.
Suggestions for optimizing the log output function
1、SQL1.sql truncate aaa; truncate bbb; truncate ccc; truncate ddd; truncate eee; truncate fff; truncate ggg; truncate hhh; truncate iii; truncate jjj; truncate kkk; truncate lll; truncate mmm; truncate nnn; truncate ooo; 2、SQL2.sql truncate aaa; truncate
create new database,user
Hello, i download dBforge studio for postgres and try to create database, table or user but there is no option for that as Mysql tool. so i missed something or it is limitation in this product? if it is limitation, are you going to develop it so that
Feature Suggestions : Schema Filter
Feature Suggestions : add a "Schema Filter" function like "Table Filter"
Feature Suggestions for dbForge Studio for PostgreSQL
1、Allow schema switching within the query interface. 2、Add an option to generate a complete CREATE script for the current database via right-click context menu on the database node. 3、Introduce batch filter configuration in data comparison (e.g., apply
Feature Suggestions for dbForge Studio for PostgreSQL
Here are a few suggestions: 1. Add multi-language support. 2. Add a "Generate CREATE Script" option when right-clicking on a schema (similar to public) or a database, which can generate the CREATE script for the entire schema (similar to public) or the
Schema Compare for Postgresql: Triggers comparison
Hello Where can I find an exhaustive list of what schema objects are currently supported and not supported when doing a schema comparison using dbForge for PostgreSQL? I was under the impression triggers are supported by this does not seem to be the
Compare to schema inside same database
Hi, I started to evaluate DbForge Studio for PostgreSQL. I wan't to compare schemas inside database. (I mean those schemas which are created by CREATE SCHEMA myschema); our use case is for example a franchising chain, where all companies are under same
Schema compare for PostgreSQL free and commercial editions (dbForge Studio for PostgreSQL)
Is there any difference between Schema compare for PostgreSQL free and commercial editions (dbForge Studio for PostgreSQL)?
Schema compare for PostgreSQL 1.4.839
Very good tool with minor exceptions. For now I miss compare for triggers and indexes. Didn't test partitioning yet (is this working).
Error connecting from Schema Compare 1.4.839 to PostgreSQL 14 using Pritunl
I'm trying to connect to PostgreSQL 14 from Schema Compare 1.4.839 using Pritunl (VPN client). So I have many network adapters / IP addresses on my laptop. When I'm trying to connect to PostgreSQL server with Pritunl is on, I get an error: no pg_hba.conf
How to delete a Db in dbForge Studio for Postgres
How can I delete a database in dbForge Studio for Postgres (without running a command) I don't see such an option when I right click database
Data Export - All Floats Become "General"
I'm using dbForget Studio for PostgreSQL Professional Edition v. 3.1.618. When I use the data export tool, all floating point numbers in all output formats simply become the word "General" - no numbers; just the word. Anyone see that before? I tried restarting
Can't Set the Text Color
Hi. I just reinstalled dbForge Studio on a new machine without backing up my old settings. I had the Visual Studio Dark skin before with readable white colored text in the code editor. Now that I have installed this slightly newer version on my new machine
Amazon Redshift ENCODE issue
Redshift tables DDL generation Note: ENCODE encoding The compression encoding for a column. ENCODE AUTO is the default for tables. Amazon Redshift automatically manages compression encoding for all columns in the table. If you specify compression encoding
Data Generation Wizard only lists tables from one schema
Using dbForge for Postgre SQL (version 3.1.701) I connect to a simple test database. The DB happens to be in google cloud as a CloudSQL Postgres. The db has tables in 3 schemas (public, immutable, version3). I fire up the data generation wizard. After
execute procedure via dbforge studio give error cursor does not exist.
While executing the procedure via dbforge studio, it gives an error: Cursor <cursor_name> does not exist. But the same code runs in pgadmin, and it's working fine. call ea.usp_procedure_name(parm_1,parm_2,'ref_result_data1'); fetch all FROM ref_resu
Is there a way to extract whole postgres schema without the data ?
Hello I am looking for a solution to extract all my postgres schema to a file. DDL format would be nice. Thank you for help!
How to use Kerberos auth
I've got an Aurora postgres database set up to use Kerberos authentication. How can I configure dbForge to connect with Kerberos?
Error while running schema comparison (PostgreSQL)
Hello! The same error exists in dbForge Schema Compare for PostgreSQL and in the dbForge Studio. As I can see these both tools using the same files: Devart.DbForge.DbObjects.dll Devart.DbForge.DbObjects.PostgreSql.dll I have sent Error Report yesterday.
Exception when generating diff report for PostgreSQL from command line
Evaluating schema compare tool using PostgreSQL 14.7 local databases. Can successfully generate HTML report from User interface, but same process is failing when generating via command line. We want to plug this into our build server pipeline, so command
Importing CSV with french boolean
Hi, I'm testing dbForge studio for PosgreSQL. I'm trying to impot CSV file with french boolean value in a column ('VRAI', 'FAUX')... but it fails How can I handle that ? (PS : I cannot change the source CSV file)
Cannot connect to Amazon Redshift
We have been evaluating the dbForge studio as a solution for maintaining the databases and schemas in our DWH, which is Amazon Redshift. According to documentation, dbForge studio for Postgres should be able to connect to Redshift (as Redshift is postgres-based),
Question/Problem dbForge keeps asking for an old connection when opening .sql file
In the past I have used another connection to work with dbForge. The connection has changed, I removed the old one from the database explorer and even when I'm using the new one, when opening a .sql file it keeps asking for the old one and I have to manually
How to make a Order and Order Items report
I have two tables: Orders: OrderID Name Address etc. Order Items: Item ID Item Name Qty etc. How do I make a report that shows the Order and then all the Items on the Order? In the Detail Band, I can only see one record, not all the records in the Order.
STRING_TO_ARRAY
i'm getting an "error" while trying to format a document SQL1.sql: Error (6,5): Unexpected symbol 'STRING_TO_ARRAY'
dbForge for PostgreSQL
Discussion of open issues, suggestions and bugs regarding database management and administration tools for PostgreSQL
Popular Articles
How to Download and Install a Previous Version of the Product
If you need to download and install an earlier version of a product, other than the latest release available on the website, follow these steps: Uninstall the Newer Version: To install a previous version available under your license, you must first ...
How to Connect to MySQL Server
In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...
How to Automatically Create a Dump File on Crash for Studios, Standalone Tools, and MiniTools
If a crash occurs, you can configure the system to automatically create a dump file for debugging purposes. Follow the steps below to create the required registry keys for different products, such as dbForge Studio, Standalone Tools, and MiniTools. ...
Cannot Open Table ‘Case’ and ‘Order’ in SSMS with ODBC Driver for Salesforce
When working with SQL Server Management Studio (SSMS) and the Devart ODBC Driver for Salesforce, you may encounter difficulties accessing certain tables such as Case or Order. Important Note on SSMS Behavior Queries in SSMS are first processed by SQL ...
How to Activate a Trial Version in dbForge Products
Starting from release 2025.1, the method of using the trial version and Express Edition has been updated for all paid dbForge products. To help you get started smoothly, please follow the step-by-step instructions below. As of version 2025.1, ...