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

Revision 1079, 3.0 kB (checked in by jalet, 21 years ago)

Email field added to PostgreSQL schema

  • 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  Some scripts to upgrade old PyKota databases to the new
54  database schema are included. You may have to run all
55  of them or only some of them, depending on your
56  version of PyKota.
57 
58 
59  * An SQL script to upgrade a pre-1.14 PyKota Storage DataBase to
60    1.14 is included. Launch it this way on the Quota Storage Server :
61   
62        $ psql -U postgres pykota
63        pykota=# \i upgrade-to-1.14.sql
64        pykota=# \q
65        $
66       
67    This script adds an "email" field for each user. This field, if not   
68    NULL, is used as the email address of the user when sending warning
69    messages in case he is over quota.
70   
71What is below is for historical reasons only, real people don't use 
72such old beasts, and YOU SHOULDN'T EITHER !
73
74  * An sql script to upgrade a pre-1.01 PyKota Quota Storage DataBase to
75    1.01 is still included for historical reasons. PLEASE DON'T USE IT !
76 
77  * If you are already running an old version of PyKota (<1.03) and
78    want to upgrade to 1.03, YOU HAVE TO RUN the
79    upgrade-from-before-1.03.py shell script. NOT LAUNCHING THIS SCRIPT
80    WILL CAUSE PYKOTA TO STOP WORKING ! PLEASE NEVER RUN THIS SCRIPT IF
81    YOUR EXISTING VERSION OF PYKOTA IS ALREADY 1.03 OR HIGHER.
Note: See TracBrowser for help on using the browser.