--- joko/doc/SampleTasks/joko_2003-01.html 2003/01/28 18:34:26 1.86 +++ joko/doc/SampleTasks/joko_2003-01.html 2003/01/28 21:03:42 1.90 @@ -805,6 +805,54 @@ x use 'postgres' x use 'mnogosearch' x apt-get install postgresql + x use 'Enter default encoding (SQL_ASCII):' + Success. You can now start the database server using: + + /usr/lib/postgresql/bin/postmaster -D /var/lib/postgres/data + or + /usr/lib/postgresql/bin/pg_ctl -D /var/lib/postgres/data -l logfile start + + PostgreSQL database now installed. + Use /usr/bin/createdb to create a specific database and + /usr/bin/createuser to enable other users to connect to a + PostgreSQL database. + + In the first instance, these commands must be run by the + user 'postgres'. + + Restarting PostgreSQL database: postmaster + No /usr/lib/postgresql/bin/postmaster found running; none killed. + Starting PostgreSQL postmaster. + postmaster successfully started + . + Enabling the PL procedural language in all PostgreSQL databases... + plpgsql added to template1 + x apt-get install postgresql-dev + e apt-get install libpostgresql + e apt-get install libpgtcl + x apt-get install mnogosearch-pgsql mnogosearch-pgsql-dev + x dpkg-reconfigure mnogosearch-common + x su postgres + x /usr/lib/postgresql/bin/createuser mnogosearch + x /usr/lib/postgresql/bin/createdb mnogosearch + + x changed to "mysql" in /etc/mnogosearch/indexer.conf and + e deployed schemas at /usr/share/doc/mnogosearch-common/create/mysql/ + x mysql -e "insert into user (host, user, password) values ('localhost', 'mnogosearch', password('mno123'));" mysql + c mysql -e "insert into user (host, user, password) values ('%', 'mnogosearch', password('mno123'));" mysql + x mysql -e "insert into db values ('localhost', 'mnogosearch', 'mnogosearch', 'Y','Y','Y','Y','Y','Y','N','Y','Y','Y');" mysql + x mysql -e "create database mnogosearch;" + x cd /usr/share/doc/mnogosearch-common/create/mysql/ + x mysql mnogosearch < categories.txt + x mysql mnogosearch < crc-multi.txt + x deployed schemas at /usr/share/doc/mnogosearch-common/create/pgsql/ + x psql -U mnogosearch mnogosearch < create.txt + + + + + + o it's not tavi nor tavi-workflow - it's: JustWrite? it's todo! (.todo -> .justdo -> .justwrite -> .done) @@ -1212,7 +1260,7 @@
-$Id: joko_2003-01.html,v 1.86 2003/01/28 18:34:26 joko Exp $ +$Id: joko_2003-01.html,v 1.90 2003/01/28 21:03:42 joko Exp $