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
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?
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
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.