OSM kaardiserver Mandriva 2010 Spring baasil

Mandriva paigaldus

Soovitav paigaldada mandriva Free versioon mandriva-linux-one-2010-spring-KDE4-europe2-cdrom-i586.iso

Täpsemat kirjeldust Mandriva paigaldamise kohta saab siit Installing_Mandriva_Linux

Postgre piagaldus ja seadistamine

Kui puhas install on tehtud tuleb paigaldada postgresql andmebaas ja postgre postgis -i laiendus.

urpmi postgresql8.4, postgis

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 genereerida 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=#