Hi there.

I have a master node with a database and tables owned by user1 (not
superuser). Our apps use that same user to connect to the database.

Following slony's documentation I created a new "slony" superuser so
slons connect to the nodes as that user. I've done schema migrations
using the slonik execute script without specifying ownerships. So all
my replicated tables on the slave are owned by the slony user.

When I want to do a switch/failover the apps can't use the replicated
tables because of permission issues.

I'd like to know if you can suggest me some "best practice" regarding
this simple case. If I can avoid having to include special ownership
changes on the execute scripts, much better.

Thanks

-- 
Diego Algorta Casamayou
http://www.oboxodo.com - http://diego.algorta.net