What am I missing? I've installed the postgresql82 and postgresql82-server ports, and I can see the following in my process list: /bin/daemondo --label=postgresql82-server --start-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql82-server/postgresql82- server.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql82-server/postgresql82- server.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql82-server/postgresql82- server.wrapper restart ; --pid=none but when I try to start psql82 I see this: psql82: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? Is there some other step I've missed that will get postgres to start? Thanks, Brad -- Brad Miller Assistant Professor, Computer Science Luther College
On Aug 16, 2007, at 7:16 PM, Brad Miller wrote:
Is there some other step I've missed that will get postgres to start?
Did you also follow the instructions the postgresql82-server port printed? To create a database instance, after install do sudo mkdir -p /opt/local/var/db/postgresql82/defaultdb sudo chown postgres:postgres /opt/local/var/db/postgresql82/defaultdb sudo su postgres -c '/opt/local/lib/postgresql82/bin/initdb -D /opt/ local/var/db/postgresql82/defaultdb' To tweak your DBMS, consider increasing kern.sysv.shmmax by adding an increased kern.sysv.shmmax .. to /etc/sysctl.conf -- Daniel J. Luke +========================================================+ | *---------------- dluke@geeklair.net ----------------* | | *-------------- http://www.geeklair.net -------------* | +========================================================+ | Opinions expressed are mine and do not necessarily | | reflect the opinions of my employer. | +========================================================+
participants (2)
-
Brad Miller
-
Daniel J. Luke