Thread: pgAdmin shows two servers with the identical data
I have two PG servers with the same data.
I know the data is the same, because if I change a value in a table
on one server, it changes the value in a table with the same
name in the other server.
in pgAdmin III:
Properties for server Local (localhost:5432):
Name: Local
Host: localhost
Port: 5432
Maintenance DB: postgres
UserName: robertfutrelle
Properties for server Local(local:.s.PGSQL.55432)
Name: Local
Host:
Port: 5432
Maintenance DB: postgres
UserName: robertfutrelle
The second one is odd - no Host is listed.
What is going on?
Since they appear to be identical in most all respects, would be nice
to remove one of them. Is that safe? If so, which?
All the above in Mac Mountain Lion OS. All my PG work is being done
entirely locally, on my MacBook. I intend to work in that mode for at least
the next two years.
My son suggested I move to PostgreSQL. I started with it late last year
and have never looked back. PG is definitely one cool DB system.
Thanks guys.
My data is 120,000 biology papers, HTML, and a great deal of secondary data
I generate from them.
- Bob Futrelle
On 2013-04-28, Bob Futrelle <bob.futrelle@gmail.com> wrote: > --001a11c2f448244d3504db64b5d7 > Content-Type: text/plain; charset=ISO-8859-1 > > I have two PG servers with the same data. > > I know the data is the same, because if I change a value in a table > > on one server, it changes the value in a table with the same > > name in the other server. > > in pgAdmin III: > > > Properties for server Local (localhost:5432): > > Name: Local > > Host: localhost > > Port: 5432 > > Maintenance DB: postgres > > UserName: robertfutrelle that's a TCP/IP socket connection > Properties for server Local(local:.s.PGSQL.55432) > > Name: Local > > Host: > > Port: 5432 > > Maintenance DB: postgres > > UserName: robertfutrelle that's a unix domain socket connection to the same datavase, -- ⚂⚃ 100% natural
013/4/28 Bob Futrelle <bob.futrelle@gmail.com>: > I have two PG servers with the same data. > > I know the data is the same, because if I change a value in a table > on one server, it changes the value in a table with the same > name in the other server. > > in pgAdmin III: > > Properties for server Local (localhost:5432): > > Name: Local > Host: localhost > Port: 5432 > Maintenance DB: postgres > UserName: robertfutrelle > > > Properties for server Local(local:.s.PGSQL.55432) > > Name: Local > Host: > Port: 5432 > Maintenance DB: postgres > UserName: robertfutrelle > > The second one is odd - no Host is listed. > > What is going on? > > Since they appear to be identical in most all respects, would be nice > to remove one of them. Is that safe? If so, which? They are one and the same database, accessed via different methods: TCP/IP in the first case, Unix-domain sockets in the second case (hence the lack of host). Nothing to worry about, and you only have one copy of the database. Though it's for the command line client psql, the same principles described here apply: http://www.postgresql.org/docs/current/static/app-psql.html#R2-APP-PSQL-CONNECTING Regards Ian Barwick