Show
Ignore:
Timestamp:
03/29/06 00:03:44 (18 years ago)
Author:
jerome
Message:

Improved documentation for PostgreSQL and MySQL backends setup.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • pykota/trunk/initscripts/postgresql/README.postgresql

    r2622 r2817  
    3030and read the next one. 
    3131 
     32        - edit the pykota-postgresql.sql file and modify the passwords on 
     33          the 'CREATE USER' lines. 
     34           
    3235        - Launch the psql frontend and connect to the 
    3336          database template1 as a PostgreSQL administrator 
     
    3639          as user 'root' : 
    3740           
    38             $ su - postgres 
     41            # su - postgres 
    3942             
    4043          you're now user 'postgres', then continue with :    
    4144           
    42             $ psql -h localhost -U postgres template1 
     45            $ psql -h localhost -U postgres -f pykota-postgresql.sql template1 
    4346           
    44         - Executes the pykota-postgresql.sql script :   
     47        - If no error message appears, your PostgreSQL PyKota storage  
     48          is now ready for use. NB : a lot of NOTICE messages might appear, 
     49          this is perfectly normal. 
     50           
     51        - In ~pykota/pykota.conf, ensure that the following lines 
     52          are present and unique inside the [global] section : 
    4553         
    46             template1=# \i pykota-postgresql.sql 
     54            storagebackend : pgstorage 
     55            storageserver : localhost 
     56            storagename : pykota 
     57            storageuser : pykotauser 
     58            storageuserpw : readonlypw 
    4759             
    48         - Quit the psql frontend :     
     60            NB : replace 'readonlypw' with the password you chose 
     61            for user 'pykotauser' when you modified pykota-postgresql.sql 
     62             
     63        - In ~pykota/pykotadmin.conf ensure that the following lines 
     64          are present and unique inside the [global] section : 
    4965         
    50             template1=# \q 
     66            storageadmin : pykotaadmin 
     67            storageadminpw : readwritepw 
    5168             
    52         - Your PostgreSQL PyKota storage is now ready 
    53           for use. 
     69            NB : replace 'readwritepw' with the password you chose 
     70            for user 'pykotaadmin' when you modified pykota-postgresql.sql 
    5471         
     72        - IMPORTANT : if your database is not located on the print server,  
     73          replace 'localhost' in the lines above with your database server's  
     74          hostname or IP address. If your database server doesn't listen on 
     75          its standard port, add the port number at the end of the hostname 
     76          with a colon to separate the hostname from the port. 
     77          See pykota/conf/pykota.conf.sample for examples. 
     78           
    5579============================================================ 
    5680 
     
    7094  instead : 
    7195           
    72             $ su - postgres 
     96            # su - postgres 
    7397             
    7498  You're now user 'postgres', then continue the upgrade by following