![]() In the last article, I showed you how to install Nginx and PHP (PHP-FPM) on CentOS 6 from source. Today, I’m going to show you how to install Nginx with PHP-FPM via yum. Before starting to install Nginx and PHP-FPM, you must. # yum -y install postgresql.x86_64 2. Uninstall a package using yum remove. To remove a package (along with all its dependencies), use ‘yum remove package’ as shown below. # yum remove postgresql.x86_64 Resolving. I need Apache 2.4 in CentOS because with Apache 2.2 mod_proxy_wstunnel is not possible. I have tried this, but unfortunately its for RHEL. After installing, I can't execute the Apache 2.4. Can anyone show me how to install a. ![]() An almost idiot's guide to install Postgre. SQL 9. 5, Post. GIS 2. Routing 2. 1. 0 with Yum. Installing Postgre. SQL 9. 5 from Yum repository. The list of latest Postgre. SQL versions and repos for Fedora 2. Red Hat 5- 7, Cent. OS 6- 7, Oracle EL Linux 6- 7, and Scientific Linux 5- 7, Amazon Linux AMI are located at http: //yum. Note: PostGIS 2.1.2 release is eminent, so you might want to wait till we release and Yum is updated before you install/upgrade. The major differences between YUM and RPM are that yum knows how to resolve dependencies and can source these additional packages when doing its work. Though rpm can alert you to these dependencies, it is unable to source. When installing packages for the first time, setup*.exe does not install every package. Only the minimal base packages from the Cygwin distribution are installed by default, which takes up about 100 MB. Clicking on categories. If you already have a working PostgreSQL 9.5 install, and just want to skip to relevant sections, follow this list: Installing PostGIS binaries; Installing pgRouting binaries; Installing ogrfdw binaries; As a general note. ![]() Figure out which OS you are on. Note the PGDG repository 9. First run uname - a. Mine happens to return: Linux centos. SMP Tue Jan 5 1. 6: 0. UTC 2. 01. 6 x. 86_6. GNU/Linux so I know its a 6. X8. 6_6. 4 at the end. Mine returns: Cent. OS Linux release 7. Core)Install the right rpms from http: //yum. In our case: On my Cent. OS 7 ran: sudo rpm - ivh http: //yum. To see all packages from pgdg. CGAL. x. 86_6. 4 4. CGAL- debuginfo. x. CGAL- demos- source. CGAL- devel. x. 86_6. SFCGAL. x. 86_6. 4 1. SFCGAL- debuginfo. SFCGAL- devel. x. SFCGAL- libs. x. 86_6. II- 9. 5. x. 86_6. II- 9. 5- debuginfo. II- 9. 5- devel. x. II- 9. 5- extensions. Admin. noarch 3. Pg. Admin. noarch 5. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. We usually install the below. The devel is optional but needed if you want to compile some other add- on later like non- packaged extensions. You should get a prompt something like. Dependencies Resolved. Package Arch Version Repository Size. PGDG. rhel. 7 pgdg. M. postgresql. 95- contrib x. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. M. postgresql. 95- libs x. PGDG. rhel. 7 pgdg. PGDG. rhel. 7 pgdg. M. Installing for dependencies. Transaction Summary. Install 5 Packages (+1 Dependent package). Total download size: 8. M. Installed size: 3. M. Is this ok [y/d/N]. Type: y. It should then download the packages and install them with a Complete! If you need to configure things the way you want to configure things. Skip this section if you just want to run with defaults and will only have one instance of Postgre. SQLIf you plan to run multiple versions of Postgre. SQL e. g. stable 9. The best way to do that is to edit/create a file in /etc/sysconfig/pgsql/postgresql- 9. Note that # are remarks to you so don't type them in. Click i to insert a line and start typing. I generally like to run on non- standard ports just to avoid. You also need to run on different ports if you have multiple instances running on same server. Note: PGDATA you don't need to add unless you are unhappy with the default location. My file when I am done will look something like this. PGPORT=5. 44. 0. PGDATA=/pgdata. Click Escape key followed by : w : q (: w saves the file and : q exits)Creating Postgre. SQL data cluster and starting the service. With the Yum setup each version of postgresql goes in its own separate folder, so you can easily have parallel installs of different. Postgre. SQL without worring about overriding the default data folder. I'll reiterate the key elements and consequences of these changes you need to watch out for. Changing password of system postgres account. Installing postgres creates a user account called postgres. If you want to change the password to something you know do this: sudo passwd postgres. You'll be prompted for a new password. Key Steps to setup. If you want the service to start up on reboot, then simply do this: su root. If you get an error: The service command supports only basic LSB actions (start, stop, restart, try- restart, reload, force- reload, status). For other actions, please try to use systemctl. Do/usr/pgsql- 9. 5/bin/postgresql. The data cluster is created by default in /var/lib/pgsql/9. To use psql, you can generally get away with just typing psql without the full path, but if you have multiple installations of Postgre. SQL, you're better off being explicit which one you want. For the rest of these exercises, we are going to assume you are just using the default ports etc. Installing adminpack. To install the adminpack useful for viewing logs and editing postgresql. Pg. Admin, don't forget to install the admin pack. CREATE EXTENSION adminpack; "Installing Post. GIS binaries. Post. GIS unfortunately has a lot of dependencies because of GDAL and JSON dependency introduced in 2. If still under postgres switch back to root with exit. It often is not. As with this virgin box we tried installing on we got these errors: . Finished Dependency Resolution. Error: Package: gdal- libs- 1. Requires: libdapclient. Error: Package: gdal- libs- 1. Requires: libdap. Error: Package: gdal- libs- 1. Requires: libspatialite. Error: Package: postgis. Requires: hdf. 5. Error: Package: gdal- libs- 1. Requires: libarmadillo. Error: Package: gdal- libs- 1. Requires: lib. Char. LS. so. 1()(6. 4bit). Error: Package: gdal- libs- 1. Requires: libgta. Error: Package: gdal- libs- 1. Requires: libgeotiff. Error: Package: gdal- libs- 1. Requires: libfreexl. Error: Package: gdal- libs- 1. Requires: libdapserver. Error: Package: gdal- libs- 1. Requires: libcfitsio. Error: Package: gdal- libs- 1. Requires: libnetcdf. Error: Package: gdal- libs- 1. Requires: libhdf. The issue is the dependency packages are not distributed with yum postgresql repo. Most of these are in the RHEL Extra Packages for Enterprise Linux (EPEL) repo. So if you get these errors. The master mirror are located at http: //dl. First try: yum - y install epel- release. If that doesn't work, you might have to find the explicit epel repo. For Cent. OS 6, RHEL 6 6. For Cent. OS 5, RHEL 5 6. Since we are on Cent. OS 6 6. 4- bit we went with the second set. You should get a screen that looks something like this if successful. Preparing.. ########################################### [1. Now we repeat the above command again: sudo yum install postgis. After the above, you should see a screen that looks like this: Dependencies Resolved. Package Arch Version Repository Size. M. Installing for dependencies. CGAL x. Char. LS x. SFCGAL x. SFCGAL- libs x. M. armadillo x. M. blas x. M. geos x. M. jasper- libs x. M. lcms. 2 x. ICE x. 86_6. SM x. 86_6. X1. 1 x. X1. 1- common noarch 1. Xau x. 86_6. Xdamage x. Xext x. 86_6. Xfixes x. Xxf. 86vm x. GL x. 86_6. GLU x. 86_6. M. proj x. ODBC x. 86_6. Transaction Summary. Install 1 Package (+5. Dependent packages). Total download size: 3. M. Installed size: 1. M. Is this ok [y/d/N]. Click y. After you might get an additional prompt to install more dependencies. Is this ok [y/d/N]. Type: y. After you are done you should have a screen like this: Installed. Complete! Note that after all this, you still need to enable Post. GIS in each database you will want to use it in. Refer to Enabling Extensions. The extension enabling is also pretty generic for all OS. Post. GIS Install http: //postgis. Installing ogrfdw binariesogr_fdw the spatial vector foreign data wrapper, is also available on yum. To install: yum install ogr_fdw. Loaded plugins: fastestmirror. Loading mirror speeds from cached hostfile. Resolving Dependencies. Running transaction check. Package ogr_fdw. 95. Finished Dependency Resolution. Dependencies Resolved. Package Arch Version Repository Size. Transaction Summary. Install 1 Package. Total download size: 2. Installed size: 5. Is this ok [y/d/N]: Type y. If successful, you should see. Loaded plugins: fastestmirror. Loading mirror speeds from cached hostfile. Resolving Dependencies. Running transaction check. Package ogr_fdw. 95. Finished Dependency Resolution. Dependencies Resolved. Package Arch Version Repository Size. Transaction Summary. Install 1 Package. Total download size: 2. Installed size: 5. Is this ok [y/d/N]: y. Downloading packages. B 0. 0: 0. 1. Running transaction check. Running transaction test. Transaction test succeeded. Running transaction. Installing : ogr_fdw. Verifying : ogr_fdw. Complete! Installing pg. Routing binariespg. Routing is a Postgre. SQL extension that extends Post. GIS for building Location Based Services (LBS) specifically for trip navigation and resource dispatch. It is the subject of our upcoming book pg. Routing: A practical guide due out later this year but will be. Early Preview hopefully within the next week. Note that since pg. Routing relies on Post. GIS for much of its functionality, you should have install Post. GIS first before attempting to install pg. Routing. To install: yum install pgrouting_9. You should see a screen like. Dependencies Resolved. Package Arch Version Repository Size. Transaction Summary. Install 1 Package. Total download size: 2. Installed size: 1. M. Is this ok [y/d/N]: Type: y to the prompt. You should see a screen like this. Downloading packages. B 0. 0: 0. 1. Running transaction check. Running transaction test. Transaction test succeeded. Running transaction. Installing : pgrouting_9. Verifying : pgrouting_9. Complete! Now refer to the section Enabling Extensions. Routing manual for pg. Routing 2. 1 at http: //docs. Enabling Extensions in a database. To install Post. GIS 2. Post. GIS 2. 2 you'd create a database and install the extensions. CREATE DATABASE gistest. Should give you message. You are now connected to database "gistest" as user "postgres". Next install the extensions. CREATE EXTENSION postgis. CREATE EXTENSION postgis_topology. CREATE EXTENSION ogr_fdw; To verify the install do: SELECT postgis_full_version(); You should get something like: postgis_full_version. POSTGIS="2. 2. 1 r. GEOS="3. 5. 0- CAPI- 1. PROJ="Rel. 4. 8. 0, 6 March 2. GDAL="GDAL 1. 1. 1. LIBXML="2. 9. 1" LIBJSON="0. TOPOLOGY RASTERIf the above output returns 2. Exit out psql\q. and run yum with: yum update postgis. Which should give you: Resolving Dependencies. Running transaction check.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2016
Categories |