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

Hi,

If the psql program is always going to be in C:\Program
Files\PostgreSQL\8.0\bin, couldn't you eliminate the "cd", and just specify
the full path (if psql is not in the current PATH) as needed? Or, add it
to the PATH: PATH %path%;C:\Program Files\PostgreSQL\8.0\bin

If you running the .bat file from the CD, you won't have to know the drive
letter.

E.g.:

psql -f MYBASE_SHEMA.dumpall template1 -U zmatic
psql -f MYBASE_SHEMA.dumpall template1 -U zmatic
vacuumdb -d MYBASE -U zmatic

You could add the path for psql if you need to. E.g.:

@ECHO off

if exist test_path.pl GOTO foundit
echo "placing psql in path"
PATH %path%;C:\Program Files\PostgreSQL\8.0\bin

:foundit
echo "now doing the psql"

... then continue with your psql commands.

Hope this helps.

Susan

Zlatko Matić
<zlatko.matic1@sb.t-com To: <pgsql-general@postgresql.org>
.hr> cc:
Sent by: Subject: [GENERAL] Instalation batch file

|-------------------|
pgsql-general-owner@pos | [ ] Expand Groups |
tgresql.org |-------------------|

08/03/2005 02:29
PM

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 ?

Thanks in advance,

Zlatko

----------------------------------------------------------------------------------------------
See our award-winning line of tape and disk-based
backup & recovery solutions at http://www.overlandstorage.com
----------------------------------------------------------------------------------------------

Thank you for answer. It seems that %HOMEDRIVE% is just enough to solve this
problem.
Thanks.

----- Original Message -----
From: "Glenn Davy" <gdavy@tpg.com.au>
To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, August 04, 2005 12:15 AM
Subject: Re: [GENERAL] 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org