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