Обсуждение: After upgrade from 8.3 to 8.4 in OS X the same server is appearing twice

I recently upgraded my postgresql installation from 8.3 to 8.4 with fink on
OS X. I did this by blowing away everything and doing a clean install.

Now when I run pgadmin is see two servers one called "PostgreSQL 8.3
(localhost:5432)" and the other is "PostgreSQL 8.4 (local:.s.PGSQL.5432)"
but both have the same version string property and identify themselves as
8.4 and both connect to the same databases.

What have I done wrong and why does one insist on calling itself 8.3?

"PostgreSQL 8.3 (localhost:5432)"
=====================
Description    PostgreSQL 8.3    
Hostname    localhost    
Port    5432    
Encryption    not encrypted    
Maintenance database    postgres    
Username    postgres    
Store password?    No    
Restore environment?    No    
Version string    PostgreSQL 8.4.8 on i386-apple-darwin10.7.0, compiled by GCC
i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5666) (dot 3),
64-bit    
Version number    8.4    
Last system OID    11563    
Connected?    Yes    
Up since    07/08/2011 16:32:46    
Configuration loaded since    07/08/2011 16:32:45    
Autovacuum    running    

"PostgreSQL 8.4 (local:.s.PGSQL.5432)"
========================
Description    Postgres 8.4    
Hostname    local:    
Port    5432    
Maintenance database    postgres    
Username    postgres    
Store password?    Yes    
Restore environment?    Yes    
Version string    PostgreSQL 8.4.8 on i386-apple-darwin10.7.0, compiled by GCC
i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5666) (dot 3),
64-bit    
Version number    8.4    
Last system OID    11563    
Connected?    Yes    
Up since    07/08/2011 16:32:46    
Configuration loaded since    07/08/2011 16:32:45    
Autovacuum    running    


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/After-upgrade-from-8-3-to-8-4-in-OS-X-the-same-server-is-appearing-twice-tp4565236p4565236.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

On Fri, Jul 8, 2011 at 4:45 PM, Peter Hickman <peter@abelsoninfo.com> wrote:
> I recently upgraded my postgresql installation from 8.3 to 8.4 with fink on
> OS X. I did this by blowing away everything and doing a clean install.
>
> Now when I run pgadmin is see two servers one called "PostgreSQL 8.3
> (localhost:5432)" and the other is "PostgreSQL 8.4 (local:.s.PGSQL.5432)"
> but both have the same version string property and identify themselves as
> 8.4 and both connect to the same databases.
>
> What have I done wrong and why does one insist on calling itself 8.3?

On Mac, pgAdmin will only auto-add servers that are registered in
/etc/postgres-reg.ini. As far as I know, only the EDB installers do
this, and as you're using Fink obviously the server shouldn't be
auto-added, leading to a minor mystery.

If I had to guess, I'd say your 8.3 installation was from the EDB
installer, and you didn't use the uninstaller to remove it, so pgAdmin
thinks it's still there. If that seems right, just delete the
appropriate lines in /etc/postgres-reg.ini, then delete the unwanted
server in pgAdmin.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company