Thread: Read-only postgres instance
Hi, guys! 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. Is it possible? -- Best regards, Vladimir Protasov.
Vladimir Protasov <eoranged@ya.ru> 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? -Kevin
What with queries need temporary tables? 2011/8/5, Vladimir Protasov <eoranged@ya.ru>: > Hi, guys! > 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. > > Is it possible? > > -- > Best regards, > Vladimir Protasov. > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- ------------ pasman
Creating a temp table is not a read-only operation. On Aug 9, 2011, at 11:19 AM, pasman pasmański wrote: > What with queries need temporary tables? -- Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice
09.08.2011, 20:52, "Kevin Grittner" <Kevin.Grittner@wicourts.gov>: > Vladimir Protasov <eoranged@ya.ru> 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.