[postgis-devel] PostGIS 1.4 and PostgreSQL 8.4
Waddell, Dave FOR:EX
Dave.Waddell at gov.bc.ca
Thu Aug 6 13:25:45 PDT 2009
Yes. I am just using the zip binaries from
http://www.enterprisedb.com/products/pgbindownload.do and bypassing the
one-click installer.
For ease of installation, I will simply fold the PostGIS binaries from
http://postgis.refractions.net/download/windows/)
into the PostgreSQL directory structure and use one NSIS installer
script.
-----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 1:13 PM
To: 'PostGIS Development Discussion'
Subject: Re: [postgis-devel] PostGIS 1.4 and PostgreSQL 8.4
Dave,
So you would just use the zip archive binaries here right?
http://www.enterprisedb.com/products/pgbindownload.do
Or are you saying that behaves differently from 8.3
-----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:31 PM
To: PostGIS Development Discussion
Subject: Re: [postgis-devel] PostGIS 1.4 and PostgreSQL 8.4
The Vista oddity that was causing me grief was the initdb when trying to
do an install with a privileged account.
So the custom install simply:
creates the directory structure
copies the binaries.
adds the /bin to the path and then stops.
The local user (non privileged account) than has to run a script to:
initdb
pg_ctl start
createuser/createdb as required for local configuration
setup ENV
etc....
-----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:25 PM
To: 'PostGIS Development Discussion'
Subject: Re: [postgis-devel] PostGIS 1.4 and PostgreSQL 8.4
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
_______________________________________________
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