raprasad/postres_restart.md

Last active January 19, 2017 18:15

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/raprasad/98c790d46fedbbdd947fc73bb53ca737.js"></script>
Save raprasad/98c790d46fedbbdd947fc73bb53ca737 to your computer and use it in GitHub Desktop.

Download ZIP

local postgres restart / can't connect to local postgres

Raw

postres_restart.md

when postgres in a bad state

remove lock file and reset transaction log

rm /usr/local/var/postgres/postmaster.pid
pg_resetxlog -f /usr/local/var/postgres

source: http://www.brentmc79.com/posts/psql-could-not-connect-oh-fuck-you

start/stop

start:

pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

stop:

pg_ctl -D /usr/local/var/postgres stop -s -m fast

source: http://stackoverflow.com/questions/7975556/how-to-start-postgresql-server-on-mac-os-x

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment