[GENERAL] changing the default directory

2008-01-24 Thread User Map
hi, i am new to this postgre, i m running postgre under windows server 2003. postgres stores the database/data in the directory "C:\Program Files\PostgreSQL\8.2\data" by default. i want to change this directory to some other drive. is it posible to do this without comand prompt. if it is not the

Re: [GENERAL] changing the default directory

2008-01-24 Thread User Map
e installed postgre. thanks for any help Raymond O'Donnell <[EMAIL PROTECTED]> wrote: On 24/01/2008 13:02, User Map wrote: > i am new to this postgre, i m running postgre under windows server 2003. > postgres stores the database/data in the directory "C:\Program > Fi

[GENERAL] change the default data directory

2008-01-24 Thread User Map
hi, i am new to this postgre, i m running postgre under windows server 2003. postgres stores the database/data in the directory "C:\Program Files\PostgreSQL\8.2\data" by default. i want to change this directory to some other drive. is it posible to do this without comand prompt. if it is not the

[GENERAL] exporting postgre data

2008-01-25 Thread User Map
is it posible to transfer data from postgres of one computer to the postgres in another computer. In SQL server this is easily done by the export utility of the sql server. - Never miss a thing. Make Yahoo your homepage.

[GENERAL] calculating extent on basis of distance from a given point

2008-05-15 Thread User Map
hi, i have OSGB36 data in postgre, srid 27700. what i want to do is to calculate the extent on basis of the distance from a given point. i have geom of type geometry in the table, from which to calculate extent. i have tried the funtions Distance(geom,geom)<50, but it is too slow, as it uses no

[GENERAL] extent within given distance

2008-05-16 Thread User Map
hi, Is there any way to calculate the extent(geom) on basis of the given distance from a point, such as the point is in the middle. I have tried the Distance(geom,geom)<50, for calculating extent, but it is very slow in processing. My data SRID is 27700, and so the units are meters, i want to

[GENERAL] Fw: Distance w.r.t scalebar and postgre distance query

2008-05-30 Thread User Map
- Forwarded Message From: User Map <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 27, 2008 10:07:12 AM Subject: [mapserver-users] Distance w.r.t scalebar and postgre distance query hi, i have a table with geom type geometry, with srid= 27700