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