copying a large database to change encoding

From: Matthew Chambers <mchambers(at)wetafx(dot)co(dot)nz>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: copying a large database to change encoding
Date: 2014-10-14 17:31:00
Message-ID: 543D5DD4.3020906@wetafx.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Would something like this work best, or is it better to use pgdump?

CREATE DATABASE newDatabase TEMPLATE oldDatabase ENCODING 'UTF8'

Does using a template do a file system copy or just SQL copy everything
over?

-Matt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-10-14 17:39:41 Re: copying a large database to change encoding
Previous Message Alvaro Herrera 2014-10-14 14:35:54 Re: Where should I post 3rd party product announcements?