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-1I 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
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: robertfutrelleProperties for server Local(local:.s.PGSQL.55432)
Name: Local
Host:
Port: 5432
Maintenance DB: postgres
UserName: robertfutrelleThe 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