Using WAL

#1

Hi,

I'd like to have your opinions, your advices about using WAL and NFS server.

I moved pg_xlog/ directory to a NFS server and created a link to it in
$PGDATA.

Thanks

Ced.

#2

Cedrick a écrit :

Quote:

I'd like to have your opinions, your advices about using WAL and NFS
server.

I moved pg_xlog/ directory to a NFS server and created a link to it in
$PGDATA.

Why don't you put pg_xlog on a fast local drive, and move the old WALs
on NFS using the archive_command option ?

#3

Cedrick <cbuschini (AT) carax (DOT) com> wrote:

Quote:

I'd like to have your opinions, your advices about using WAL and NFS server.

I moved pg_xlog/ directory to a NFS server and created a link to it in
$PGDATA.

I think that this is a bad idea, because:

a) it will slow down your database considerably since WALs have much I/O.
b) it will cause your database server to crash or hang indefinitely if
there is a network problem.

What is the type of failure you want to combat?

Yours,
Laurenz Albe

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using WAL

comp.databases.postgresql comp.databases.postgresql

Using WAL - 07-20-2007 , 08:47 AM

Re: Using WAL - 07-23-2007 , 07:21 AM

Re: Using WAL - 07-24-2007 , 07:40 AM