[postgis-devel] PostGIS 1.4 and PostgreSQL 8.4

Paragon Corporation lr at pcorp.us
Thu Aug 6 12:24:40 PDT 2009


Then you should be fine I think.  You'll just need to have a batch script.

I haven't done it in a while, but I think you just need to copy the binaries
in a folder etc, 
a) just do an initdb the first time as part of your install process
b) then pg_ctl from then forward.

Hope that helps,
Regina

-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Waddell,
Dave FOR:EX
Sent: Thursday, August 06, 2009 3:08 PM
To: PostGIS Development Discussion
Subject: Re: [postgis-devel] PostGIS 1.4 and PostgreSQL 8.4

In my world I'm not allowed to run anything as a service.  Hence one of the
reasons for doing a custom install.  The one-click installer for 8.3 had the
option to NOT install as a service, but this is not longer available.

I will simply have local users us pg_ctl to stop and start the database as
required.

In our case it isn't Vista that is the problem, but the security layers
piled on top of users access restrictions.




-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Paragon
Corporation
Sent: Thu, August 6, 2009 12:04 PM
To: 'PostGIS Development Discussion'
Subject: Re: [postgis-devel] PostGIS 1.4 and PostgreSQL 8.4

Dave,

Are you planning to run this as a service or just via pg_ctl as needed.
I think as service you will always be writing to the registry no option.
If you only need it to run while your app is running, then I think you can
skip the registry thing.

Vista is particularly finicky with security as you have probably
experienced.

Hope that helps,
Regina 

-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Waddell,
Dave FOR:EX
Sent: Thursday, August 06, 2009 2:12 PM
To: PostGIS Development Discussion
Subject: Re: [postgis-devel] PostGIS 1.4 and PostgreSQL 8.4

Thanks Regina and Mark.  Makes sense now.

For a bare bones PostgreSQL and PostGIS install on Vista, can I get away
without the windows registry entries?

-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Mark
Cave-Ayland
Sent: Thu, August 6, 2009 1:56 AM
To: PostGIS Development Discussion
Subject: Re: [postgis-devel] PostGIS 1.4 and PostgreSQL 8.4

Paragon Corporation wrote:

> Dave,
>  
> Both should work fine.  The version we compiled was the newest 
> libiconv2, but we tested the shp2pgsql with the old version and the 
> new and it seemed to work fine for us in either case and didn't notice

> any issues with the PostgreSQL behavior we have.
>  
> So I think you are fine sticking with what is packaged with the 
> PostgreSQL 8.4 if its got the same name.
>  
> The installation issues discussed before were caused because PostGIS 
> install tried to overwrite the libiconv-2.dll which was already 
> present in PostgreSQL installs so the solution has always been to just

> skip it if you have it.  Although in my PostgreSQL 8.4 install for 
> some reason the file that I got when installing was libiconv.dll 
> (which is the same as libiconv-2.dll more or less), but PostGIS the 
> way it is compiled needs it to be called libiconv-2.dll
>  
> Mark correct me if anything I send is wrong.

That pretty much sounds correct. It only occurs because the GNUWin32 folks
took it upon themselves to give the DLLs different names than those created
with autotools, and with the PostgreSQL move to MSVC then this has become
more of an issue. At the moment PostgreSQL and PostGIS have their own
separate DLLs, and so all is well :)


HTH,

Mark.

--
Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius
Corporation plc - control through freedom http://www.siriusit.co.uk
t: +44 870 608 0063
_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel
_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel



_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel
_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel





More information about the postgis-devel mailing list