PostgreSQL: Modify OWNER on all tables

 is very simple

1. su - postgres
2. psql
3. REASSIGN OWNED BY [old_user] TO [new_user];
4. \c [your database]
5. REASSIGN OWNED BY [old_user] TO [new_user];

done.