Re: [ADMIN] Read-only postgres instance

2011-08-10 Thread Vladimir Protasov
09.08.2011, 20:52, "Kevin Grittner" : > Vladimir Protasov 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

Re: [ADMIN] Read-only postgres instance

2011-08-09 Thread Scott Ribe
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_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admi

Re: [ADMIN] Read-only postgres instance

2011-08-09 Thread pasman pasmański
What with queries need temporary tables? 2011/8/5, Vladimir Protasov : > 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 b

Re: [ADMIN] Read-only postgres instance

2011-08-09 Thread Kevin Grittner
Vladimir Protasov 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

[ADMIN] Read-only postgres instance

2011-08-09 Thread Vladimir Protasov
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. --