Re: pgAdmin shows two servers with the identical data

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pgAdmin shows two servers with the identical data
Date: 2013-04-28 05:57:58
Message-ID: klidp6$ot0$1@gonzo.reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2013-04-28, Bob Futrelle <bob(dot)futrelle(at)gmail(dot)com> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Lawrence Barwick 2013-04-28 06:22:27 Re: pgAdmin shows two servers with the identical data
Previous Message Jasen Betts 2013-04-28 05:06:19 Re: Table containing only valid table names