| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
| Cc: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, petsku(at)petteriraty(dot)eu, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #7549: max_connections check should query master when starting standby |
| Date: | 2012-09-26 16:04:04 |
| Message-ID: | 20120926160404.GD11785@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, Sep 18, 2012 at 09:09:13PM +0900, Fujii Masao wrote:
> On Tue, Sep 18, 2012 at 3:48 PM, Heikki Linnakangas
> <hlinnakangas(at)vmware(dot)com> wrote:
> > On 18.09.2012 09:46, Craig Ringer wrote:
> >>
> >> On 09/18/2012 07:57 AM, Fujii Masao wrote:
> >>>
> >>> If you change the max_connections on the master, you need to take a
> >>> fresh backup from the master and start the standby from it.
> >>
> >>
> >> WTF, really?
> >
> >
> > No. It's enough to bump up max_connections on the standby, and restart.
>
> Hmm... Petteri wants to solve the issue without changing anything
> on the standby, according to his original post. So in his case, a fresh
> backup is required.
>
> Of course my previous answer was confusing...
I assume you mean the slave needs an updated copy of the master's
config file changes, not an entire copy of the data directory.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mtesfaye | 2012-09-26 16:25:21 | BUG #7569: WHERE .. IN bug from 9.2.0 not fixed in 9.2.1 |
| Previous Message | Tom Lane | 2012-09-26 15:59:26 | Re: [DOCS] BUG #7543: Invalid table alias: DELETE FROM table * |