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

  • 1
    The question why do you need to do this? Looking at the postgis install there 12 or so regedit entries required. – Mapperz May 24 '13 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 '13 at 14:50
  • See the old post gis.stackexchange.com/questions/28933/… – Mapperz May 24 '13 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 Maraev May 27 '13 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 – Ruthe Mar 31 '14 at 8:50

PostGIS Windows dl site provides information about running it without installing. The blog it links to has all the info needed.

  • Jakub Kania, Thanx a lot. I've used something like that)) – Andrey Maraev May 27 '13 at 13:13

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 – Andrey Maraev May 27 '13 at 13:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.