PORTREVISION=	1

Index: grant_postgresql_privileges.in

===================================================================

RCS file: /cvsroot/bacula/bacula/src/cats/grant_postgresql_privileges.in,v

retrieving revision 1.9

diff -u -b -r1.9 grant_postgresql_privileges.in

--- src/cats/grant_postgresql_privileges.in	6 Nov 2005 18:04:08 -0000	1.9

+++ src/catsgrant_postgresql_privileges.in	9 Jan 2007 22:49:01 -0000

@@ -28,6 +28,9 @@

 grant all on storage	  to ${USER};

 grant all on device	  to ${USER};

 grant all on status	  to ${USER};

+grant all on location	  to ${USER};

+grant all on locationlog  to ${USER};

+grant all on log		  to ${USER};

 -- for sequences on those tables

@@ -44,7 +47,9 @@

 grant select, update on storage_storageid_seq	   to ${USER};

 grant select, update on mediatype_mediatypeid_seq  to ${USER};

 grant select, update on device_deviceid_seq	   to ${USER};

-

+grant select, update on location_locationid_seq		to ${USER};

+grant select, update on locationlog_loclogid_seq	to ${USER};

+grant select, update on log_logid_seq				to ${USER};

 END-OF-DATA

 then

Index: update_postgresql_tables.in

===================================================================

RCS file: /cvsroot/bacula/bacula/src/cats/update_postgresql_tables.in,v

retrieving revision 1.30

diff -u -b -r1.30 update_postgresql_tables.in

--- src/cats/update_postgresql_tables.in	27 Jul 2006 01:58:42 -0000	1.30

+++ src/cats/update_postgresql_tables.in	9 Jan 2007 22:49:20 -0000

@@ -1,10 +1,10 @@

 #!/bin/sh

 #

-# Shell script to update PostgreSQL tables from version 1.38 to 1.39

+# Shell script to update PostgreSQL tables from version 1.38 to 2.0.0 or higher

 #

 echo " "

 echo "This script will update a Bacula PostgreSQL database from version 9 to 10"

-echo " which is needed to convert from Bacula version 1.38.x to 1.39.x or higher"

+echo " which is needed to convert from Bacula version 1.38.x to 2.0.0 or higher"

 echo "Depending on the size of your database,"

 echo "this script may take several minutes to run."

 echo " "