![]() ![]() We’ll use Homebrew to install the required packages, so make sure you have Homebrew installed on your system. In this tutorial, we will see how to install PostGIS on Mac OS X. It is at the core of CartoDB and plays nicely with QGIS, Tilemill / Mapbox Studio and GDAL. PostGIS can handle large amounts of data. PostgreSQL was most likely installed via Homebrew, Fink, MacPorts or the EnterpriseDB installer.PostGISis a powerful extension to the PostgreSQL database that adds support for geometry types and geospatial functions such as point, line, polygon, distance, area, union, intersection, etc. Make sure tcp localhost connections are enabled in pg_hba.conf: # IPv4 local connections:Ĭheck the listen_addresses and port in nf:Įgrep 'listen|port' /usr/local/var/postgres/nf #listen_addresses = 'localhost' # What IP address(es) to listen on What is the result of pg_ctl -D /usr/local/var/postgres status?Īre there any error messages in the server.log? What is the result of pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start? "To have launchd start postgresql now and restart at login:" Pg_ctl -D /usr/local/var/postgres stop Start automatically ![]() Pg_ctl -D /usr/local/var/postgres start Stop manually For more information, run brew info postgres. The Homebrew package manager includes launchctl plists to start automatically. I am still getting the same "Is the server running?" message. > cp /usr/share/postgresql/ /usr/share/postgresql/nf So I tried this: > cp /usr/local/Cellar/postgresql/9.0.4/share/postgresql/ /usr/local/Cellar/postgresql/9.0.4/share/postgresql/nf #listen_addresses = 'localhost' # what IP address(es) to listen on So I did this: egrep 'listen|port' /usr/local/Cellar/postgresql/9.0.4/share/postgresql/ usr/local/Cellar/postgresql/9.0.4/share/postgresql/ ![]() Though, I did do this: >sudo find / -name "*nf*" This seems odd: > egrep 'listen|port' /usr/local/var/postgres/nfĮgrep: /usr/local/var/postgres/nf: No such file or directory Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process. Update 5: sudo pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start > pg_ctl -D /usr/local/var/postgres status Here are the contents: # IPv4 local connections:īut I don't understand this: > pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start I found that there wasn't any pg_hba.conf file (only file pg_), so I modified the sample and renamed it (to remover the. Update 3: > pg_ctl -D /usr/local/var/postgres status Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? The touch was not successful, so I did this instead: > mkdir /usr/local/var/postgresīut when I try to start the Ruby on Rails server, I still see this: Sh: /usr/local/var/postgres/server.log: No such file or directory Update: > pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start I see that postgres is not running > ps auxwww | grep postgres ![]() I had forgotten to run the initdb command.īy running this command ps auxwww | grep postgres ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |