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 answers
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
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?
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)
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.