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

2012-09-22 Thread Jasen Betts
On 2012-09-18, Raymond O'Donnell 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

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

2012-09-18 Thread Yvon Thoraval
I've found the prob. In my postgresql.conf file the default port is setup to 5433 instead of 5432 as previously... sorry for the noise.

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

2012-09-18 Thread Yvon Thoraval
2012/9/18 Raymond O'Donnell > 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

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

2012-09-18 Thread Raymond O'Donnell
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

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

2012-09-17 Thread Raymond O'Donnell
On 17/09/2012 12:52, Yvon Thoraval wrote: > > then, the php link to the client library is faulty. What makes you think this? Can you show the output from a PHP script (not psql)? - something simple like... $conn = pg_connect(); $rs = pg_query(); ...just to establish whether the connect

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

2012-09-17 Thread Yvon Thoraval
2012/9/17 Raymond O'Donnell > > The first isn't a "real" psql - it's a symlink to pg_wrapper, which is > how Debian and Ubuntu allow you to run different Postgres versions and > clusters on the same machine. You call the client program (psql, > pg_dump, etc) you want as usual, but pass it the --c

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

2012-09-17 Thread Raymond O'Donnell
On 17/09/2012 07:15, Yvon Thoraval wrote: > > I'm testing my second PostgreSQL install on Xunutu 12.04 after a disk crash. > > Everything went well using command line where i was able, after config > and setup, to log into a db using : > $ psql -U yt -d yt_tests > > Then i wanted to test postgr

[GENERAL] On Ubuntu 12.04 i do have two psql one of those isn't working

2012-09-16 Thread Yvon Thoraval
I'm testing my second PostgreSQL install on Xunutu 12.04 after a disk crash. Everything went well using command line where i was able, after config and setup, to log into a db using : $ psql -U yt -d yt_tests Then i wanted to test postgres thru php where i got Http error 500. After that i disco