Thread: All the functionality I need is pgsql2shp.exe-- isolated installation
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.
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. >
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. (sorry for the last post ... here's what I meant to send.) Get the Postgres source code, and configure it to install into your home directory. The configure command has an optionfor this: ./configure --prefix=$HOME/postgres Then follow the make and install directives. You'll end up with a complete running Postgres system in your $HOME/postgresdirectory. At that point, you can delete the source code plus everything in the $HOME/postgres/bin directoryexcept the one program you want. Set the environment variable LD_LIBRARY_PATH to include $HOME/postgres/lib, andyou should be able to run the binaries. You can probably delete some of the libraries in $HOME/postgres/lib too thataren't used by the program you want. Craig > 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. >
Thank you for the help... I will give this a try! -- View this message in context: http://postgresql.1045698.n5.nabble.com/All-the-functionality-I-need-is-pgsql2shp-exe-isolated-installation-tp4675350p4678033.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.