On Sat, 2010-05-01 at 09:05 -0500, Jaime Casanova wrote:
> maybe we should be using the tables that exists in the regression
> database or adding hs_setup_primary in installcheck to prepare the
> regression database to run standbycheck in the standby server
This can definitely use some improvemen
On Sat, 2010-05-01 at 13:12 -0400, Tom Lane wrote:
> Simon Riggs writes:
> > On Sat, 2010-05-01 at 12:37 -0400, Tom Lane wrote:
> >> Where is this test procedure documented?
>
> > In src/test/regress/standby_schedule
>
> That's a good way to ensure nobody knows it's there :-(
>
> If you want us
Simon Riggs writes:
> On Sat, 2010-05-01 at 12:37 -0400, Tom Lane wrote:
>> Where is this test procedure documented?
> In src/test/regress/standby_schedule
That's a good way to ensure nobody knows it's there :-(
If you want users to run this, document it in cookbook fashion in
doc/src/sgml/regr
On Sat, 2010-05-01 at 12:37 -0400, Tom Lane wrote:
> Simon Riggs writes:
> > On Sat, 2010-05-01 at 09:05 -0500, Jaime Casanova wrote:
> >> maybe we should be using the tables that exists in the regression
> >> database or adding hs_setup_primary in installcheck to prepare the
> >> regression datab
Simon Riggs writes:
> On Sat, 2010-05-01 at 09:05 -0500, Jaime Casanova wrote:
>> maybe we should be using the tables that exists in the regression
>> database or adding hs_setup_primary in installcheck to prepare the
>> regression database to run standbycheck in the standby server
> That's part
On Sat, 2010-05-01 at 09:05 -0500, Jaime Casanova wrote:
> maybe we should be using the tables that exists in the regression
> database or adding hs_setup_primary in installcheck to prepare the
> regression database to run standbycheck in the standby server
That's part of the procedure already.
On Sat, May 1, 2010 at 7:22 AM, Simon Riggs wrote:
> On Mon, 2010-04-26 at 02:45 -0500, Jaime Casanova wrote:
>> On Mon, Apr 26, 2010 at 2:32 AM, Heikki Linnakangas
>> wrote:
>> >
>> > How many of the tests in the regular regression suite do anything useful
>> > when run against a standby server?
On Mon, 2010-04-26 at 02:45 -0500, Jaime Casanova wrote:
> On Mon, Apr 26, 2010 at 2:32 AM, Heikki Linnakangas
> wrote:
> >
> > How many of the tests in the regular regression suite do anything useful
> > when run against a standby server? They all have to set up a bunch of
> > objects before they
On Mon, Apr 26, 2010 at 2:32 AM, Heikki Linnakangas
wrote:
>
> How many of the tests in the regular regression suite do anything useful
> when run against a standby server? They all have to set up a bunch of
> objects before they run queries, so you just get a lot of errors
> complaining that you
Jaime Casanova wrote:
> On Wed, Apr 14, 2010 at 9:16 AM, Jaime Casanova
> wrote:
>> 3) it should execute the existing set of tests (the ones installcheck
>> execute) but with a new set of expected results, that way we can be
>> sure that what should be disallowed is disallowed and that the
>> data
On Wed, Apr 14, 2010 at 9:16 AM, Jaime Casanova
wrote:
> On Sat, Apr 10, 2010 at 12:23 AM, Jaime Casanova
> wrote:
>> On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
>> wrote:
>>>
>>
>> i think "make standbycheck" needs a little more work, why it isn't
>> accesible from top of source dir?
>>
>
>
On Sat, Apr 10, 2010 at 12:23 AM, Jaime Casanova
wrote:
> On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
> wrote:
>>
>
> i think "make standbycheck" needs a little more work, why it isn't
> accesible from top of source dir?
>
what i want to do.
1) make standbycheck should be accesible from top
On Tue, 2010-04-13 at 10:41 -0500, Jaime Casanova wrote:
> On Mon, Apr 12, 2010 at 1:23 AM, Jaime Casanova
> wrote:
> >
> > another point, what happened with this:
> > http://archives.postgresql.org/message-id/1229549172.4793.105.ca...@ebony.2ndquadrant?
> > Obviously we still have the problem wit
On Tue, Apr 13, 2010 at 11:06 AM, Heikki Linnakangas
wrote:
> Jaime Casanova wrote:
>>
>> i will read it on the morning and the thread where it is, something
>> that seems strange to me is that the patch touch twophase.c and
>> twophase.h, why?
>
> When you start hot standby from an online checkpo
Jaime Casanova wrote:
> On Mon, Apr 12, 2010 at 8:32 PM, Fujii Masao wrote:
>> But when I did one more restart of the primary and standby, I was
>> able to observe the problem. If this is the same as you encountered,
>> it would be the "can't start hot standby from a shutdown checkpoint"
>> issue
On Mon, Apr 12, 2010 at 1:23 AM, Jaime Casanova
wrote:
>
> another point, what happened with this:
> http://archives.postgresql.org/message-id/1229549172.4793.105.ca...@ebony.2ndquadrant?
> Obviously we still have the problem with hash indexes, and in that
> thread Tom advice was just to document
On Mon, Apr 12, 2010 at 8:32 PM, Fujii Masao wrote:
> On Mon, Apr 12, 2010 at 11:27 PM, Jaime Casanova
> wrote:
>>> 1. start the primary
>>> 2. pg_start_backup()
>>> 3. copy $PGDATA from the primary to the standby
>>> 4. pg_stop_backup();
>>> 5. create the recovery.conf and start the standby
>>
>
On Mon, Apr 12, 2010 at 11:27 PM, Jaime Casanova
wrote:
>> 1. start the primary
>> 2. pg_start_backup()
>> 3. copy $PGDATA from the primary to the standby
>> 4. pg_stop_backup();
>> 5. create the recovery.conf and start the standby
>
> execute some WAL-logged action (i've seen this happen even wit
On Mon, Apr 12, 2010 at 9:27 AM, Jaime Casanova
wrote:
> On Mon, Apr 12, 2010 at 1:48 AM, Fujii Masao wrote:
>> On Mon, Apr 12, 2010 at 3:29 PM, Jaime Casanova
>> wrote:
>>> On Mon, Apr 12, 2010 at 1:21 AM, Fujii Masao wrote:
Didn't the standby
accept connections before executing pgbe
On Mon, Apr 12, 2010 at 1:48 AM, Fujii Masao wrote:
> On Mon, Apr 12, 2010 at 3:29 PM, Jaime Casanova
> wrote:
>> On Mon, Apr 12, 2010 at 1:21 AM, Fujii Masao wrote:
>>> Didn't the standby
>>> accept connections before executing pgbench?
>>>
>>
>> nop, and last time i try it was in that state fo
Jaime Casanova wrote:
> On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
> wrote:
>> but, my main concern is why it was asking for
>> "00010006"? is this normal? is this standby's way of
>> saying i'm working but i have nothing to do?
Yes.
>> when that happens after a standby resta
On Mon, Apr 12, 2010 at 3:29 PM, Jaime Casanova
wrote:
> On Mon, Apr 12, 2010 at 1:21 AM, Fujii Masao wrote:
>> Didn't the standby
>> accept connections before executing pgbench?
>>
>
> nop, and last time i try it was in that state for an hour (without
> accepting connections)... after that i exe
On Mon, Apr 12, 2010 at 1:21 AM, Fujii Masao wrote:
> Didn't the standby
> accept connections before executing pgbench?
>
nop, and last time i try it was in that state for an hour (without
accepting connections)... after that i execute on the primary: CREATE
TABLE tt2 AS SELECT generate_series(1,
On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
wrote:
>
> but, my main concern is why it was asking for
> "00010006"? is this normal? is this standby's way of
> saying i'm working but i have nothing to do?
> when that happens after a standby restart, is normal that i have to
> wait
On Sat, Apr 10, 2010 at 5:39 AM, Jaime Casanova
wrote:
> i'm startint to try Hot Standby & Streaming Replication, so i started
> a replication:
Great!
> but, my main concern is why it was asking for
> "00010006"? is this normal?
The standby server tries to replay all of the avai
On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
wrote:
> Hi,
>
> i'm startint to try Hot Standby & Streaming Replication, so i started
> a replication:
>
i think "make standbycheck" needs a little more work, why it isn't
accesible from top of source dir?
For now, to excercise it i have to do (on
26 matches
Mail list logo
