09.08.2011, 20:52, "Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx>: > Vladimir Protasov <eoranged@xxxxx> wrote: > >> I want to completely disallow postgres to write WAL and turn it to >> read-only instance WAL-compatible with another instance. >> It is guarantied that there will be no write queries to the >> server, but I need to be sure about WAL. > > Have you considered setting it up as a hot standby, but then not > feeding it a WAL stream? Looks like what I've looked for. Thanks. > > -Kevin -- Best regards, Vladimir Protasov. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin