Slony1 PostgreSQL Replication

Author

tablespaces

Miguel

2006-04-04, 8:29 pm

hi, is there a problem that the database being replicated (master and
slave) are on tablespace diferent from postgres' default?
i want to start using tablespaces with a new database and wonder if that
would cause a problem to slony

--
thanks

Philip Yarra

2006-04-04, 8:29 pm

On Wed, 5 Apr 2006 10:46 am, Miguel wrote:
> hi, is there a problem that the database being replicated (master and
> slave) are on tablespace diferent from postgres' default?
> i want to start using tablespaces with a new database and wonder if that
> would cause a problem to slony

We've just deployed Slony to replicate 4 databases, all on a non-default
tablespace (same tablespace on master and slave). Seems to be working just
fine so far.

I would strongly recommend that you set up a proof-of-concept system - I have
been using such a setup to confirm early on in the project that what I plan
will work. A couple of old P3s running Linux (or *BSD or whatever) would be a
cheap way to do this.

Regards, Philip.

--

"Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it." - Brian W. Kernighan

-----------------
Utiba Pty Ltd
This message has been scanned for viruses and
dangerous content by Utiba mail server and is
believed to be clean.

Miguel

2006-04-04, 8:29 pm

Philip Yarra wrote:

>On Wed, 5 Apr 2006 10:46 am, Miguel wrote:
>
>
>
>We've just deployed Slony to replicate 4 databases, all on a non-default
>tablespace (same tablespace on master and slave). Seems to be working just
>fine so far.
>
>Regards, Philip.
>
>
>
Great!!, i'll give it a try ,
thanks

Christopher Browne

2006-04-05, 11:36 am

Miguel <mmiranda- nEhLOg9Nx0turzwRxvvF
aw@public.gmane.org> writes:
> hi, is there a problem that the database being replicated (master and
> slave) are on tablespace diferent from postgres' default?
> i want to start using tablespaces with a new database and wonder if that
> would cause a problem to slony

I'd be inclined to test it before deploying it, but this shouldn't
have any effect on Slony-I behaviour.

Tablespaces are all about where the data is physically stored...

- on an origin, that won't affect the logtrigger functions, which
determine how Slony-I captures data;

- on a subscriber, Slony-I uses COPY (at subscribe time), and
INSERT/DELETE/UPDATE (ongoing activity), none of which care about
tablespaces.

I'd be *very* surprised if use of tablespaces caused any problems.
--
let name="cbbrowne" and tld="ca.afilias.info" in name ^ "@" ^ tld;;
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)

Miguel

2006-04-05, 1:42 pm

Christopher Browne wrote:

>Miguel <mmiranda- nEhLOg9Nx0turzwRxvvF
aw@public.gmane.org> writes:
>
>
>
>I'd be inclined to test it before deploying it, but this shouldn't
>have any effect on Slony-I behaviour.
>
>Tablespaces are all about where the data is physically stored...
>
>- on an origin, that won't affect the logtrigger functions, which
> determine how Slony-I captures data;
>
>- on a subscriber, Slony-I uses COPY (at subscribe time), and
> INSERT/DELETE/UPDATE (ongoing activity), none of which care about
> tablespaces.
>
>I'd be *very* surprised if use of tablespaces caused any problems.
>
>
Ok, i will let you know if any problem arise,
thanks

Sponsored Links