Hi at all........
I have a problem with db.connect module...
I'm trying to connect to driver pg, the steps is following:
db.connect driver=pg database=host=debian,dbname=mydb,port=5432
db.login user=postgres pass=*******
db.connect -p
db.tables -p
It get me error:
GRASS 6.2.0 (ditragis):~ > db.connect -p
driver:pg
database:host=debian,dbname=ditragis_db,port=5432
schema:public
group:(null)
GRASS 6.2.0 (ditragis):~ > db.tables -p
DBMI-Postgres driver error:
Cannot connect to Postgres: could not connect to server: Connection refused
Is the server running on host "debian" and accepting
TCP/IP connections on port 5432?
GRASS 6.2.0 (ditragis):~ >
I have set up my /etc/profile PATH to /usr/local/pgsql/bin.
Can someone help me?
--
View this message in context: http://www.nabble.com/db.connect!--tf2783749.html#a7767245
Sent from the Grass - Users mailing list archive at Nabble.com.
Hi,
if your host "debian" is localhost, try to use
"localhost" instead as host name.
if not or if fails, I guess that you have to enable
tcp for postmaster.
Markus
On Fri, Dec 08, 2006 at 03:27:21PM -0800, Salvator*eL*arosa wrote:
Hi at all........
I have a problem with db.connect module...
I'm trying to connect to driver pg, the steps is following:
db.connect driver=pg database=host=debian,dbname=mydb,port=5432
db.login user=postgres pass=*******
db.connect -p
db.tables -p
It get me error:
GRASS 6.2.0 (ditragis):~ > db.connect -p
driver:pg
database:host=debian,dbname=ditragis_db,port=5432
schema:public
group:(null)
GRASS 6.2.0 (ditragis):~ > db.tables -p
DBMI-Postgres driver error:
Cannot connect to Postgres: could not connect to server: Connection refused
Is the server running on host "debian" and accepting
TCP/IP connections on port 5432?
GRASS 6.2.0 (ditragis):~ >
I have set up my /etc/profile PATH to /usr/local/pgsql/bin.
Can someone help me?
--
View this message in context: http://www.nabble.com/db.connect!--tf2783749.html#a7767245
Sent from the Grass - Users mailing list archive at Nabble.com.
_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser
--
Markus Neteler <neteler itc it> http://mpa.itc.it/markus/
ITC-irst - Centro per la Ricerca Scientifica e Tecnologica
MPBA - Predictive Models for Biol. & Environ. Data Analysis
Via Sommarive, 18 - 38050 Povo (Trento), Italy
Thanks for your quick reply.
I have tried to replace localhost in debian, now work nice!
Markus Neteler wrote:
Hi,
if your host "debian" is localhost, try to use
"localhost" instead as host name.
if not or if fails, I guess that you have to enable
tcp for postmaster.
Markus
On Fri, Dec 08, 2006 at 03:27:21PM -0800, Salvator*eL*arosa wrote:
Hi at all........
I have a problem with db.connect module...
I'm trying to connect to driver pg, the steps is following:
db.connect driver=pg database=host=debian,dbname=mydb,port=5432
db.login user=postgres pass=*******
db.connect -p
db.tables -p
It get me error:
GRASS 6.2.0 (ditragis):~ > db.connect -p
driver:pg
database:host=debian,dbname=ditragis_db,port=5432
schema:public
group:(null)
GRASS 6.2.0 (ditragis):~ > db.tables -p
DBMI-Postgres driver error:
Cannot connect to Postgres: could not connect to server: Connection
refused
Is the server running on host "debian" and accepting
TCP/IP connections on port 5432?
GRASS 6.2.0 (ditragis):~ >
I have set up my /etc/profile PATH to /usr/local/pgsql/bin.
Can someone help me?
--
View this message in context:
http://www.nabble.com/db.connect!--tf2783749.html#a7767245
Sent from the Grass - Users mailing list archive at Nabble.com.
_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser
--
Markus Neteler <neteler itc it> http://mpa.itc.it/markus/
ITC-irst - Centro per la Ricerca Scientifica e Tecnologica
MPBA - Predictive Models for Biol. & Environ. Data Analysis
Via Sommarive, 18 - 38050 Povo (Trento), Italy
_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser
--
View this message in context: http://www.nabble.com/db.connect!--tf2783749.html#a7770863
Sent from the Grass - Users mailing list archive at Nabble.com.