[GRASS-user] Question about databases and vector files...

[Jonathan Greenberg]

All good, I finally got postgresql running and no longer have any of these
issues!  Incidentally, is there any plan to begin using postgis geometry
directly within grass (or is the long term goal to keep the grass vector
geometry)?

For the record, the cygwin install + instructions for getting postgresql
running are AWFUL, but the windows installer you can get from the postgresql
website
(http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.2.
4%2Fwin32%2Fpostgresql-8.2.4-1.zip) worked flawlessly -- took me about 2
minutes to get postgresql up and running.  

Is there a way to automatically connect to the database on grass boot?
Also, I noticed the password is completely unencrypted when you connect in
grass -- are there any plans to fix this at some point?

--j

-----Original Message-----
From: Moritz Lennert [mailto:mlennert at club.worldonline.be] 
Sent: Friday, April 27, 2007 5:31 AM
To: Markus Neteler
Cc: grassuser at grass.itc.it; Jonathan Greenberg
Subject: Re: [GRASS-user] Question about databases and vector files...

On 27/04/07 13:59, Markus Neteler wrote:
> Jonathan Greenberg wrote on 04/26/2007 07:31 PM:
>> As I said -- lots of newbie questions here (I'm a raster man, just now
>> beginning to learn the intricacies of vector files beyond "hey, it's a
bunch
>> of points") -- is there any inherent size limitation for vector files
(the
>> geometry portion) in grass? 
> 
> As far as I remember, Helena imported up to 500 million points - but
> without topology (via
> v.in.ascii -b ...). As Glynn said, the 2GiB limit is one problem unless
> LFS is working for
> vector data, too.
>>  E.g. should I be fine with the points I've
>> described if I use the pg to deal with the database portion, as opposed
to
>> the standard dbf driver?
>>   
> Maybe you can give it a try and report back?

If the problem is in the dbf driver, then using an alternative database 
backend is not only 'fine', but probably the only solution until we 
understand the issue. However, I'm not sure that your problems come from 
the dbf driver...

Try with the postgreSQL driver, and if that does not work, send us more 
detailed information about the failure (i.e. command used, error 
messages, etc)

I all depends on what you want to do with the data. Do you need the 
points only to interpolate a DEM, or something else ?

Moritz