How to transfer data from tables in postgres 9.4 to 9.5?

Maybe someone faced with the fact that if you are upgrading from 9.4 to 9.5 database is not running. Unfortunately, the error can not provide, since rolled back to 9.4
July 9th 19 at 10:56
1 answer
July 9th 19 at 10:58
Solution
what was updated? at the time, upgraded from 9.3 to 9.4, 9.5 to still hands did not reach, but I suspect that similarly

commands on AP from 9.3 to 9.4, do not forget about backups ;)
pg_dropcluster 9.4 main --stop
pg_upgradecluster 9.3 main
and what should backups be done? - marian.Hagenes commented on July 9th 19 at 11:01
: Different ways to eat, for example, using pg_dump. With this update it is not required, but always there is the likelihood that something will go wrong. - Garnett_Deckow commented on July 9th 19 at 11:04
: it seems pg_upgradecluster for Linux systems. Unfortunately, I have Windows. - marian.Hagenes commented on July 9th 19 at 11:07
: I found one. Seemingly, it is necessary to smoke manuals for pg_upgrade. Thanks for the push ) - marian.Hagenes commented on July 9th 19 at 11:10

Find more questions by tags SQLPostgreSQL