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

[Yvon Thoraval <yvon.thoraval@xxxxxxxxx>]

2012/9/18 Raymond O'Donnell <rod@xxxxxx>

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