Re: On Ubuntu 12.04 i do have two psql one of those isn't working

From: Yvon Thoraval <yvon(dot)thoraval(at)gmail(dot)com>
To: rod(at)iol(dot)ie
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: On Ubuntu 12.04 i do have two psql one of those isn't working
Date: 2012-09-18 16:08:25
Message-ID: CAG6bkBzvHUM4k_pHkbh-U3tX+ObheFkY4BJ3vyY1+x+ipJvd_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2012/9/18 Raymond O'Donnell <rod(at)iol(dot)ie>

> 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.
>
>
Thanks, fine, U're right because when I attempted to change the port number
to 5432 in my postgresql.conf, when restarting the server i got that
message :
$ sudo /etc/init.d/postgresql restart
[sudo] password for yt:
* Restarting PostgreSQL 9.1 database server

* Error: Port conflict: another instance is already running on
/var/run/postgresql with port 5432

Quite frankly i don't know where this first postgresl come from...
That make me loose a lot of time for "nothing"...

--
Yvon

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2012-09-18 16:11:26 Re: Time-based trigger
Previous Message Szymon Guz 2012-09-18 16:03:22 Re: Time-based trigger