Skip to content

Instantly share code, notes, and snippets.

@RoryKelly
Last active March 27, 2019 13:12
Show Gist options
  • Save RoryKelly/719a49e66eefaf9638b9ce94661d75fb to your computer and use it in GitHub Desktop.
Save RoryKelly/719a49e66eefaf9638b9ce94661d75fb to your computer and use it in GitHub Desktop.
install new version as seperate cluster
https://www.postgresql.org/download/windows/
stop both servers
- find the data dir
postgres=# show data_directory; data_directory
- use pg_ctrl to stop both clusters
pg_ctl -D "data dir" stop -m fast
http://blog.shernshiou.com/upgrading-from-postgresql-9-1-to-9-3/
I solved it by changing both pg_hba.conf (9.1 and 9.3) to use no password.
local all postgres trust
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment