[postgis-users] What have I got wrong?
Hi all, Apologies to everyone if this has already been documented before or if my problem is so obvious but.. After trying for the best part of three days I'm unable (unsure what the heck I'm doing wrong) with trying to get postgis working with postgres. If anyone can point out what it is I be hugely grateful. I've followed the official postgis installation documentation and guides / tutorials on the PostGIS WIKI and keep arriving at the same message below in a terminal window. createdb: could not connect to database postgres: could not connect to server: No such file or directoryIs the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5433"? If it helps I'm running Ubuntu 12.04 LTS and have been trying to bring things to life with Postgres 9.1 and PostGIS 2.0.1 Thanks in advance for any support. Best regards, Geo-rookie___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] What have I got wrong?
Hi, Is the PostgreSQL server started on port 5433 ? (default port is 5432) (ps aux |grep postgres may show you information about started postgres program) Nicolas On 9 July 2012 17:45, Phil Shea wrote: > Hi all, > > Apologies to everyone if this has already been documented before or if my > problem is so obvious but.. > > After trying for the best part of three days I'm unable (unsure what the > heck I'm doing wrong) with trying to get postgis working with postgres. If > anyone can point out what it is I be hugely grateful. > > I've followed the official postgis installation documentation and guides / > tutorials on the PostGIS WIKI and keep arriving at the same message below in > a terminal window. > > createdb: could not connect to database postgres: could not connect to > server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5433"? > > If it helps I'm running Ubuntu 12.04 LTS and have been trying to bring > things to life with Postgres 9.1 and PostGIS 2.0.1 > > Thanks in advance for any support. > > Best regards, > > Geo-rookie > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] What have I got wrong?
Specifically, did you try createdb -p 5433 ? I'm not a Ubuntu specialist, but is it possible you already have a stock postgresql running on port 5432 and that the 9.1 version took the 5433 port to run on ? Nicolas On 9 July 2012 18:08, Nicolas Ribot wrote: > Hi, > > Is the PostgreSQL server started on port 5433 ? (default port is 5432) > (ps aux |grep postgres may show you information about started postgres > program) > > Nicolas > > On 9 July 2012 17:45, Phil Shea wrote: >> Hi all, >> >> Apologies to everyone if this has already been documented before or if my >> problem is so obvious but.. >> >> After trying for the best part of three days I'm unable (unsure what the >> heck I'm doing wrong) with trying to get postgis working with postgres. If >> anyone can point out what it is I be hugely grateful. >> >> I've followed the official postgis installation documentation and guides / >> tutorials on the PostGIS WIKI and keep arriving at the same message below in >> a terminal window. >> >> createdb: could not connect to database postgres: could not connect to >> server: No such file or directory >> Is the server running locally and accepting >> connections on Unix domain socket "/tmp/.s.PGSQL.5433"? >> >> If it helps I'm running Ubuntu 12.04 LTS and have been trying to bring >> things to life with Postgres 9.1 and PostGIS 2.0.1 >> >> Thanks in advance for any support. >> >> Best regards, >> >> Geo-rookie >> >> ___ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users