| 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: | Whole Thread | Raw Message | 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
| 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 |