Re: Transactions - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Transactions
Date
Msg-id 3A2CFD00.650D61E0@sayegh.de
Whole thread Raw
In response to Transactions  (Leandro Fanzone <leandro@hasar.com>)
List pgsql-novice
Leandro Fanzone wrote:

> is executed every time. Is there any way to assure this, I mean, to
> actually write the records and to not rely on the cache to do it?

AFAIR there is an option doing exactly what you want (but i can't
remembet which:().

usage: /usr/bin/postmaster [options]
    -B nbufs    set number of shared buffers
    -D datadir    set data directory
    -S         silent mode (disassociate from tty)
    -a system    use this authentication system
    -b backend    use a specific backend server executable
    -d [1-5]    set debugging level
    -i         listen on TCP/IP sockets as well as Unix domain socket
    -N nprocs    set max number of backends (1..1024, default 32)
    -n         don't reinitialize shared memory after abnormal exit
    -o option    pass 'option' to each backend servers
    -p port    specify port for postmaster to listen on
    -s         send SIGSTOP to all backend servers if one dies

Did you try "-B 1" ?

cu
--
 Nabil Sayegh

pgsql-novice by date:

Previous
From: Leandro Fanzone
Date:
Subject: Transactions
Next
From: Nabil Sayegh
Date:
Subject: Re: Transactions