Ubuntu下ArcGIS Server 10.4与PostgreSQL 9.4的完美CP

稍微说几句,为什么要折腾这个:(1)不希望再用Windows Server,理由都懂;(2)对SQL Server在应用中的各种保守表现不太满意,希望在GIS上有更激进些的工作,例如对空间数据的处理能力;(3)有些应用要有更灵活的架构,而PG在一定程度上迎合了这种需求,例如支持JSON和JSONB,成为关系和非关系混合的一种选择(据说MySQL5.7开始也支持了JSON);(4)ArcGIS Server在linux下的表现,希望用实践来验证;(5)搞技术的人面对互联网的热闹,实在无法完全抵御尝试和改变的欲望。

1 环境安装

1.1 配置说明

  • OS:Ubuntu 14.04 LTS
  • DB:PostgreSQL-9.4
  • ArcGIS:ArcGIS Server 10.4 for Linux

1.2 安装PostgreSQL

1.2.1 常规安装

PostgreSQL的安装就不多说了,按照官方教程可以很顺利地安装目前比较稳定的9.4版。在上篇文章中说过不建议使用PG官方的Installer,因此还是使用各Linux发行版自己的安装方式较好。Ubuntu下就用apt-get。如果需要PostGIS,可以先查找合适的deb包,再安装,查找方式:

然后psql到目标数据库下,用Create Extension的方式增加postgis的扩展:

1.2.2 支持GDB的安装

言归正传,ESRI一如既往地自己实现了一套geometry操作,不会选择依赖postgis,并在安装server时把这些东西拷贝到了安装目录里,具体路径是:

当然,windows或其他pg版本也可以在此找到,目前为止最新支持到pg9.4。注意,一定要拷贝这个文件夹里的st_geometry.so文件到pg的lib目录下,这个目录会被存在一个叫PKGLIBDIR的变量中(登录postgres的db账户后输入pg_config可以查看所有的变量)。比如我的目录是:

1.3 安装ArcGIS Server

首先,吐槽一下ESRI,刚开始看ArcGIS Server 10.4 for Linux的iso文件中有单独的for linux版的license manager,于是手贱安装了一把,发现其实没有任何用处,ESRI打包和发布软件的是实习生么难道?其实只需要关注ArcGIS_for_Server_Linux_xx….tar.gz这一个包即可(如下图)。剩下的就是解压和安装,这个暂且不谈,后面有需要再写。

installer

其次,表扬一下ESRI,10.4中默认的manager和rest服务路径已跳转为https,终于有改进。例如:

2 权限配置

如果要使用ArcGIS创建Geodatabase, pg的用户名必须是sde(ESRI一向如此无礼),这个用户不是单单需要login和createdb之类权限即可,而必须是超级用户:

否则Enable Geodatabase的时候会报这个错误:

_SFQX5E9ZGRMQ$@M9M60D0D

如果查下ESRI的官方文档,有这么句话:

如果使用的是 PostgreSQL,该值必须为 sde。如果 sde 登录角色不存在,此工具将创建 sde 登录角色并授予其超级用户状态。同时还会在数据库中创建 sde 方案。如果 sde 登录角色已存在,当其没有超级用户状态时,此工具将对其授予这一状态。

这个值指的是gdb_admin_name,用于创建GDB的PG用户。

So far so good ! 先写这些吧。

90 thoughts on “Ubuntu下ArcGIS Server 10.4与PostgreSQL 9.4的完美CP

  1. […] ArcGIS 10.4.x开始直接支持PostGIS Geometry,而无需再单独拷贝st_geometry,以及使用sde账户等等繁琐的事情(一如当年支持Oracle Spaitial和SQL Server Spatial)。这无疑是很大利好,PostGIS的功能、函数和增长性、活跃程度上,也不是sde所能媲美的。sde的方式可查看之前写的这篇博文。 […]

  2. beiou说道:

    从哪里能搞到ArcGIS Server 10.4 for Linux

  3. mobsex.mobi说道:

    Hi theгe, the whole thing is going fine here and ofcourse every oone is
    shɑring іnformation, that’ѕ truly good, keep up writing.

  4. WONDERFUL Post.thanks for share..extra wait .. …

  5. Listed here are the principle characteristics your cat is trying
    to find in a very good cat scratching submit.

  6. I simply want to say I am just new to blogging and site-building and really savored you’re web-site. More than likely I’m likely to bookmark your website . You amazingly have fabulous stories. Kudos for sharing with us your blog.

  7. I have been exploring for a bit for any high-quality articles or blog
    posts on this sort of area . Exploring in Yahoo I eventually stumbled upon this web site.
    Reading this info So i am glad to express
    that I have a very good uncanny feeling I came upon just what I needed.
    I most for sure will make sure to do not overlook this web site and give it a glance on a continuing basis.

  8. kumahasiaweh说道:

    Hi there, I discovered your blog by way of Google at the same time as looking for a comparable subject, your website got here up, it seems great. I have bookmarked it in my google bookmarks.

  9. Metroclick.Com;说道:

    MetroClick specializes in building completely interactive products like Photo Booth for rental or sale, Touch Screen Kiosks and Digital Signage, and experiences. With our own hardware production facility and in-house software development teams, we are able to achieve the highest level of customization and versatility for Photo Booths, Touch Screen Kiosks and Digital Signage. MetroClick, 121 Varick St, #301, New York, NY 10013, +1 646-843-0888

  10. Faytech North America is a touch screen Manufacturer of both monitors and pcs. They specialize in the design, development, manufacturing and marketing of Capacitive touch screen, Resistive touch screen, Industrial touch screen, IP65 touch screen, touchscreen monitors and integrated touchscreen PCs. Contact them at http://www.faytech.us, 121 Varick Street,3rd Floor,New York, NY 10013,+1 646 205 3214

  11. What i do not realize is in fact how you are no longer really a lot more smartly-preferred than you might be now. You are so intelligent. You already know thus significantly relating to this subject, produced me in my opinion imagine it from numerous various angles. Its like women and men are not interested except it’s one thing to accomplish with Lady gaga! Your individual stuffs excellent. At all times care for it up!

  12. Absolute motivating knowledge you have said, a big heads up for adding.

  13. see post说道:

    It can be near not possible to encounter well-qualified women and men on this theme, yet somehow you appear like you comprehend what exactly you’re revealing! Cheers

  14. dentysta gorzów说道:

    Fantastic goods from you, man. I have understand your stuff previous to and you are just too fantastic. I really like what you’ve acquired here, certainly like what you are stating and the way in which you say it. You make it entertaining and you still take care of to keep it wise. I can not wait to read much more from you. This is actually a terrific website.

  15. Someone essentially lend a hand to make critically articles I would state. That is the first time I frequented your website page and up to now? I amazed with the analysis you made to make this actual publish incredible. Magnificent task!

  16. dentysta gorzów说道:

    We are a group of volunteers and opening a new scheme in our community. Your web site offered us with valuable information to work on. You have done a formidable job and our entire community will be grateful to you.

  17. I have recently started a blog, the information you provide on this website has helped me tremendously. Thanks for all of your time & work.

  18. snapchat spy说道:

    Hello there! This article could not be written any better! Reading through this post reminds me of my previous roommate! He constantly kept preaching about this. I will forward this post to him. Pretty sure he’s going to have a good read. Many thanks for sharing!

  19. Highly stimulating data you have stated, thank you so much for putting up.

  20. I like what you guys are up too. Such clever work and reporting! Keep up the excellent works guys I’ve incorporated you guys to my blogroll. I think it’ll improve the value of my website :).

  21. sites说道:

    I really want to notify you that I am new to putting up a blog and certainly loved your article. Very likely I am most likely to bookmark your blog post . You undoubtedly have excellent article materials. Admire it for expressing with us the best internet page

  22. redirected here说道:

    It is perfect opportunity to prepare some desires for the near future. I have scan this piece of writing and if I could, I wish to suggest you few unique pointers.

  23. dentysta gorzów说道:

    Awesome Post: BLOGURL. You do a excellent job. Thanks again. NAME

  24. What’s up, I log on to your new stuff on a regular basis. Your story-telling style is awesome, keep up the good work!

  25. Some really good info , Sword lily I discovered this. “Civilization is a transient sickness.” by Robinson Jeffers.

  26. Enjoyed examining this, very good stuff, appreciate it. “A man does not die of love or his liver or even of old age he dies of being a man.” by Percival Arland Ussher.

  27. Thanks for the sensible critique. Me & my neighbor were just preparing to do some research on this. We got a grab a book from our local library but I think I learned more clear from this post. I am very glad to see such excellent info being shared freely out there.

  28. Some really wonderful information, Sword lily I found this. “A poem is never finished, only abandoned.” by Paul Valery.

  29. Someone essentially assist to make significantly articles I might state. That is the first time I frequented your web page and thus far? I surprised with the analysis you made to make this actual put up incredible. Great process!

  30. I have been browsing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. Personally, if all website owners and bloggers made good content as you did, the web will be a lot more useful than ever before.

  31. Only wanna state that this is extremely helpful, Thanks for taking your time to write this.

  32. I have recently started a website, the information you offer on this website has helped me greatly. Thank you for all of your time & work.

  33. biocentro.cl说道:

    Cursos masajes para toda la gente de todas las edades.

  34. you are in point of fact a excellent webmaster. The website loading pace is incredible. It kind of feels that you’re doing any distinctive trick. Moreover, The contents are masterpiece. you have performed a great activity on this topic!

  35. Emeryeps.com说道:

    Emeryeps is a SEO(Search Engine optimzation) and Internet Marketing company. They help businesses to get traffic from various search engine and online community. They have seo experts and consultants with many years of SEO Experiences. No matter where your business is located, EmeryEPS.com can help your business to secure your highly convertible leads online.

  36. Heya i am for the first time here. I found this board and I find It truly useful & it helped me out much. I hope to give something back and help others like you aided me.

  37. useful link说道:

    I merely intend to share it with you that I am new to putting up a blog and completely enjoyed your report. Most likely I am probably to save your blog post . You seriously have extraordinary article materials. Appreciate it for discussing with us the best website page

  38. It is actually a nice and useful piece of information. I am glad that you simply shared this helpful information with us. Please keep us informed like this. Thank you for sharing.

  39. Hiya, I’m really glad I’ve found this info. Today bloggers publish just about gossips and net and this is actually frustrating. A good site with interesting content, this is what I need. Thank you for keeping this site, I will be visiting it. Do you do newsletters? Can not find it.

  40. It is really a nice and useful piece of information. I am happy that you simply shared this helpful information with us. Please stay us up to date like this. Thanks for sharing.

  41. Good site! I really love how it is easy on my eyes and the data are well written. I am wondering how I could be notified whenever a new post has been made. I’ve subscribed to your feed which must do the trick! Have a great day!

  42. Travel & Leisure说道:

    Hello. excellent job. I did not anticipate this. This is a excellent story. Thanks!

  43. Automotive说道:

    Simply wish to say your article is as surprising. The clarity in your post is simply excellent and i can assume you’re an expert on this subject. Well with your permission allow me to grab your feed to keep updated with forthcoming post. Thanks a million and please keep up the enjoyable work.

  44. Thanks, will check back BLOGURL rapidly, have bookmarked you right now. NAME

  45. dentysta gorzów说道:

    Hello there, simply turned into cognizant of BLOGURL thru Search engine, and found that the chances of informative. I? m gonna watch away for brussels. I will appreciate any time you continue this in future. A lot of people will be benefited from a writing. Cheers! NAME

  46. this website说道:

    MichaelJemery.com is a site with many hypnosis downloads. Whether you are looking for free hypnosis downloads, self hypnosis download for mp3, video and any audio files, Michael Jemery has the downloads for you. You can download hypnosis from apps, audio, mp3 and even youtube !

  47. I savor, cause I discovered just what I was taking a look for. You have ended my 4 day lengthy hunt! God Bless you man. Have a great day. Bye

  48. Wow, incredible weblog layout! How lengthy have you been blogging for? you make running a blog glance easy. The overall glance of your website is wonderful, let alone the content material!

  49. Only wanna admit that this is invaluable , Thanks for taking your time to write this.

  50. Good site! I really love how it is easy on my eyes and the data are well written. I’m wondering how I could be notified when a new post has been made. I’ve subscribed to your feed which must do the trick! Have a nice day!

  51. Enjoyed reading this, very good stuff, regards . “Whenever you want to marry someone, go have lunch with his ex-wife.” by Francis William Bourdillon.

  52. I regard something really interesting about your web blog so I saved to bookmarks .

  53. Wow, marvelous blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your web site is great, let alone the content!

  54. I believe you have remarked some very interesting points , thanks for the post.

  55. I like this site very much, Its a very nice berth to read and find information. “Misogynist A man who hates women as much as women hate one another.” by H.L. Mencken.

  56. I do not even know how I ended up here, but I thought this post was good. I do not know who you are but definitely you’re going to a famous blogger if you aren’t already 😉 Cheers!

  57. Hi my friend! I want to say that this article is awesome, nice written and include approximately all vital infos. I would like to peer more posts like this.

  58. You have brought up a very fantastic details , regards for the post.

  59. I think this site contains some real wonderful info for everyone :D. “Do not go where the path may lead, go instead where there is no path and leave a trail.” by Ralph Waldo Emerson.

  60. Hey, you used to write fantastic, but the last few posts have been kinda boring… I miss your super writings. Past few posts are just a little out of track! come on!

  61. Howdy! This post could not be written much better! Reading through this post reminds me of my previous roommate! He continually kept preaching about this. I’ll send this information to him. Pretty sure he’ll have a great read. Thank you for sharing!

  62. Amazing! This blog looks just like my old one! It’s on a entirely different subject but it has pretty much the same layout and design. Excellent choice of colors!

  63. Dead written subject matter, Really enjoyed reading.

  64. What i don’t understood is in truth how you’re not actually much more smartly-appreciated than you might be now. You are very intelligent. You already know thus significantly when it comes to this subject, produced me individually imagine it from so many numerous angles. Its like women and men aren’t involved except it is something to accomplish with Woman gaga! Your own stuffs great. Always maintain it up!

  65. F*ckin’ tremendous issues here. I’m very satisfied to see your post. Thank you so much and i am looking forward to touch you. Will you please drop me a e-mail?

  66. Keep up the good piece of work, I read few blog posts on this site and I believe that your site is real interesting and contains sets of fantastic info .

  67. I really appreciate this post. I have been looking all over for this! Thank goodness I found it on Bing. You have made my day! Thanks again!

  68. dentysta gorzów说道:

    Hi would you mind letting me know which webhost you’re working with? I’ve loaded your blog in 3 completely different web browsers and I must say this blog loads a lot quicker then most. Can you suggest a good hosting provider at a reasonable price? Many thanks, I appreciate it!

  69. toyota axio 2017说道:

    Hi, I do think this is a great blog. I stumbledupon it 😉 I am going to come back yet again since i have saved as a favorite it. Money and freedom is the best way to change, may you be rich and continue to help other people.

  70. F*ckin’ tremendous issues here. I am very satisfied to look your article. Thank you a lot and i’m taking a look ahead to contact you. Will you kindly drop me a mail?

  71. My developer is trying to convince me to move to .net from PHP. I have always disliked the idea because of the costs. But he’s tryiong none the less. I’ve been using Movable-type on a number of websites for about a year and am nervous about switching to another platform. I have heard great things about blogengine.net. Is there a way I can import all my wordpress posts into it? Any kind of help would be greatly appreciated!

  72. Hello, its fastidious piece of writing on the topic of media print,
    we all be familiar with media is a enormous source of data.

  73. suba me说道:

    uMSd9h Im thankful for the blog.Really thank you! Awesome.

  74. Does your website have a contact page? I’m having problems locating it but, I’d like to shoot you an e-mail. I’ve got some suggestions for your blog you might be interested in hearing. Either way, great blog and I look forward to seeing it grow over time.

  75. Honda Car USA说道:

    I like what you guys tend to be up too. This type of clever work and coverage! Keep up the wonderful works guys I’ve included you guys to my own blogroll.

  76. Home Improvement说道:

    Hey There. I found your blog using msn. This is a very well written article. I’ll make sure to bookmark it and return to read more of your useful information. Thanks for the post. I will certainly comeback.

  77. Hey there! I know this is somewhat off topic but I was wondering if you
    knew where I could get a captcha plugin for my comment
    form? I’m using the same blog platform as yours and I’m having problems finding one?
    Thanks a lot!

  78. Health说道:

    Definitely believe that which you said. Your favorite justification appeared to be on the web the easiest thing to be aware of. I say to you, I definitely get irked while people think about worries that they plainly don’t know about. You managed to hit the nail upon the top as well as defined out the whole thing without having side effect , people can take a signal. Will probably be back to get more. Thanks

  79. Business说道:

    Hi my friend! I wish to say that this post is amazing, great written and come with almost all significant infos. I’d like to peer extra posts like this.

  80. Women说道:

    You could certainly see your expertise in the work you write. The sector hopes for more passionate writers like you who are not afraid to say how they believe. At all times go after your heart. “Everyone has his day and some days last longer than others.” by Sir Winston Leonard Spenser Churchill.

  81. Career And Jobs说道:

    As soon as I observed this website I went on reddit to share some of the love with them.

  82. I truly appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You have made my day! Thanks again!

  83. Some really fantastic content on this website , thankyou for contribution.

  84. Fashion说道:

    Merely wanna remark that you have a very decent internet site , I the pattern it actually stands out.

  85. Technology说道:

    Good – I should certainly pronounce, impressed with your site. I had no trouble navigating through all the tabs as well as related information ended up being truly easy to do to access. I recently found what I hoped for before you know it in the least. Quite unusual. Is likely to appreciate it for those who add forums or something, site theme . a tones way for your customer to communicate. Nice task.

  86. Enjoyed looking through this, very good stuff, thanks . “A man may learn wisdom even from a foe.” by Aristophanes.

  87. Does your blog have a contact page? I’m having trouble locating it but, I’d like to send you an email. I’ve got some creative ideas for your blog you might be interested in hearing. Either way, great website and I look forward to seeing it develop over time.

  88. Jewelry说道:

    Simply want to say your article is as astonishing. The clearness in your post is simply cool and i could assume you are an expert on this subject. Well with your permission allow me to grab your feed to keep up to date with forthcoming post. Thanks a million and please carry on the enjoyable work.

  89. Very interesting points you have remarked, regards for posting . “Ignorance, the root and the stem of every evil.” by Plato.

发表评论

电子邮件地址不会被公开。