Skip to main content
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Improved formatting
Source Link
RDFozz
  • 11.7k
  • 4
  • 24
  • 38

I have a postgres solution on aws/rds with a master and a read replica.

_________________________master____slave
hot_standby_______________on________on
transaction_read_only_______on________on
pg_is_in_recovery()_________true_______true

                         master    slave
hot_standby               on        on
transaction_read_only     on        on
pg_is_in_recovery()       true      true

Having the master set in this way the vacuum and analyze process don't work. Any idea how to change this setting? thank you!

I have a postgres solution on aws/rds with a master and a read replica.

_________________________master____slave
hot_standby_______________on________on
transaction_read_only_______on________on
pg_is_in_recovery()_________true_______true

Having the master set in this way the vacuum and analyze process don't work. Any idea how to change this setting? thank you!

I have a postgres solution on aws/rds with a master and a read replica.

                         master    slave
hot_standby               on        on
transaction_read_only     on        on
pg_is_in_recovery()       true      true

Having the master set in this way the vacuum and analyze process don't work. Any idea how to change this setting? thank you!

added 38 characters in body
Source Link
vcarusi
  • 21
  • 1
  • 3

I have a postgres solution on aws/rds with a master and a read replica.

                   master  slave

hot_standby on on transaction_read_only on on pg_is_in_recovery() true true

_________________________master____slave
hot_standby_______________on________on
transaction_read_only_______on________on
pg_is_in_recovery()_________true_______true

Having the master set in this way the vacuum and analyze process don't work. Any idea how to change this setting? thank you!

I have a postgres solution on aws/rds with a master and a read replica.

                   master  slave

hot_standby on on transaction_read_only on on pg_is_in_recovery() true true

Having the master set in this way the vacuum and analyze process don't work. Any idea how to change this setting? thank you!

I have a postgres solution on aws/rds with a master and a read replica.

_________________________master____slave
hot_standby_______________on________on
transaction_read_only_______on________on
pg_is_in_recovery()_________true_______true

Having the master set in this way the vacuum and analyze process don't work. Any idea how to change this setting? thank you!

Source Link
vcarusi
  • 21
  • 1
  • 3

how can be changed hot_standby parameter on postgres 9.6 aws/rds?

I have a postgres solution on aws/rds with a master and a read replica.

                   master  slave

hot_standby on on transaction_read_only on on pg_is_in_recovery() true true

Having the master set in this way the vacuum and analyze process don't work. Any idea how to change this setting? thank you!