Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

I am new in mac os. I was trying to install Postgresql. Before i did not know there is a Postgresql already available with default installation. So, I downloaded Postgresql 8.4 and installed it. I changed the configuration as the instruction.

[sudo vi /etc/sysctl.conf]

kern.sysv.shmmax=33554432
kern.sysv.shmmin=1
kern.sysv.shmmni=256
kern.sysv.shmseg=64
kern.sysv.shmall=8192
  1. I changed kern.sysv.shmall=33554432 and saved it. Then whenever I installed the postgresql 8.4 it shows an error. Now I do not know is it already installed or not? How can I check it?

  2. After that, I found some command and execute those. But I do not know how to fix it?

    Shahjalals-MacBook-Pro:~ shahjalal$ which psql /usr/bin/psql

    Shahjalals-MacBook-Pro:~ shahjalal$ psql dyld: Library not loaded: /usr/lib/libpq.5.dylib Referenced from: /usr/bin/psql Reason: no suitable image found. Did find: /usr/lib/libpq.5.dylib: no matching architecture in universal wrapper /usr/lib/libpq.5.dylib: no matching architecture in universal wrapper Trace/BPT trap: 5

    Shahjalals-MacBook-Pro:~ shahjalal$

  3. Is there any gui interface to access postgresql? If Yes then how can i access it? I have a plan to install Postgis and PgRouting package in my PostgreSQL for one of my project.

share|improve this question
    
You're probably going to want to reinstall Lion to ensure you get the stock version back, otherwise start removing all the remnants of both versions and install 8.4 again. In the future, use something like Homebrew or MacPorts to install generic packages into a safe location. That way if anything goes wrong, you can remove it without affecting the base OS installation. –  EmmEff Feb 20 '12 at 2:33
add comment

2 Answers

To avoid all those heartaches, you might want to check out Postgres.app. Just copy to the Applications folder and you're done. From the Github page:

Postgres.app is the easiest way to get started with PostgreSQL on the Mac. Open the app, and you have a PostgreSQL server ready and awaiting new connections. Close the app, and the server shuts down.

As for the client, check out Navicat. Good luck!

share|improve this answer
    
That is really neat! Great idea for testing. –  Cathy Aug 7 '12 at 0:57
add comment

First up, what's the error you're getting, and how are you getting it? Are you trying to re-run the installer?

In answer to two, take a look at http://www.jonathandean.com/2011/08/postgresql-8-4-on-mac-os-x-10-7-lion/ who seems to have gotten it sorted.

There absolutely is a GUI for PostgreSQL, it's called pgAdmin 3 (or pgAdmin III). If you successfully installed the OS X version of PostgreSQL from their site, then you should already have it (take a peek in Launchpad). If it's not there, you can get it at http://www.pgadmin.org/ but read the downloads page carefully---it isn't well sorted and the most up-to-date version is in the middle of the list.

As EmmEff said, in future Homebrew or MacPorts might be easier (especially if you like playing around!) since you can wipe the install cleanly.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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