Date: Sun, 7 Aug 2011 10:30:30 -0700 (PDT)
From: antismarmy <sksupak@ncsu.edu>
To: pgsql-admin@postgresql.org
Message-ID: <1312738230333-4675350.post@n5.nabble.com>
Subject: All the functionality I need is pgsql2shp.exe-- isolated installation
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello community,

I need to execute pgsql2shp from the command line, but I am not interested
in the other functionalities offered by postgresql on this machine. I have
been told that installing an instance of a spatial database on the machine
in question just to serve as a workaround for one utility executable is not
something that IT will approve of, due to the extra overhead of software &
DB maintenance, security configuration and server system resources...

Is there a way to isolate all of the files necessary for a specific
executable (in my case pgsql2shp.exe) from the postgresql 8.3 binaries
without using the installer program.

My collegue has already tried the following:
"I did download a copy of the postgresql 8.3 binaries without the installer
program and extracted a copy of psql.exe and put it on the application
server in d:\database_apps, along with a dll file dependency "ssleay32.dll".
I added "d:\database_apps" to the system PATH in hopes that psql.exe could
be invoked at a command prompt without specifying where it was.
Unfortunately this did not work. The executable needs something else that
isn't there, and I am afraid it might be other Windows system 32-bit dlls
that don't exist on a 64-bit version of Windows Server 2008."

Thanks,
Stacy

--
View this message in context: http://postgresql.1045698.n5.nabble.com/All-the-functionality-I-need-is-pgsql2shp-exe-isolated-installation-tp4675350p4675350.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.