Re: [GENERAL] pgAdmin shows two servers with the identical data

2013-04-28 Thread Jasen Betts 
On 2013-04-28, Bob Futrelle bob.futre...@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



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgAdmin shows two servers with the identical data

2013-04-28 Thread Ian Lawrence Barwick 
013/4/28 Bob Futrelle bob.futre...@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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general