On Fri, Mar 22, 2013 at 11:27 AM, Roberto Scattini <
roberto.scatt...@gmail.com> wrote:
>
>
> On Thursday, March 21, 2013, wd wrote:
> > You can combine warm standby and streaming, we do this in our product
> database.
> > When the standby is to far from the master, the slave will try to use
> re
On Thursday, March 21, 2013, wd wrote:
> You can combine warm standby and streaming, we do this in our product
database.
> When the standby is to far from the master, the slave will try to use
restore_command to restore the database(warm standby), when the standby
catch up the master, the steaming
You can combine warm standby and streaming, we do this in our product
database.
When the standby is to far from the master, the slave will try to use
restore_command to restore the database(warm standby), when the standby
catch up the master, the steaming will working again.
BTW: we use ominipitr.
On Thu, Mar 21, 2013 at 3:45 PM, Roberto Scattini <
roberto.scatt...@gmail.com> wrote:
>
> i mean, i can have both configurations enabled?
>>
>>
> no, i think my setup, with this config, is just doing warm standby. but
> the streaming replication was working before adding archive_command to
> mast
On Thu, Mar 21, 2013 at 3:32 PM, Roberto Scattini <
roberto.scatt...@gmail.com> wrote:
> hi list,
>
> i'm installing a streaming replication master-slave setup in ubuntu 12.04
> LTS, with postgresql 9.1
>
> the tutorials and the documentation are a very good start point, but i
> have one question
hi list,
i'm installing a streaming replication master-slave setup in ubuntu 12.04
LTS, with postgresql 9.1
the tutorials and the documentation are a very good start point, but i have
one question related to some fine grained configurations.
it is said that i should stop the master db in order t
Dear Riggs,
I am so sorry that i am not able to replicate it this time. May be i did
something really stupid that day .
I remember at one point of time i ran the standy without any recorvery.conf
even.
If i ever get that again i will surely try to replicate it and inform.
Regds
Rajesh Kumar Malla
On Sat, 2010-10-02 at 12:02 -0400, Rajesh Kumar Mallah wrote:
> FATAL: too many KnownAssignedXids
That's a bug.
I've a few guesses about that, but I'll put some better instrumentation
in to see if we can prove what's causing it.
Can you reproduce that again, or was that failure isolated to that
On Tue, Oct 5, 2010 at 4:04 PM, Rajesh Kumar Mallah
wrote:
>> > I am currently aiming to setup only SR between 2 servers only.
>>
>> "only SR" means that you don't need Hot Standby (i.e., you don't need to
>> run any query on the standby server)? If so, you can set wal_level to
>> archive instead
On Tue, Oct 5, 2010 at 12:09 AM, Fujii Masao wrote:
> On Tue, Oct 5, 2010 at 2:57 AM, Rajesh Kumar Mallah
> wrote:
> > I am currently aiming to setup only SR between 2 servers only.
>
> "only SR" means that you don't need Hot Standby (i.e., you don't need to
> run any query on the standby serve
On Tue, Oct 5, 2010 at 2:57 AM, Rajesh Kumar Mallah
wrote:
> I am currently aiming to setup only SR between 2 servers only.
"only SR" means that you don't need Hot Standby (i.e., you don't need to
run any query on the standby server)? If so, you can set wal_level to
archive instead of hot_standb
Dear Masao,
I would also like to inform that i observed the phenomenon only once. And i
am still not
too clear on the correct setup.
Regds
Rajesh Kumar Mallah.
>
> This looks like the bug of HS. But I'm not sure why KnownAssignedXids
> overflowed.
>
> Regards,
>
> --
> Fujii Masao
> NIPPON TELEGRA
Dear Masao ,
Thanks so much for the response ,
I actually i am in a position to do rigorous stress testing because i have
the machines at my disposal.
I am sorry that i was not in touch with the lists for a prolong duration and
could not followup much
on the discussions while HS & SR were being d
On Sun, Oct 3, 2010 at 1:02 AM, Rajesh Kumar Mallah
wrote:
> As an enduser i setup SR based on
> http://wiki.postgresql.org/wiki/Streaming_Replication
> The master & standby are both powerful machines and are on same gigabit
> switch.
> Things worked as expected I updated 1000's of records in sing
Dear List,
Firstly thanks to the postgresql global development team for releasing
postgresql
with such a great enterprise feature of SR & HS.
As an enduser i setup SR based on
http://wiki.postgresql.org/wiki/Streaming_Replication
The master & standby are both powerful machines and are on same gig
15 matches
Mail list logo
