hi all,
I have a .dbf file holding the attribute info - result of importing a .dgn file using v.in.ogr.
The file is in /home/knoppix/grassdata/spearfish60/user1/dbf directory (I am using live CD).
I wish to set up a ODBC connection with a Postgres SQL DB and import the .dbf file to pg for
advanced querying options.
I have been able to start postgres SQL service on port 5432. It is running.
But when I do a createdb command from grass console I get a prompt that role does not exist.
or role doesnot exist.
What do I have to do … to create a new DB in postgresSQL from grass console and then import the .dbf layer
to it.
Actually I am writting a shell script … so it is important to do this from the Grass console. Is there a way to do
what I wan’t from the Grass console…one more thing the db.createdb command when entered in the grass console
says that no such command … so I am using createdb.
Thanks
nishith
nishith datta napisał(a):
hi all,
I have a .dbf file holding the attribute info - result of importing a .dgn file using v.in.ogr.
The file is in /home/knoppix/grassdata/spearfish60/user1/dbf directory (I am using live CD).
I wish to set up a ODBC connection with a Postgres SQL DB and import the .dbf file to pg for
advanced querying options.
I have been able to start postgres SQL service on port 5432. It is running.
But when I do a createdb command from grass console I get a prompt that role <knoppix> does not exist.
or role <root> doesnot exist.
What do I have to do .... to create a new DB in postgresSQL from grass console and then import the .dbf layer
to it.
Actually I am writting a shell script .. so it is important to do this from the Grass console. Is there a way to do
what I wan't from the Grass console....one more thing the db.createdb command when entered in the grass console
says that no such command ... so I am using createdb.
Thanks
nishith------------------------------------------------------------------------
_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser
it is postgreSQL problem there is no postgreSQL user but postgres
do the follow:
su root (passwd if requiered)
su - postgres
psql
CREATE ROLE ..... etc
Jarek
but I don't know if it will working on liveCD