{"id":54,"date":"2016-02-08T14:35:14","date_gmt":"2016-02-08T14:35:14","guid":{"rendered":"http:\/\/kloxo.web.id\/?p=54"},"modified":"2016-02-08T14:35:14","modified_gmt":"2016-02-08T14:35:14","slug":"dump-backup-dan-restore-database-spse","status":"publish","type":"post","link":"https:\/\/kloxo.web.id\/?p=54","title":{"rendered":"Dump \/ Backup dan Restore Database SPSE"},"content":{"rendered":"<p>untuk keperluan upgrade spse36 ke 36sp2 dan spse4, kadangkala diperlukan dump \/ backup database di server lama dan merestore nya kembali ke server baru, berikut step nya :<\/p>\n<p>1. di server lama yang menjalankan spse36 :<\/p>\n<p>su &#8211; postgres<\/p>\n<p>psql -l<br \/>\n(untuk keluar, gunakan :q, misal db yang akan dibackup = epns-latihan)<\/p>\n<p>pg_dump -U postgres epns-latihan -f epns-latihan.sql<br \/>\n(perhatikan folder\/direktory tempat .sql nya dibuat)<\/p>\n<p>copikan file epns-latihan.sql ke server baru yang menjalankan spse36sp2<\/p>\n<p>2. di server baru yang menjalankan spse36sp2\/spse4 :<\/p>\n<p>su &#8211; postgres<br \/>\npsql -l<\/p>\n<p>bila db belum ada, maka create terlebih dahulu :<\/p>\n<p>createdb -U postgres -O epns epns_latihan<\/p>\n<p>lalu import\/restore db nya :<\/p>\n<p>psql -U postgres -d epns-latihan -f epns-latihan.sql<\/p>\n<p>(perhatikan folder tempat meletakan epns-latihan.sql)<\/p>\n<p>D.W.Y.O.R<\/p>\n","protected":false},"excerpt":{"rendered":"<p>untuk keperluan upgrade spse36 ke 36sp2 dan spse4, kadangkala diperlukan dump \/ backup database di server lama dan merestore nya kembali ke server baru, berikut step nya : 1. di server lama yang menjalankan spse36 : su &#8211; postgres psql -l (untuk keluar, gunakan :q, misal db yang akan dibackup = epns-latihan) pg_dump -U postgres [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-54","post","type-post","status-publish","format-standard","hentry","category-linux-server"],"_links":{"self":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=54"}],"version-history":[{"count":1,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":55,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/54\/revisions\/55"}],"wp:attachment":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}