On 1/12/2016 1:20 PM, Andreas Joseph Krogh wrote:
I'm moving a > 500GB DB to another server which is initdb'ed with a
different locale (nb_NO.UTF-8 to get correct collation when ORDER BY).
Is there another option than pg_dump/restore for doing this?
nope, because the text data has to be converted to the new encoding,
indexes rebuilt since the collation order is different, etc.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
