Re: Multiple Cluster on same host

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: GMAIL <federico(dot)serale(at)gmail(dot)com>
Cc: sthomas(at)optionshouse(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Multiple Cluster on same host
Date: 2012-10-19 16:40:13
Message-ID: 5081826D.2040507@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 19/10/2012 15:38, GMAIL wrote:
> Il 19/10/2012 16:33, Shaun Thomas ha scritto:
>>
>> If you don't get any error message from the client or the server, are
>> you sure it didn't work?
>>
>> I only ask because 1.8 was so old, I'm surprised it even worked with
>> the version you had before. The catalog has changed a lot since then,
>> and the error you reported is pretty much exactly what you'd expect by
>> using an old pgAdmin with a new Postgres due to missing entries.
>>
>> You might think about deleting the pgAdmin entry and re-entering it
>> from scratch to make sure all the settings are as you expect. There
>> should be some kind of hint from the database log, too.
> if i connect with pgadmin from the host where i've created the two
> clusters it does work
> but if i connect from another pc, with pgadmin 1.16 or other software,
> to the host with postgresql i get a "connection refused" message

Is the server actually listening on any interface other than localhost?
What's in the listen_addresses entry in postgresql.conf for the cluster
on port 5433?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thalis Kalfigkopoulos 2012-10-19 17:34:14 pgwatch: installs but doesn't display anything
Previous Message Shaun Thomas 2012-10-19 16:01:33 Re: Multiple Cluster on same host