error creating database

From: Geoffrey <lists(at)serioustechnology(dot)com>
To: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: error creating database
Date: 2010-02-17 14:15:56
Message-ID: 4B7BFA1C.5070608@serioustechnology.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to reload a database and I'm receiving the following error:

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 5181; 1262 45260
DATABASE nev postgres
pg_restore: [archiver (db)] could not execute query: ERROR: encoding
LATIN1 does not match server's locale en_US.UTF-8
DETAIL: The server's LC_CTYPE setting requires encoding UTF8.
Command was:
CREATE DATABASE nev WITH TEMPLATE = template0 ENCODING = 'LATIN1';

This backup was created on another machine, so it must be that the
enviroment on the two machines is different.

Where do I look to fix this?

Thanks.

--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Barnes 2010-02-17 14:29:47 Re: error creating database
Previous Message Dimitri Fontaine 2010-02-17 13:15:48 Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion