pgAdmin shows two servers with the identical data

From: Bob Futrelle <bob(dot)futrelle(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pgAdmin shows two servers with the identical data
Date: 2013-04-28 05:04:48
Message-ID: CAOsWdXrS4rOx0B+G4orpqDzsqNA_Q8geVX6U2-pJf_ex1r88eg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2013-04-28 05:06:19 Re: Table containing only valid table names
Previous Message Jasen Betts 2013-04-28 04:49:30 Re: regex help wanted