WAL archive, warm backup and read-only slave

Started by Nonameover 16 years ago2 messages
#1Noname
pgsql@mohawksoft.com

How difficult would it be, and does anyone think it is possible to have a
continuous "restore_command" ala pg_standby running AND have the database
operational in a "read-only" mode?

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: WAL archive, warm backup and read-only slave

pgsql@mohawksoft.com writes:

How difficult would it be, and does anyone think it is possible to have a
continuous "restore_command" ala pg_standby running AND have the database
operational in a "read-only" mode?

See all the discussion of "hot standby" over the past eight or so months.

regards, tom lane