Thread: load-balancing and online backup

load-balancing and online backup

From
Alexander Jerusalem
Date:
Hi,

I have to questions regarding mission critical applications on top of postgres:
Is a way to run multiple postgresql servers on different machines that
access the same data? Or is there any other way to do load-balancing for
postgres? Is it possible to backup data while postgres is actively serving
users?

thanks,

Alexander Jerusalem
vknn


Re: load-balancing and online backup

From
Joshua Drake
Date:
Hello,

There is a replication server available for Postgres. It is not as complete
as some but still pretty good.

J


Alexander Jerusalem wrote:

> Hi,
>
> I have to questions regarding mission critical applications on top of
> postgres: Is a way to run multiple postgresql servers on different
> machines that access the same data? Or is there any other way to do
> load-balancing for postgres? Is it possible to backup data while postgres
> is actively serving users?
>
> thanks,
>
> Alexander Jerusalem
> vknn
>
>