January 30, 2015 · postgresql

PostgreSQL 8.4 dump to PostgreSQL9.1 restore

PostgreSQL 8.4 dump:

root@virt2005:~# /opt/PostgreSQL/8.4/bin/pg_dump lanser_sapns -U postgres -p 5433 > lanser_sapns_20140112.backup  

PostgreSQL 9.1 restore:

psql -d lanser_sapns -U postgres -f lanser_sapns_20140112.sql  
  • LinkedIn
  • Tumblr
  • Reddit
  • Google+
  • Pinterest
  • Pocket
Comments powered by Disqus