root / pykota / trunk / initscripts / postgresql / README.postgresql @ 1203

Revision 1203, 3.5 kB (checked in by jalet, 21 years ago)

Job price added to history

  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
Line 
1# $Id$
2
3PyKota - Print Quota for CUPS and LPRng
4
5(c) 2003 Jerome Alet <alet@librelogiciel.com>
6This program is free software; you can redistribute it and/or modify
7it under the terms of the GNU General Public License as published by
8the Free Software Foundation; either version 2 of the License, or
9(at your option) any later version.
10
11This program is distributed in the hope that it will be useful,
12but WITHOUT ANY WARRANTY; without even the implied warranty of
13MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
14GNU General Public License for more details.
15
16You should have received a copy of the GNU General Public License
17along with this program; if not, write to the Free Software
18Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
19
20============================================================
21
22Documentation for the pykota-postgresql.sql script :
23----------------------------------------------------
24
25This script is to be used to create an empty Quota Storage
26DataBase using PostgreSQL as a backend.
27
28If you have already installed PyKota, and have datas in your
29Quota Storage DataBase, you may prefer to skip this section
30and read the next one.
31
32        - Launch the psql frontend and connect to the
33          database template1 as a PostgreSQL administrator
34          (i.e. the postgres user) :
35         
36            $ psql -h localhost -U postgres template1
37         
38        - Executes the pykota-postgresql.sql script : 
39       
40            template1=# \i pykota-postgresql.sql
41           
42        - Quit the psql frontend :   
43       
44            template1=# \q
45           
46        - Your PostgreSQL PyKota storage is now ready
47          for use.
48       
49============================================================
50
51Upgrade scripts :
52
53  DON'T DO ANYTHING IF THIS IS YOUR FIRST INSTALLATION
54  OF PYKOTA.
55
56  Some scripts to upgrade old PyKota databases to the new
57  database schema are included. You may have to run all
58  of them or only some of them, depending on your
59  version of PyKota.
60 
61  * An SQL script to upgrade a pre-1.16 PyKota Storage DataBase to
62    1.16 is included. Launch it this way on the Quota Storage Server :
63   
64        $ psql -U postgres pykota
65        pykota=# \i upgrade-to-1.16.sql
66        pykota=# \q
67        $
68       
69    This script adds some fields to the print job history, so that
70    more complete information will be known. The fields that
71    are added are : jobprice, filename, title, copies and print
72    command options. Also some indexes are created to speed things up.
73 
74What is below is for historical reasons only, real people don't use 
75such old beasts, and YOU SHOULDN'T EITHER !
76
77  * An SQL script to upgrade a pre-1.14 PyKota Storage DataBase to
78    1.14 is included. Launch it this way on the Quota Storage Server :
79   
80        $ psql -U postgres pykota
81        pykota=# \i upgrade-to-1.14.sql
82        pykota=# \q
83        $
84       
85    This script adds an "email" field for each user. This field, if not   
86    NULL, is used as the email address of the user when sending warning
87    messages in case he is over quota.
88   
89  * An sql script to upgrade a pre-1.01 PyKota Quota Storage DataBase to
90    1.01 is still included for historical reasons. PLEASE DON'T USE IT !
91 
92  * If you are already running an old version of PyKota (<1.03) and
93    want to upgrade to 1.03, YOU HAVE TO RUN the
94    upgrade-from-before-1.03.py shell script. NOT LAUNCHING THIS SCRIPT
95    WILL CAUSE PYKOTA TO STOP WORKING ! PLEASE NEVER RUN THIS SCRIPT IF
96    YOUR EXISTING VERSION OF PYKOTA IS ALREADY 1.03 OR HIGHER.
Note: See TracBrowser for help on using the browser.