I have installed Postgres(11) on Azure, I am connecting to it using Datagrip client, The problem is it disconnects very frequently and connects back when I run some query, takes nearly 5 seconds to connect back. Here I am attaching a picture of AdvancedSettings which I have tried already but this doesn't seem to work, can you please suggest a solution so this stays connected for more than 10 mins at least.
Remote postgres database disconnects frequently on azure
617 Views Asked by bharat At
1
There are 1 best solutions below
Related Questions in POSTGRESQL
- Only the first SQL script gets executed inside Docker Postgres container
- Compare fields in two tables
- Hibernate ClobJdbcType bindings: what are the diferences?
- Postgres && statement Error in Mybatis Mapper?
- Can this query be optimized? (Choosing a random row to insert, that excludes previously inserted Rows)
- Connection terminated unexpectedly while performing multi row insert using pg-promise
- Processing multiple forms in nodejs and postgresql
- How to copy data from SQLite to postgreSQL?
- PGAdmin4 configured behind a reverse proxy but unable to connect to Postgresql server
- Updates to pgsodium encrypted values don't use specified key_id
- Connecting to Postgres running in a Docker container using psql
- Can't connect to local postgresql server from my docker container
- Django Arrayfield migration to cloud sql (Postgresql) not creating the column
- Get list of matching keywords for each post
- docker-compose can't reset postgresql database
Related Questions in AZURE
- How to update to the latest external Git in Azure Web App?
- I need an azure product that executes my intensive ffmpeg command then dies, and i only get charged for the delta. Any Tips?
- Inject AsyncCollector into a service
- mutual tls authentication between app service and function app
- Azure Application Insights Not Displaying Custom Logs for Azure Functions with .NET 8
- Application settings for production deployment slot in Azure App Services
- Encountered an error (ServiceUnavailable) from host runtime on Azure Function App
- Implementing Incremental consent when using both application and delegated permissions
- Invalid format for email address in WordPress on Azure app service
- Producer Batching Service Bus Vs Kafka
- Integrating Angular External IP with ClusterIP of .NET microservices on AKS
- Difficulty creating a data pipeline with Fabric Datafactory using REST
- Azure Batch for Excel VBA
- How to authenticate only Local and Guest users in Azure AD B2C and add custom claims in token?
- Azure Scale Sets and Parallel Jobs
Related Questions in REMOTE-SERVER
- Deploying a Spring Boot and Angular application on XAMPP on a different server
- Using Jsch for file transfer from remote to local but file getting deleted on getting input stream
- Connect to Remote servers using SSH failed on Windows 11
- Error in opening a application through command prompt when the application is deployed to remote site
- code doesn't work in PyCharm, but work in remote executing
- How to import from py file when running jupyter notebook on a remote server
- Why can I no longer access an external API when I log out of the remote session?
- Running Remote SSH not exiting
- VSCode Devcontainers Port forwarding doesn't work properly on remote server
- Attach Visual Studio Code to docker Container not working
- VScode/WSL: Could not fetch remote environment & Failed to connect to the remote extension host server(Error:WebSocket Close with status code 1006)
- Modifying an Environment Variable remotely with Powershell
- Why do I not get the same result when I run a TAIL command from console of a remote server as when I run the same command from a script on local svr?
- Ubuntu Server Remote Access - Without Port Forwarding or VPN
- Explorer and Source Control don't refresh automatically when working on remote directory
Related Questions in DATAGRIP
- How to connect remote postgresql database with datagrip by ssh tunnel?
- Error trying to use 'restore with MySql' on DataGrip
- Datagrip expand column list to new line with comma at beginning
- Does DataGrip Support Postgres Authentication with Kerberos?
- PhpStorm: database host not accessible when in docker
- DataGrip - show full table name in tabs and elsewhere
- Connect to SQL Server using Datagrip on Windows 11
- How Can I Make URLs Clickable in a Table Column in DataGrip?
- Spanner Update in Datagrip: INVALID_ARGUMENT: Value of type NUMERIC cannot be assigned to t.quantity, which has type INT64
- Datagrip automatically execute query from sql file when the file is changed
- How to set the settings in DataGrip SQL code style editor so that the join conditions are on separate lines?
- Fixed the timezone issue from nextJS API fetching from aws redshift
- Can't Connect to my rds instance through datagrip
- How to make DataGrip default to using Manual transactions?
- Transaction across changes in multiple tables
Related Questions in DATABASE-CONNECTIVITY
- How to store data (real time) get from the energy meter to SQL Server database (to get data I use modscan software)
- import mysql.connector, ModuleNotFoundError: No module named 'mysql'
- I am currently practicing Spring Boot with Mysql database and after running application getting this error for employeeRepository
- Java Database Exceptional error that is very unique
- How to resolve the below error while running a c program to connect to Ms SQL server from Linux fedora7 using mssqlodbc
- Spring Boot error with multiple data-sources :: dataSource or dataSourceClassName or jdbcUrl is required
- In my flutter app when I turn off my internet it crashes with some exception. It does not work even after internet is turned on
- Connect Azure SQL database with on prem Tableau server
- Is it possible to avoid warning when using LOAD DATA LOCAL INFILE to import duplicates
- How come I'm getting authenticate error, but when I login via the app, I am able to log in
- Error in Connecting Visual Studio 2019 with Oracle 19c
- The method 'getUsers' was called on null. Receiver: null Tried calling: getUsers()
- Can a Java application connect directly to EnterpriseDB Advanced Server?
- can we take user input using python for mysql table values?
- Pyodbc is only accepting windows authentication
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The solution depends on who closes the connection.
If the connection is closed by the benighted Azure configuration, configure DataGrip so that it sends keepalive packets:
If the connection is closed by DataGrip, tell it not to do that:
On the Options tab, deselect the Auto-disconnect after N seconds checkbox.