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@xxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
