[postgis-users] [off-topic] How to init postgres databases onwindows F: drive

Stephen Woodbridge woodbri at swoodbridge.com
Wed Jul 29 11:06:17 PDT 2009


Leo,

Thanks! I decided to uninstall and reinstall the database. It was a 
little more obvious this time because I was looking for places in the 
install that would let be specify where to put the database.

-Steve W.

Paragon Corporation wrote:
> Steve,
> 
> Actually that setting I believe was an option (I think the second step on
> the enterprise db installer).
> 
> There are 3 ways that come to mind
> 
> 1) Way one I haven't tried but should work
> a) Stop the postgresql service
> B)  Copy the data folder you already initialized to the F drive nd set
> permissions to allow postgres account full rights
> C) change the postgresql.conf in the data folder
> D) delete the service with a 
> Sc delete "name of postgresql service here"
> 
> E) Reinstall the service with
>  Using 
> pg_ctl register -N ....
> 
> Basically what is described here
> http://trac.osgeo.org/postgis/wiki/UsersWikiWinCompileInitdb  
> 
> Way 2) assuming you have no data.  You could just uninstall and reinstall.  
> 
> Way 3) Create a new cluster with initdb -- also in above link (this only if
> you have no data)
> 
> Leo
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Stephen
> Woodbridge
> Sent: Tuesday, July 28, 2009 5:20 PM
> To: PostGIS Users Discussion
> Subject: [postgis-users] [off-topic] How to init postgres databases
> onwindows F: drive
> 
> Hi all,
> 
> Sorry for a little bit off topic post, but I'm trying to setup a new
> postgresql/postgis install on a Windows box and I need the data files to be
> on the f: drive. I'm using postgres 8.3.7 and postgis 1.4
> 
> Can anyone tell me how to do this?
> 
> Unfortunately out of the box it installed everything on the C: drive and I
> do not remember seeing an option on where to be the data files?
> 
> Thanks,
>    -Steve W
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list