2011/10/20 Miroslav Suchý <[email protected]>: > > In fresh-install it is located in postgres/end.sql and is dynamically > created by create_varnull_constriants() function. > > But I forget that this is not called during upgrades. I will add it to > upgrade script as well. > > -- > Miroslav Suchy > Red Hat Satellite Engineering
Thank you! I am glad to have asked questions and picked your brain. My process, since I am tracking 1.6-nightly, is to watch for spacewalk-schema changes, examine directory up upgrades of spacewalk-schema... /etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/ ...and applying (or diffing) any new incremental changes (such as new patch files) that appear in that directory for postgresql. And after applying the changes to postgresl/oracle, I apply the SQL in the file... (for postgresql) /etc/sysconfig/rhn/postgres/upgrade-end.sql By doing the following: su postgres - psql -d spaceschema -f /etc/sysconfig/rhn/postgres/upgrade-end.sql (for oracle) /etc/sysconfig/rhn/oracle/upgrade-end.sql (I'm not running oracle, so I don't know how to apply these changes) This seems to work for me. _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
