PostgreSQL on multiple servers

deception54

I have a question about PostgreSQL. I know a company which plans to install PostgreSQL, but they need to install their database on multiple servers. Is it possible to do it?

Also, I would like to know how data is commited when using PostgreSQL.

I searched the PostgreSQL documentation deeply, but I can not find the answers I need, all the info I find is too technical. If anyone has good links to provide me, please send them!

[deleted]

"but they need to install their database on multiple servers. Is it possible to do it?"

do you mean they need to loadbalance or replicate the databases?

"Also, I would like to know how data is commited when using PostgreSQL."

Again, what do you mean?

deception54

You are right, I am unclear with my questions, and it's all unclear in my mind! hehe!

I want to be able to do database mirroring between 2 or 3 servers using PostgreSQL. Any useful documentation about this? I would also like to know how mirroring works, if their must be master/slave servers, if updates are kept in logs, etc.

About data commit, this is a sub-question. If I am using mirroring, I would like to know the best practices to update my database without overloading the server with too many update requests.

I don't ask for direct answer, what I really need is documentation.

Thanks!

Anon

Hello:

Maybe, REPLICATION is your solution.

Take a look at
http://www.pgsql.com (it is NOT the main www.postgresql.org site, it is a company site)

Good luck.
Andre Felipe

deception54

Hi!

I'm getting slowly on the track.

I try to compare pgReplicator and eRServer, but it is almost impossible to find information about these products.

Anybody here use/knows pgReplicator or eRServer? Any documentation links? That would help me a lot!

Thanks

smarlowe

I'd check the newsgroups for postgresql on groups.google.com for info on that. They are quite active, so there's a good chance someone else has already posted useful info on one or the other there.