Edit Question - KnowledgeHub

Title Body

I'm having an issue with my install of postgres in my development environment and I need some help diagnosing it. I haven't yet had any luck in tracking down a solution. I have postgres 9.0.4 installed with homebrew I am running on OS X 10.6.8 (Snow Leopard) I can start and stop the server $ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start server starting If I try to stop though $ pg_ctl -D /usr/local/var/postgres stop -s -m fast pg_ctl: PID file "/usr/local/var/postgres/postmaster.pid" does not exist Is server running? Ok this is missing $ ls -l /usr/local/var/postgres/ | grep postmaster $ But it is definitely running $ ps aux | grep postgres pschmitz 303 0.9 0.0 2445860 1428 ?? Ss 3:12PM 0:02.46 postgres: autovacuum launcher process pschmitz 304 0.9 0.0 2441760 428 ?? Ss 3:12PM 0:02.57 postgres: stats collector process pschmitz 302 0.0 0.0 2445728 508 ?? Ss 3:12PM 0:00.56 postgres: wal writer process pschmitz 301 0.0 0.0 2445728 560 ?? Ss 3:12PM 0:00.78 postgres: writer process pschmitz 227 0.0 0.1 2445728 2432 ?? S 3:11PM 0:00.42 /usr/local/Cellar/postgresql/9.0.3/bin/postgres -D /usr/local/var/postgres -r /usr/local/var/postgres/server.log And if I try to access or use it I get this. $psql psql: FATAL: could not open relation mapping file "global/pg_filenode.map": No such file or directory But global/pg_filenode.map definitely exists in $ls -l /usr/local/var/postgres/ ... -rw------- 1 pschmitz staff 8192 Sep 16 15:48 pg_control -rw------- 1 pschmitz staff 512 Sep 16 15:48 pg_filenode.map -rw------- 1 pschmitz staff 12092 Sep 16 15:48 pg_internal.init I have attemp

Tags (comma-separated) Cancel