On Thu, Mar 03, 2005 at 10:27:56AM -0800, Darcy Buskermolen wrote:
> I've been doing some playing with adjusting GUC values during subscription et 
> all, During this i have discoverd that the parameters you need for Slony-I 
> can be quite different than those that you would use in standard DB tuning..  
> So having said that I'm wondering if it makes sence to add an option to 
> slon.conf that would allow for arbratry  SQL to be sent to the PG backend, 
> when slon establishes a connection?  Things like 'SET log_statement true; 
> NOTIFY slon_daemon_start;'  or other tuning options.
> 
> Thoughts/comments on this ?

I wouldn't do this in slon even if the option was there.  Instead use a
separate user for the slon connections (I use "slony") and then do:

   ALTER USER slony SET xxx = yyy;
   ALTER USER slony SET xx2 = yy2;
   ...

Any connections by user slony will now use these settings.

To undo one of the settings do:

   ALTER USER slony RESET xxx; 

-- 
Dave Chapeskie
OpenPGP Key ID: 0x3D2B6B34