Changeset 2817 for pykota/trunk/initscripts/postgresql/README.postgresql
- Timestamp:
- 03/29/06 00:03:44 (18 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/postgresql/README.postgresql
r2622 r2817 30 30 and read the next one. 31 31 32 - edit the pykota-postgresql.sql file and modify the passwords on 33 the 'CREATE USER' lines. 34 32 35 - Launch the psql frontend and connect to the 33 36 database template1 as a PostgreSQL administrator … … 36 39 as user 'root' : 37 40 38 $su - postgres41 # su - postgres 39 42 40 43 you're now user 'postgres', then continue with : 41 44 42 $ psql -h localhost -U postgres template145 $ psql -h localhost -U postgres -f pykota-postgresql.sql template1 43 46 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 : 45 53 46 template1=# \i pykota-postgresql.sql 54 storagebackend : pgstorage 55 storageserver : localhost 56 storagename : pykota 57 storageuser : pykotauser 58 storageuserpw : readonlypw 47 59 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 : 49 65 50 template1=# \q 66 storageadmin : pykotaadmin 67 storageadminpw : readwritepw 51 68 52 - Your PostgreSQL PyKota storage is now ready53 for use.69 NB : replace 'readwritepw' with the password you chose 70 for user 'pykotaadmin' when you modified pykota-postgresql.sql 54 71 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 55 79 ============================================================ 56 80 … … 70 94 instead : 71 95 72 $su - postgres96 # su - postgres 73 97 74 98 You're now user 'postgres', then continue the upgrade by following