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

Revision 2564, 5.1 kB (checked in by jerome, 19 years ago)

Added some clarification on the way to launch psql.

  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
Line 
1# $Id$
2
3PyKota - Print Quotas 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., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, 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          as user 'root' :
37         
38            $ su - postgres
39           
40          you're now user 'postgres', then continue with :   
41         
42            $ psql -h localhost -U postgres template1
43         
44        - Executes the pykota-postgresql.sql script : 
45       
46            template1=# \i pykota-postgresql.sql
47           
48        - Quit the psql frontend :   
49       
50            template1=# \q
51           
52        - Your PostgreSQL PyKota storage is now ready
53          for use.
54       
55============================================================
56
57Upgrade scripts :
58
59  DON'T DO ANYTHING IF THIS IS YOUR FIRST INSTALLATION
60  OF PYKOTA.
61
62  Some scripts to upgrade old PyKota databases to the new
63  database schema are included. You may have to run all
64  of them or only some of them, depending on your
65  version of PyKota. Usually running them several times, for
66  example if you used several different development versions
67  of PyKota, won't do any harm.
68 
69  If you're connected as user 'root', you have to be user 'postgres'
70  instead :
71         
72            $ su - postgres
73           
74  You're now user 'postgres', then continue the upgrade by following
75  the instructions below, depending on the version you actually use :
76 
77  * An SQL script to upgrade a 1.22 PyKota Storage DataBase to
78    1.23 is included. Launch it this way on the Quota Storage Server :
79   
80        $ psql -U postgres pykota
81        pykota=# \i upgrade-to-1.23.sql
82        pykota=# \q
83        $
84       
85    This script adds many fields to existing tables, and a table to
86    manage billing codes.
87   
88  * An SQL script to upgrade a 1.20 PyKota Storage DataBase to
89    1.21 is included. Launch it this way on the Quota Storage Server :
90   
91        $ psql -U postgres pykota
92        pykota=# \i upgrade-to-1.21.sql
93        pykota=# \q
94        $
95       
96    This script adds many fields to existing tables, and also adds
97    some tables in indexes.
98   
99  * An SQL script to upgrade a 1.18 PyKota Storage DataBase to
100    1.19 is included. Launch it this way on the Quota Storage Server :
101   
102        $ psql -U postgres pykota
103        pykota=# \i upgrade-to-1.19.sql
104        pykota=# \q
105        $
106       
107    This script adds a field to the print job history. The field that
108    is added is : hostname
109   
110  * An SQL script to upgrade a pre-1.16 PyKota Storage DataBase to
111    1.16 is included. Launch it this way on the Quota Storage Server :
112   
113        $ psql -U postgres pykota
114        pykota=# \i upgrade-to-1.16.sql
115        pykota=# \q
116        $
117       
118    This script adds some fields to the print job history, so that
119    more complete information will be known. The fields that
120    are added are : jobprice, filename, title, copies and print
121    command options. Also some indexes are created to speed things up.
122 
123What is below is for historical reasons only, real people don't use 
124such old beasts, and YOU SHOULDN'T EITHER !
125
126  * An SQL script to upgrade a pre-1.14 PyKota Storage DataBase to
127    1.14 is included. Launch it this way on the Quota Storage Server :
128   
129        $ psql -U postgres pykota
130        pykota=# \i upgrade-to-1.14.sql
131        pykota=# \q
132        $
133       
134    This script adds an "email" field for each user. This field, if not   
135    NULL, is used as the email address of the user when sending warning
136    messages in case he is over quota.
137   
138  * An sql script to upgrade a pre-1.01 PyKota Quota Storage DataBase to
139    1.01 is still included for historical reasons. PLEASE DON'T USE IT !
140 
141  * If you are already running an old version of PyKota (<1.03) and
142    want to upgrade to 1.03, YOU HAVE TO RUN the
143    upgrade-from-before-1.03.py shell script. NOT LAUNCHING THIS SCRIPT
144    WILL CAUSE PYKOTA TO STOP WORKING ! PLEASE NEVER RUN THIS SCRIPT IF
145    YOUR EXISTING VERSION OF PYKOTA IS ALREADY 1.03 OR HIGHER.
Note: See TracBrowser for help on using the browser.