Re: Instalation batch file

On Wed, 2005-08-03 at 23:29 +0200, Zlatko Matić wrote:
> Hello.
>
> I would like to install database schema on a server using files with
> dumped schema and globals (produced by dumpall), that are placed on
> CD. The installation script (batch file) that restores these two files
> is also placed on the same CD, (let's say E:) in the same folder.
>
> cd C:\Program Files\PostgreSQL\8.0\bin
> psql -f E:\MYBASE_SHEMA.dumpall template1 -U zmatic
> psql -f E:\MYBASE_SHEMA.dumpall template1 -U zmatic
> vacuumdb -d MYBASE -U zmatic
>
> But, what if CD is F: or some other unit ?
> How could I change this batch file (Windows XP) to be able to
> recognize what is the actual path of the folder that containes these
> three files ?

Im not sure how to determine the path to the media (esp if more than one
cd/dvd), but you could take a couple of different approaches:
1)that is to run the script from the cd drive and build the path to pg's
bin with %HOMEDRIVE%. Type 'SET' to see what other shell variables
there are
2) Run the script from anywhere and take %1 type command line paramaters
to ask location of either bin and/or cd/dvd

Been years since I've had the misfortune to have to use windows shell
scipts, but there are prob many other approachs - best to do a little
research into windows shell scripting and determine best for your
scenario.

Glenn
>
> Thanks in advance,
>
> Zlatko