Home > mailing lists

copying a large database to change encoding - Mailing list pgsql-general

From	Matthew Chambers
Subject	copying a large database to change encoding
Date	October 14, 2014 20:31:13
Msg-id	543D5DD4.3020906@wetafx.co.nz Whole thread Raw
Responses	Re: copying a large database to change encoding Re: copying a large database to change encoding
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Alvaro Herrera
Date: 14 October 2014, 17:36:04
Subject: Re: Where should I post 3rd party product announcements?

From: Adrian Klaver
Date: 14 October 2014, 20:39:49
Subject: Re: copying a large database to change encoding

copying a large database to change encoding - Mailing list pgsql-general

Previous

Next