I am definitely not a DBA but I can Google. Recently at work I broke out production instance of Sal. How I’m still not sure but was able to get Sal working but the Key’s for the groups were different. I had several different options but the easiest I thought was to just update the Key field in the database and call it good. Below are my basic notes.
psql -U USERNAME DATABASE
\l – List databases
\dt – listing tables
select * from TABLE – show data on table. (After selecting the database)
update TABLE set FIELD = ‘VALUE’ where ID = #;