Re: how can i change encoding in template1 DB? - Mailing list pgsql-general

thank you Scott,

what i needed of i found it to the follow link

http://www.postgresql.org/docs/8.2/static/app-initdb.html

so

1. i stopped postgres daemon
2. i removed the PGROOT directory
3. i modified the start-up script at the line where there is the initdb
comand:
- (removed line) . su - postgres -c "/usr/bin/initdb -D $PGROOT/data"
- (insert line)  . su - postgres -c "/usr/bin/initdb -D $PGROOT/data -E
UTF8"
4. i start postgres daemon
5. there is the init procedure
6. execute the "$psql -l" comand (under postgres user) and it's all ok i
see the template1 encoding set to UTF8 as i desired



Scott Marlowe ha scritto:
> On Sat, Dec 12, 2009 at 6:32 AM, Nando67 <xxx.yyy@zzz.it> wrote:
>
> I think you'll have to drop it and then create database with template0
> as the template and set encoding then.
>

now, i'll try also this way

many thanks

Bye