{"id":271,"date":"2008-05-15T09:14:00","date_gmt":"2008-05-15T09:14:00","guid":{"rendered":"http:\/\/new.cottee.org\/2008\/05\/cloningcopying-postgres-databases\/"},"modified":"2008-05-15T09:14:00","modified_gmt":"2008-05-15T09:14:00","slug":"cloningcopying-postgres-databases","status":"publish","type":"post","link":"https:\/\/cottee.org\/?p=271","title":{"rendered":">Cloning\/copying postgres databases"},"content":{"rendered":"<p>>Do<\/p>\n<blockquote><p>createdb newdatabase -T olddatabase<\/p><\/blockquote>\n<p>always forget this and end up dumping the old database and loading it into the new one. It takes a lot of time that way. This way is quicker.<\/p>\n<div class=\"blogger-post-footer\"><img width='1' height='1' src='https:\/\/blogger.googleusercontent.com\/tracker\/9210244490645736884-8863073177578385927?l=blog.cottee.org' alt='' \/><\/div>\n","protected":false},"excerpt":{"rendered":"<p>>Do createdb newdatabase -T olddatabase always forget this and end up dumping the old database and loading it into the new one. It takes a lot of time that way. This way is quicker.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[40],"class_list":["post-271","post","type-post","status-publish","format-standard","hentry","category-oldsite","tag-postgres"],"_links":{"self":[{"href":"https:\/\/cottee.org\/index.php?rest_route=\/wp\/v2\/posts\/271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cottee.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cottee.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cottee.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cottee.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=271"}],"version-history":[{"count":0,"href":"https:\/\/cottee.org\/index.php?rest_route=\/wp\/v2\/posts\/271\/revisions"}],"wp:attachment":[{"href":"https:\/\/cottee.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cottee.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cottee.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}