Re: WAL to RAW devices ?
От | Alex Vinogradovs |
---|---|
Тема | Re: WAL to RAW devices ? |
Дата | |
Msg-id | 1188607550.6082.66.camel@localhost обсуждение исходный текст |
Ответ на | Re: WAL to RAW devices ? ("Joshua D. Drake" <jd@commandprompt.com>) |
Список | pgsql-general |
Oh well, I guess I will just use some trigger to invoke a C function and store the statements in a raw device with some proprietary format, while the actual inserts don't take place at all. In case anyone has more ideas, please let me know. On Fri, 2007-08-31 at 17:45 -0700, Joshua D. Drake wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Alex Vinogradovs wrote: > > Hi guys, > > > > > > I've got a bunch of PosgreSQL servers connected to external storage, > > where a single server needs to be serving as WO database dealing with > > INSERTs only, and bunch of other guys need to obtain a copy of that > > data for RO serving, without taking resources on WO server. > > You can't do that with PostgreSQL without replication. Unless you are > willing to have outages with your RO servers to apply the logs. > > Further you are considering the wrong logs. It is not the WAL logs, but > the archive logs that you need. > > Sincerely, > > Joshua D. Drake >
В списке pgsql-general по дате отправления: