--On Dienstag, November 20, 2007 17:18:28 +0100 Cyril SCETBON <[EMAIL PROTECTED]> wrote:

Hi,


Is it possible to force slony to create his objects in a specified
tablespace ?

I would like to use a specified tablespace for my database and another
one for slony's objects.


You could try the default_tablespace parameter bound to your database session during slony initialization. What i've done recently was:

- create the tablespace slony
- export PGOPTIONS='-c default_tablespace=slony'
- issue your slonik scripts within this session

If you have a dedicated slony superuser, you can just bind the default_tablespace to the specific role.

Maybe someone uses yet a different path....

--
 Thanks

                   Bernd
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to