Re: On Ubuntu 12.04 i do have two psql one of those isn't working - Mailing list pgsql-general

From Jasen Betts
Subject Re: On Ubuntu 12.04 i do have two psql one of those isn't working
Date
Msg-id k3jij2$fkc$1@reversiblemaps.ath.cx
Whole thread Raw
In response to On Ubuntu 12.04 i do have two psql one of those isn't working  (Yvon Thoraval <yvon.thoraval@gmail.com>)
List pgsql-general
On 2012-09-18, Raymond O'Donnell <rod@iol.ie> wrote:
> On 18/09/2012 16:10, Yvon Thoraval wrote:
>> I've found the prob.
>> In my postgresql.conf file the default port is setup to 5433 instead of
>> 5432 as previously...
>
> OK - you probably had two versions of PG installed at some point - when
> you install a second version of PG alongside an existing one on Debian &
> Ubuntu, it automatically puts it on 5433.

Debian's pg_upgradecluster will leave you with the new cluster running
on 5433. (it's not pg_upgrade, it's some sort of script)


⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Question about permissions on database.
Next
From: Jasen Betts
Date:
Subject: Re: RFE: Column aliases in WHERE clauses