Eduardo Morras wrote: Hi, > I'm currently building a Pg multiserver and have a question about the > possibility of working with WAL in a multislave environment. > > I have few master servers (write only) and multiple slave servers (read > only). I want to write the WAL files from masters in a central postgres > and that the multiple slaves reads them from time to time and auto > update. Never heard of a "multiserver". I assume you mean there's a bunch (zero or more) slaves for each master. there's a suite to handle this kind of thing using pg_standby, including cleanup of old logs; see https://projects.commandprompt.com/public/pitrtools Mind you, the WAL files are not stored in a database but in raw files. I have never seen anyone advocating the use of a database to store them. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
