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

Revision 2028, 3.9 kB (checked in by jalet, 20 years ago)

Modified copyright years

  • 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, 2004, 2005 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 1.18 PyKota Storage DataBase to
62    1.19 is included. Launch it this way on the Quota Storage Server :
63   
64        $ psql -U postgres pykota
65        pykota=# \i upgrade-to-1.19.sql
66        pykota=# \q
67        $
68       
69    This script adds a field to the print job history. The field that
70    is added is : hostname
71   
72  * An SQL script to upgrade a pre-1.16 PyKota Storage DataBase to
73    1.16 is included. Launch it this way on the Quota Storage Server :
74   
75        $ psql -U postgres pykota
76        pykota=# \i upgrade-to-1.16.sql
77        pykota=# \q
78        $
79       
80    This script adds some fields to the print job history, so that
81    more complete information will be known. The fields that
82    are added are : jobprice, filename, title, copies and print
83    command options. Also some indexes are created to speed things up.
84 
85What is below is for historical reasons only, real people don't use 
86such old beasts, and YOU SHOULDN'T EITHER !
87
88  * An SQL script to upgrade a pre-1.14 PyKota Storage DataBase to
89    1.14 is included. Launch it this way on the Quota Storage Server :
90   
91        $ psql -U postgres pykota
92        pykota=# \i upgrade-to-1.14.sql
93        pykota=# \q
94        $
95       
96    This script adds an "email" field for each user. This field, if not   
97    NULL, is used as the email address of the user when sending warning
98    messages in case he is over quota.
99   
100  * An sql script to upgrade a pre-1.01 PyKota Quota Storage DataBase to
101    1.01 is still included for historical reasons. PLEASE DON'T USE IT !
102 
103  * If you are already running an old version of PyKota (<1.03) and
104    want to upgrade to 1.03, YOU HAVE TO RUN the
105    upgrade-from-before-1.03.py shell script. NOT LAUNCHING THIS SCRIPT
106    WILL CAUSE PYKOTA TO STOP WORKING ! PLEASE NEVER RUN THIS SCRIPT IF
107    YOUR EXISTING VERSION OF PYKOTA IS ALREADY 1.03 OR HIGHER.
Note: See TracBrowser for help on using the browser.