[GRASS-user] t.create error: Unable to connect to psycopg2 database: newdb

GRASS GRASS user
, ,
1

Hi,

I'm having some trouble with t.create/t.connection and postgresql.

t.create is giving the following error on attempting to create a raster
space time dataset in postgresql, and then I'm also subsequently unable to
create a space time database in sqlite?

I'd be grateful for any suggestions on how to resolve.

Cheers,
Richard

For example:
# set connection in t.connect and try and create dataset:
t.connect driver=pg database=newdb
(I've also tried t.connect driver=pg database="newdb user=user
password=*******")
The VAR file contains the new settings.

t.create --overwrite output=teststrds type=stvds semantictype=max title=t
description=d
ERROR: Unable to connect to psycopg2 database: newdb
Exception: "missing "=" after "newdb" in connection info string
"
Please use t.connect to set a read- and writable temporal database backend

I then try to create a temporal dataset in sqlite, but I then get an error
with sqlite?
t.connect database=/home/rcooper/grassdatacl/climdata/newdb/tgis/sqlite.db
t.connect -p
driver:sqlite
database:/home/rcooper/grassdatacl/climdata/newdb/tgis/sqlite.db

t.create --overwrite output=test_sq_strds type=stvds semantictype=max
title=t description=d
Creating temporal database:
/home/rcooper/grassdatacl/climdata/newdb/tgis/sqlite.db
ERROR: Unable to connect to psycopg2 database:
/home/rcooper/grassdatacl/climdata/newdb/tgis/sqlite.db
Exception: "missing "=" after "newdb" in connection info string
"
Please use t.connect to set a read- and writable temporal database backend

NOTE: I can connect to the postgresql database with db.login and db.connect,
so it doesn't seem to be a permissions issue.
db.login driver=pg database=newdb user=user password=*****

db.connect -p database=newdb
driver: pg
database: newdb
schema: public
group:

System:
GRASS version: 7.0.1svn
GRASS SVN Revision: 65041
Build Date: 2015-04-10
Build Platform: x86_64-unknown-linux-gnu
GDAL/OGR: 1.11.2
PROJ.4: 4.9.0
GEOS: 3.4.2
SQLite: 3.8.2
Python: 2.7.6
wxPython: 2.8.12.1
Platform: Linux-3.13.0-95-generic-x86_64-with-LinuxMint-17.1-rebecca

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/t-create-error-Unable-to-connect-to-psycopg2-database-newdb-tp5296563.html
Sent from the Grass - Users mailing list archive at Nabble.com.

2

I upgraded to 7.0.6 and I can now reset the database to sqlite, but still
cannot connect to a PostgreSQL database. I'll check again on the t.connect
commands. Does anyone else have any trouble connecting to a potgresql db
with t.connect and creating a temporal dataset with t.create?

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/t-create-error-Unable-to-connect-to-psycopg2-database-newdb-tp5296563p5296586.html
Sent from the Grass - Users mailing list archive at Nabble.com.

3

On Sat, Nov 19, 2016 at 4:35 PM, RichardCooper <richtcooper@hotmail.com> wrote:

I upgraded to 7.0.6 and I can now reset the database to sqlite, but still
cannot connect to a PostgreSQL database. I'll check again on the t.connect
commands. Does anyone else have any trouble connecting to a potgresql db
with t.connect and creating a temporal dataset with t.create?

Would you mind to make a try with GRASS GIS 7.2.0RC2? You can install
it in parallel.

Markus

4

Replying somewhat late to my query last year, but I'm still getting the same
error with regard to using t.create with a PostgreSQL database connection
with GRASS 7.2.0

t.connect driver=pg database=grasscldb
(Sat May 6 20:36:01 2017) Command finished (0 sec)
(Sat May 6 20:36:08 2017)
t.connect -p driver=pg database=grasscldb
driver:pg
database:grasscldb
(Sat May 6 20:36:08 2017) Command finished (0 sec)

t.create --overwrite output=cahpc_test_strd temporaltype=relative
semantictype=max title=title test description=descr test
ERROR: Unable to connect to psycopg2 database: grasscldb
Exception: "missing "=" after "grasscldb" in connection info string
"
Please use t.connect to set a read- and writable temporal database backend
(Sat May 6 20:37:36 2017) Command finished (0 sec)
          
System Info
GRASS version: 7.2.0
GRASS SVN revision: exported
Build date: 2017-04-07
Build platform: x86_64-pc-linux-gnu
GDAL: 1.11.2
PROJ.4: 4.9.0
GEOS: 3.4.2
SQLite: 3.8.2
Python: 2.7.6
wxPython: 2.8.12.1
Platform: Linux-3.13.0-95-generic-x86_64-with-LinuxMint-17.1-rebecca

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/t-create-error-Unable-to-connect-to-psycopg2-database-newdb-tp5296563p5319598.html
Sent from the Grass - Users mailing list archive at Nabble.com.