X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=INSTALL.pgsql;h=ecab8bcc0c769cfee90fb88e15e4ccafeff5610f;hb=2fe7b3f4c44843313576e45ac0ceee8d2fcdab3d;hp=3130dc8686990e5ccc0705ec77612e8d632c5257;hpb=90b735e9e955e6e405f8f5ce58c236f1f363215f;p=infobot.git diff --git a/INSTALL.pgsql b/INSTALL.pgsql index 3130dc8..ecab8bc 100644 --- a/INSTALL.pgsql +++ b/INSTALL.pgsql @@ -2,6 +2,38 @@ Method of installation. ----------------------- - Debian: (apt-get install postgresql) -- Debian: (apt-get install libpgperl) +- Debian: (apt-get install libpg-perl) -- run 'scripts/setup.pl' + +As of now, blootbot has full pgsql support. It seems to be working 100%, but it +assumes that you have precreated the database and user for now. As long as you +already created the database and user and stored this info in the blootbot.config, +then the tables will automatically be created on startup. Until I get setup.pl +fixed, run the following commands as root (or postgres if root doesnt have +permission to create users/db's): + +> createuser --no-adduser --no-createdb --pwprompt --encrypted +> createdb --owner= [] + +Dont forget to replace and so forth with actual values you intend to use, +and dont include the <>'s ;) If you run these commands, you should get a user +with an encrypted password that cannot create new db's or user's (as it should be!), +and the user will own the newly created database . Congrats! + +If everything went fine, you should have everything blootbot needs to use pgsql. +Next simply cd to the base directory you installed the bot to and type: + +./blootbot + + +Thats it! Everything the bot needs should be automatically created when it loads +for the first time. + +In the future I will try to get around to editing the setup.pl file to ask the +same questions it does for mysql (your root password etc) so that you can skip +manually creating the database/user. But for now, this should be just fine for +most of you techies out there. + + +---- +troubled@freenode