Bernd Helmle mailings at oopsware.de
Tue Nov 20 08:44:34 PST 2007
--On Dienstag, November 20, 2007 17:18:28 +0100 Cyril SCETBON 
<cyril.scetbon at free.fr> 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


More information about the Slony1-general mailing list