ruby on rails - Postgres server not starting after unexpected Yosemite shutdown -

-

i'm trying start rails server i'm getting error...

/users/kweihe/.rvm/gems/ruby-2.1.6/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:1222:in `initialize': not connect server: connection refused (pg::connectionbad)     server running on host "localhost" (::1) , accepting     tcp/ip connections on port 5432? not connect server: connection refused     server running on host "localhost" (127.0.0.1) , accepting     tcp/ip connections on port 5432?

if check postgres server processes ...

kweihe-mac:pmpaware-webapp kweihe$ ps auxw | grep postgres kweihe          11687   0.0  0.0  2432772    636 s000  s+   10:56am   0:00.00 grep postgres

so i've tried following ...

kweihe-mac:pmpaware-webapp kweihe$  rm -rf /usr/local/var/postgres kweihe-mac:pmpaware-webapp kweihe$ initdb /usr/local/var/postgres  files belonging database system owned user "kweihe". user must own server process.  database cluster initialized locale "en_us.utf-8". default database encoding has accordingly been set "utf8". default text search configuration set "english".  data page checksums disabled.  fixing permissions on existing directory /usr/local/var/postgres ... initdb: not change permissions of directory "/usr/local/var/postgres": operation not permitted kweihe-mac:pmpaware-webapp kweihe$ chmod 0700 /usr/local/var/postgres chmod: unable change file mode on /usr/local/var/postgres: operation not permitted

so checked permissions ...

kweihe-mac:pmpaware-webapp kweihe$ cd /usr/local/var/ kweihe-mac:var kweihe$ ls -l total 0 drwxr--r--  2 root  admin  68 jul 22 10:59 postgres kweihe-mac:var kweihe$

and tried enable permissions ...

kweihe-mac:var kweihe$ chmod 777 postgres chmod: unable change file mode on postgres: operation not permitted

so got there ... 

kweihe-mac:pmpaware-webapp kweihe$ rm -rf /usr/local/var/postgres kweihe-mac:pmpaware-webapp kweihe$ initdb /usr/local/var/postgres -e utf8 files belonging database system owned user "kweihe". user must own server process.  database cluster initialized locale "en_us.utf-8". default text search configuration set "english".  data page checksums disabled.  creating directory /usr/local/var/postgres ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128mb selecting dynamic shared memory implementation ... posix creating configuration files ... ok creating template1 database in /usr/local/var/postgres/base/1 ... ok initializing pg_authid ... ok initializing dependencies ... ok creating system views ... ok loading system objects' descriptions ... ok creating collations ... ok creating conversions ... ok creating dictionaries ... ok setting privileges on built-in objects ... ok creating information schema ... fatal:  lock file "postmaster.pid" exists hint:  postmaster (pid 11413) running in data directory "/usr/local/var/postgres"? child process exited exit code 1 initdb: removing data directory "/usr/local/var/postgres" not remove file or directory "/usr/local/var/postgres": directory not empty initdb: failed remove data directory

looks problem running launchctl process depends on /usr/local/var/postgres. in case, thesolution stop

launchctl unload ~/library/launchagents/homebrew.mxcl.postgresql.plist

finish off (removing directory in case partially created before)

rm -rf /usr/local/var/postgres initdb /usr/local/var/postgres

Comments

Post a Comment

Popular posts from this blog

Fail to load namespace Spring Security http://www.springframework.org/security/tags -

-
i have problem namespace of spring security on xhtml page. don't understand why can't load uri, , have following issue: whitelabel error page application has no explicit mapping /error, seeing fallback. tue jul 21 16:58:12 utc 2015 there unexpected error (type=not found, status=404). please need help! possible uri has been changed? best regards you using incorrect namespace url. correct url http://www.springframework.org/schema/security the error page seeing spring source website since not recognize url. try visiting http://www.springsource.org/security/tags in browser update : spring security tags used in jsp page correct tag lib declaration is: <%@ taglib prefix="sec" uri="http://www.springframework.org/security/tags" %>
Read more

sql - MySQL query optimization using coalesce -

-
can explain me why second query faster first? (first 1 takes around 40 seconds, second 1 less 0.1) select releases.feature_code, releases.platform_id, version, release_date, general_available, uri, filesize, display_name, feature_name.full_name, if ((select exists(select 1 release_exceptions releases.feature_code = release_exceptions.feature_code , releases.platform_id = release_exceptions.platform_id , releases.version = release_exceptions.version) = 1), 1, 0) release_exceptions releases left outer join platform using(platform_id) left outer join feature_name using(feature_code) order version desc; ~~~ query 2 ------------------ ~~~ select feature_code, version, release_date, general_available, platform_id, uri, filesize, display_name, feature_name.full_name, coalesce(release_exceptions, 0) release_exceptions mus.releases left outer join ( select distinct feature_code, version, platform_id, 1 release_exceptions mus.release_exceptions ) release_exceptions using ...
Read more

unity3d - Unity local avoidance in user created world -

-
i'm using unity3d networked multiplayer online game have large complex 3d terrain scene forest, trees, cliff, hills, mountains, bounders, etc. players can build structures sort of minecraft, , put them anywhere in scene, or move them around anytime. aside human controlled players, there automated ai players , objects animals roaming around scene following path. the problem how make these automated ai players , animals, able navigate around static , dynamic player created structures, because path follow can blocked player created structures, or other players , other ai objects, cliffs etc. have find away around them or on track if tumble down off high cliff example. so made navmesh , used navagents, takes care of static, non moving objects, how make ai players navigate around each other , dynamic structures created players can number in hundreds? i thought of adding navmeshobstacle everything, result in being attached hundreds of objects since user created structures b...
Read more