Mandriva 2010.1 postgre install miskipärast teeb bydefault template andmebaasid ASCII vormingus, mille tulemusena ei saa nende pealt luua UTF8 vormingus andmebaase.
[postgres@andres ~]$ psql psql (8.4.4) Type "help" for help. postgres=# \l List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------+----------+-----------+-----------+-------+----------------------- postgres | postgres | SQL_ASCII | C | C | template0 | postgres | SQL_ASCII | C | C | =c/postgres : postgres=CTc/postgres template1 | postgres | SQL_ASCII | C | C | =c/postgres : postgres=CTc/postgres (3 rows) postgres=# Et seda probleemi parandada, tuleb olemasolevad template0 ja template1 baasi ära kustutada [postgres@andres ~]$ rm -rf /var/lib/pgsql/data ... ja uued luuagenereerida UTF8 vormingus [postgres@andres ~]$ initdb -E=UTF8 The files belonging to this database system will be owned by user "postgres". This user must also own the server process. ... WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the -A option the next time you run initdb. Success. You can now start the database server using: postgres -D /var/lib/pgsql/data or pg_ctl -D /var/lib/pgsql/data -l logfile start [postgres@andres ~]$psql psql (8.4.4) Type "help" for help. postgres=# \l List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------+----------+----------+-----------+-------+----------------------- postgres | postgres | UTF8 | C | C | template0 | postgres | UTF8 | C | C | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8 | C | C | =c/postgres : postgres=CTc/postgres (3 rows) postgres=#