pgAdmin III shows duplicate connection to same server
My pgAdmin suddenly shows two connections to the very same server (localhost).
I can't remember what particular actions I did the last time before opening the software today.
Both servers contain the same databases and login roles.
Q:
- Why does this happen?
- Is it safe to just delete / drop either one?
Windows Services shows only one PostgreSQL Server service running:
pgAdmin III version is: 1.22.2 (May 9 2017,rev:REL-1_22_1)
PostgreSQL version is: 9.5.7
OS version is: Windows 10 Pro 1803 build 17134.48
Don't know what additional info I should provide, so please feel free to ask.
pgAdmin is just a client to view your postgresql server details. You can add as many servers as you want in pgAdmin (because they are not server instances it is just UI interface to access data easily, they call it server because you are connecting to server through it) but ultimately they would be connected to only one server.
Why does this happen?
It might have happened that you have created a duplicate connection to it as you can't remember what particular actions you did the last time before opening the software today.
Is it safe to just delete / drop either one?
Feel free to delete it from pgAdmin as it will just be that interface is
deleted, your data is perfectly safe.
Hope this helps !
- Rails 4 scope NOTNULL refactor
- Select on self-referencing table where all chains meet a condition
- In a join, fields with null values are not getting shown but in normal query they are
- Install pgAgent on AWS RDS for Postgres
- Spring JBDC bad SQL grammar on PostgreSQL
- Using IF in function for different queries as a result
- Variables in looping condition in a postgreSQL while loop
- SQL query for returning rows with only certain values in list but not others?
- How to insert data into a code-first database with a SQL script?
- How do I insert a record into a Postgres DB based off the MAX of one column?
- Pyspark JDBC read with partitions
- Quarkus dev postgresql container not shutting down with quarkus
- Permission issue with PostgreSQL in docker container
- Starting application development using Docker or configuring Docker during development?
- Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
- postgresql - replace all instances of a string within text field
- migrate data from MS SQL to PostgreSQL?
- How to change the select output delimeter from '|' to ',' on Postgres through command line?
- Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?
- Psycopg2: how to deal with special characters in password?
- SET CONSTRAINTS ALL DEFERRED not working as expected
- Postgres container doesn't start
- How do you find the row count for all your tables in Postgres
- Alter column ignoring dependent views
- Recursive CTE 'Query Error: relation [] does not exist', PostgreSQL v17
- How to view Oldest Query results in Azure Monitor Metrics for an Azure PostgreSQL Flex Server instance
- Insert literal '${value}' without variable substitution into PostgreSQL table from DBeaver
- How should I set my DATABASE_URL?
- How can I use composite primary keys in django?
- How to switch databases in psql?