8

I realize it is not listed as a supported Database. I am interested to see if anyone has tried to install and use it.

Improve this question

4 Answers 4

Reset to default
2

there is simple answer here about supporting postgresql 9.

Will Esri support PostgreSQL 9 at 10.1?

Yes, PostgreSQL 9.0.2 will be supported at 10.1.

i hope it helps you...

Improve this answer
1

Wait for ZigGIS 3.0 then you can edit without ArcSDE.

http://geobabble.wordpress.com/2010/04/23/ziggis-3-0-to-be-open-source/

It's still in development.

Improve this answer
2
  • The current, commercial, version of zigGIS can edit PostGIS geometries now without ArcSDE. I don't think it's been tested with PostgreSQL 9 or the latest version of PostGIS yet, though.
    – Bill Dollins
    Commented Oct 7, 2010 at 22:19
  • ZigGIS is alive or dead? I try to find any information but nothing.
    – Vassilis
    Commented Jul 27, 2012 at 9:13
0

I downloaded it but there is no "free" win exe for it yet. So I began to learn how to build it on my win xp machine and decided to stick with the supported esri sde install. (which states that you are to use the postgres install on the sde dvd. 8.3) So that is where I am now.

Improve this answer
4
  • 1
    What do you mean there is no win exe (all pure postgresql releases are free). enterprisedb.com/getfile.jsp?fileid=1518 has been there since release.
    – Nicklas Avén
    Commented Oct 18, 2010 at 15:05
  • Thank you for the link. Am I mistaken? Every time I download and install an enterprisedb build I get the message to start my free 30 day trial. I see pricinig on their website. I have not been successful searching their website for install files like this.
    – Brad Nesom
    Commented Oct 20, 2010 at 15:43
  • have you seen postgis win install for 9?
    – Brad Nesom
    Commented Oct 22, 2010 at 22:11
  • The above link shouldn't give you a 30-day trial period. If you get that I think you have downloaded postgresql plus. That is why I wrote "pure" postgresql.
    – Nicklas Avén
    Commented Nov 4, 2010 at 15:03
0

I haven't tried either, but worst case scenario, you should be able to use the ODBC drivers and connect to that DB.

Improve this answer
2
  • but you will never get the geometries through ODBC, only attribute data, right?
    – Nicklas Avén
    Commented Nov 11, 2010 at 23:14
  • Not necessarily, you can call PostGIS functions in your SQL and return the geometries as WKT or WKB in your standard ODBC record set.
    – Bill Dollins
    Commented Nov 12, 2010 at 21:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.