Re: [GENERAL] pgAdmin shows two servers with the identical data
013/4/28 Bob Futrelle : > 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
Re: [GENERAL] pgAdmin shows two servers with the identical data
On 2013-04-28, Bob Futrelle 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
[GENERAL] 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