[GRASS-user] help with postgres DB

[Jarosław Jasiewicz]

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 at 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