Thread: Cygwin and Native Windows Install of Postgres
Dear PG Novice List, http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html#3.1 says to remove cygwin\bin from the path before running "the installer or the installed version of postgresql", but it is completely silent and does not offer *any* clues as to what to do afterwards, e.g. paths, DLLs, etc. Using Cygwin tools we have been building lots of cross-development applications for robots, including maintenance of stuff already in the field, so we don't want to muck up the current toolchains. Now I need to install postgresql to maintain an application which will run on a PC which uses the 'native' version of PostgreSQL 8.1, not the cygwin version. What should I do so that I can have both environments (cygwin & windows-native postgresql) on my work PC? Should I buy a second PC? Should I use different logins? Should I use a fudge such as run-application-as-different-user? Services as different user? -- Regards, Alf Lacis Senior Software & Design Engineer A.i. Scientific Pty Ltd 10-22 Hornibrook Esplanade CLONTARF QLD 4019 AUSTRALIA Ph: (+617 or 07) *3105 5087* http://www.aiscientific.com/
On 2/22/07, Alf Lacis <Alf.Lacis@aiscientific.com> wrote: Hi Alf, > http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html#3.1 says > to remove cygwin\bin from the path before running "the installer or the > installed version of postgresql", but it is completely silent and does not > offer *any* clues as to what to do afterwards, e.g. paths, DLLs, etc. > What should I do so that I can have both environments (cygwin & > windows-native postgresql) on my work PC? > > Should I buy a second PC? > > Should I use different logins? > > Should I use a fudge such as run-application-as-different-user? Services > as different user? I don't use postgres under windows (I don't use windows), hence can't test the procedure. But what I understand from reading this is that all you need to do is open a command prompt, redefine the PATH (tempo- rarily, obviously, since you're doing it in one session) not to contain cygwin\bin and then run the install. The problems DON'T relate to postgres, just the installer. Cheers, Andrej
On 2/22/07, Andrej Ricnik-Bay <andrej.groups@gmail.com> wrote: > I don't use postgres under windows (I don't use windows), hence can't > test the procedure. But what I understand from reading this is that all > you need to do is open a command prompt, redefine the PATH (tempo- > rarily, obviously, since you're doing it in one session) not to contain > cygwin\bin and then run the install. The problems DON'T relate to > postgres, just the installer. And sometimes it's good to read the lot before responding. My apologies. In that case I have no idea - does windows allow you to define environment variables per session/program launcher? If yes, you'd be sweet. Cheers, Andrej