Skip site navigation (1) Skip section navigation (2)

Re: WAL to RAW devices ?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Alex Vinogradovs <AVinogradovs(at)clearpathnet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL to RAW devices ?
Date: 2007-09-01 00:45:47
Message-ID: 46D8B63B.6080703@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-general
-----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


>  The idea is to have say 2 raw devices which would be used as 2 WAL
> segments (round-robin). RO servers will go after the one that's not used
> at a given time with something like xlogdump utility and produce INSERT
> statements to be then executed locally. After that import is done, a
> command will be issued to the WO server to switch to the other segment
> so that the cycle can repeat.
>  The objective of that replication model is to ensure that SELECT
> queries won't ever affect the performance of the WO server,
> which may experience uneven loads.
> 
> Is that possible with the 8.2.4 or 8.3 capabilities, or maybe with
> minor modifications ?
> 
> Thanks!
> 
> Best regards,
> Alex Vinogradovs
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org/
> 


- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
			UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG2LY7ATb/zqfZUUQRAkM6AJ9AcueKf/f7Aali9cuia12Cp3ea3wCfdN+s
C3VIqLGY/pHMdFtXt6Tgx74=
=RASk
-----END PGP SIGNATURE-----

In response to

Responses

pgsql-general by date

Next:From: Alex VinogradovsDate: 2007-09-01 00:45:50
Subject: Re: WAL to RAW devices ?
Previous:From: Joshua D. DrakeDate: 2007-09-01 00:42:10
Subject: Re: WAL to RAW devices ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group