Re: All the functionality I need is pgsql2shp.exe-- isolated installation

On 8/7/11 10:30 AM, antismarmy wrote:
> 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.
>