All the functionality I need is pgsql2shp.exe-- isolated installation - Mailing list pgsql-admin

From antismarmy
Subject All the functionality I need is pgsql2shp.exe-- isolated installation
Date
Msg-id 1312738230333-4675350.post@n5.nabble.com
Whole thread Raw
Responses Re: All the functionality I need is pgsql2shp.exe-- isolated installation  (Craig James <craig_james@emolecules.com>)
Re: All the functionality I need is pgsql2shp.exe-- isolated installation  (Craig James <craig_james@emolecules.com>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump: Error message from server: ERROR: out of shared memory on one system works fine on another
Next
From: Craig James
Date:
Subject: Re: All the functionality I need is pgsql2shp.exe-- isolated installation