pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAll the functionality I need is pgsql2shp.exe-- isolated installation
4+ messages / 2 participants
[nested] [flat]
* All the functionality I need is pgsql2shp.exe-- isolated installation
@ 2011-08-07 17:30 antismarmy <sksupak@ncsu.edu>
0 siblings, 2 replies; 4+ messages in thread
From: antismarmy @ 2011-08-07 17:30 UTC (permalink / raw)
To: 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-insta...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: All the functionality I need is pgsql2shp.exe-- isolated installation
@ 2011-08-07 22:21 Craig James <craig_james@emolecules.com>
parent: antismarmy <sksupak@ncsu.edu>
1 sibling, 0 replies; 4+ messages in thread
From: Craig James @ 2011-08-07 22:21 UTC (permalink / raw)
To: pgsql-admin
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-insta...
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: All the functionality I need is pgsql2shp.exe-- isolated installation
@ 2011-08-07 22:22 Craig James <craig_james@emolecules.com>
parent: antismarmy <sksupak@ncsu.edu>
1 sibling, 1 reply; 4+ messages in thread
From: Craig James @ 2011-08-07 22:22 UTC (permalink / raw)
To: pgsql-admin
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 option for 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/postgres directory. At that point, you can delete the source code plus everything in the $HOME/postgres/bin directory except the one program you want. Set the environment variable LD_LIBRARY_PATH to include $HOME/postgres/lib, and you should be able to run the binaries. You can probably delete some of the libraries in $HOME/postgres/lib too that aren'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-insta...
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: All the functionality I need is pgsql2shp.exe-- isolated installation
@ 2011-08-08 15:13 antismarmy <sksupak@ncsu.edu>
parent: Craig James <craig_james@emolecules.com>
0 siblings, 0 replies; 4+ messages in thread
From: antismarmy @ 2011-08-08 15:13 UTC (permalink / raw)
To: pgsql-admin
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-insta...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2011-08-08 15:13 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-07 17:30 All the functionality I need is pgsql2shp.exe-- isolated installation antismarmy <sksupak@ncsu.edu>
2011-08-07 22:21 ` Craig James <craig_james@emolecules.com>
2011-08-07 22:22 ` Craig James <craig_james@emolecules.com>
2011-08-08 15:13 ` antismarmy <sksupak@ncsu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox