I have used Windows7x64 and want start PostgreSQL+POSTGIS without installation process. I copy PostgresSQl\9.1 folder from other laptop to c:\opt. I need create .bat file with enviroment variables and add pg_ctl.exe with any parameters. is it possible start Postgresql server without creating Windows services and using any regedit manipulations? Sorry if my question is not correct compiled
-
1The question why do you need to do this? Looking at the postgis install there 12 or so regedit entries required.– Mapperz ♦May 24, 2013 at 14:03
-
Only other method is via a Virtual Box running Linux (i.e.Ubuntu and bridging the virtual network adapters to appear on the same machine).– Mapperz ♦May 24, 2013 at 14:50
-
See the old post gis.stackexchange.com/questions/28933/…– Mapperz ♦May 24, 2013 at 14:51
-
Thanx for your help but now I need the Jakub Kania's method. It needs for a scrypting process in my issue...– Andrey MaraevMay 27, 2013 at 13:15
-
i created by installer(.exe) and copy folder to another computer i start manual with command line following "../bin"pg_ctl -D ../data– RutheMar 31, 2014 at 8:50
2 Answers
PostGIS Windows dl site provides information about running it without installing. The blog it links to has all the info needed.
I don't think it is possible to run postgres without setting up the service and the postgres
user.
The client has to know what port the database is listening to etc.
What you can do is setting up the database identically on two computers, and exchange the data directories if needed.
-
I've just installed it om the one of the laptop then copy all directory to another laptop, finally start pgsql with cmd-file. See bellow... Thanx for a reply May 27, 2013 at 13:17