Re: 1 cluster on several servers

Поиск
Список
Период
Сортировка
От Usama Dar
Тема Re: 1 cluster on several servers
Дата
Msg-id ff0e67090711290856j3fbaea31r7e2ccefaa92f681e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 1 cluster on several servers  ("Willy-Bas Loos" <willybas@gmail.com>)
Список pgsql-general


On Nov 29, 2007 6:27 PM, Willy-Bas Loos <willybas@gmail.com> wrote:
I'll take that as a "no".
What i mean is to actually run exactly one cluster (no replicated copy) on more than one server. Of course, if that were possible, why would people bother with replication..

I guess it is irrational to suggest that it would be possible, since each server would at least need to have it's own copy of the DBMS software etc, or it would cease to be a separate server.

Maybe "Data Partitioning", as in the documentation link Shane sent, possibly combined with Slony for the other data per server, would be an option for me.

Is there an implementation for this in PostgreSQL? It would have to be something like pgPool (middleware), because: How would the query know on which server to put it's data? And i guess i would need some Kerberos-like implementation for my authentication and authorization...

There used to be parallel server type solution for postgresql called ExtenDB www.extendb.com , but i think its now acquired by a commercial PostgresSQL vendor, but i have seen others similar to that.
 

cheers,

WBL



On Nov 29, 2007 1:23 PM, Shane Ambler <pgsql@sheeky.biz> wrote:
Willy-Bas Loos wrote:
> Hi,
>
> Is it possible to run one PostgreSQL cluster on more than one (hardware)
> server?
>
> WBL
>
You would be looking for replication.
Start with
http://www.postgresql.org/docs/8.2/interactive/high-availability.html
to get some idea on what is available for what you wish to achieve.
Some of the projects that add these features are mentioned.




--

Shane Ambler
pgSQL@Sheeky.Biz

Get Sheeky @ http://Sheeky.Biz




--
Usama Munir Dar http://linkedin.com/in/usamadar
Consultant Architect
Cell:+92 321 5020666
Skype: usamadar

В списке pgsql-general по дате отправления:

Предыдущее
От: John Burger
Дата:
Сообщение: Will PG use composite index to enforce foreign keys?
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: HD is flooded by Error Log info