Re: Table Partitioning : Having child tables in multiple database servers

Hi all,
We have got the Table Partitioning of PostgreSQL to work on one database
server, where the Parent Table and Inherited Child Tables are on one (1)
database server.

The question which we need to get answered is, whether we can have the Child
Tables in separate database servers?

Can you please give us your expertise thoughts on this?

Thanks & Regards
--
Ransika De Silva

Hello,
Many thanks for the quick response.

Why I raised the previous question was to get an answer/solution for the
following requirement;

The client wants to have the freedom of increasing the processor power AND
the storage by introducing new database servers.

What is your thought on getting the above mentioned requirement satisfied.

Thanking you and anticipating a response soon.

@ Grzegorz Jaśkiewicz
Apologies for directly sending you the mail.

Regards
Ransika

2009/7/7 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>

> you should ask the question on the list (press reply-all, not just
> reply to my previous message please).
>
>
> 2009/7/7 Ransika de Silva <ransika(at)gmail(dot)com>:
> > Hello,
> > Many thanks for the quick response.
> > Why I raised the previous question was to get an answer/solution for the
> > following requirement;
> > The client wants to have the freedom of increasing the processor power
> AND
> > the storage by introducing new database servers.
> > What is your thought on getting the above mentioned
> requirement satisfied.
> > Thanking you and anticipating a response soon.
>
> > Regards,
> > Ransika
>
> > 2009/7/7 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
> >>
> >> On Tue, Jul 7, 2009 at 3:32 PM, Ransika de Silva<ransika(at)gmail(dot)com>
> wrote:
> >> >
> >> > Hi all,
> >> > We have got the Table Partitioning of PostgreSQL to work on one
> database
> >> > server, where the Parent Table and Inherited Child Tables are on one
> (1)
> >> > database server.
> >> > The question which we need to get answered is, whether we can have the
> >> > Child
> >> > Tables in separate database servers?
> >> > Can you please give us your expertise thoughts on this?
> >>
> >> no you can't
> >>
> >>
> >>
> >>
> >> --
> >> GJ
> >
> >
> >
> > --
> > Ransika De Silva
> > SCMAD 1.0, SCJP 1.4,
> > BSc.(Hons) Information Systems
> >
>
>
>
> --
> GJ
>

--
Ransika De Silva
SCMAD 1.0, SCJP 1.4,
BSc.(Hons) Information Systems

Hi,

Ransika de Silva <ransika(at)gmail(dot)com> writes:
> The client wants to have the freedom of increasing the processor power
> AND the storage by introducing new database servers.

I think the following document will be of interest:
http://wiki.postgresql.org/wiki/Image:Moskva_DB_Tools.v3.pdf

It presents the architecture Skype is using, and how to achieve what you
need with plproxy and londiste and their other tools.

--
dim