Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C6D49B5DBD5 for ; Sun, 7 Aug 2011 19:26:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 58672-04 for ; Sun, 7 Aug 2011 22:26:28 +0000 (UTC) X-Greylist: delayed 00:05:16.415681 by SQLgrey-1.7.6 Received: from mail-pz0-f42.google.com (mail-pz0-f42.google.com [209.85.210.42]) by mail.postgresql.org (Postfix) with ESMTP id 14879B5D8C5 for ; Sun, 7 Aug 2011 19:26:27 -0300 (ADT) Received: by pzk37 with SMTP id 37so1958629pzk.15 for ; Sun, 07 Aug 2011 15:26:27 -0700 (PDT) Received: by 10.142.240.20 with SMTP id n20mr5095802wfh.401.1312755670852; Sun, 07 Aug 2011 15:21:10 -0700 (PDT) Received: from Craig-Jamess-MacBook-Pro.local (mta-76-176-59-179.san.rr.com [76.176.59.179]) by mx.google.com with ESMTPS id f8sm98848pbk.6.2011.08.07.15.21.08 (version=SSLv3 cipher=OTHER); Sun, 07 Aug 2011 15:21:09 -0700 (PDT) Message-ID: <4E3F0FEA.3080901@emolecules.com> Date: Sun, 07 Aug 2011 15:21:30 -0700 From: Craig James User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.18) Gecko/20110616 Thunderbird/3.1.11 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: All the functionality I need is pgsql2shp.exe-- isolated installation References: <1312738230333-4675350.post@n5.nabble.com> In-Reply-To: <1312738230333-4675350.post@n5.nabble.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.778 tagged_above=-10 required=5 tests=BAYES_00=-1.9, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201108/22 X-Sequence-Number: 38009 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. >