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 improvement
On Mon, 2010-04-26 at 02:45 -0500, Jaime Casanova wrote:
On Mon, Apr 26, 2010 at 2:32 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com 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
On Sat, May 1, 2010 at 7:22 AM, Simon Riggs si...@2ndquadrant.com wrote:
On Mon, 2010-04-26 at 02:45 -0500, Jaime Casanova wrote:
On Mon, Apr 26, 2010 at 2:32 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
How many of the tests in the regular regression suite do anything
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.
We
Simon Riggs si...@2ndquadrant.com 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
On Sat, 2010-05-01 at 12:37 -0400, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com 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
Simon Riggs si...@2ndquadrant.com 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
On Sat, 2010-05-01 at 13:12 -0400, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com 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
On Wed, Apr 14, 2010 at 9:16 AM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
On Sat, Apr 10, 2010 at 12:23 AM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
i think make standbycheck needs a
Jaime Casanova wrote:
On Wed, Apr 14, 2010 at 9:16 AM, Jaime Casanova
jcasa...@systemguards.com.ec 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
On Mon, Apr 26, 2010 at 2:32 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com 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
On Tue, 2010-04-13 at 10:41 -0500, Jaime Casanova wrote:
On Mon, Apr 12, 2010 at 1:23 AM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
another point, what happened with this:
http://archives.postgresql.org/message-id/1229549172.4793.105.ca...@ebony.2ndquadrant?
Obviously we still
On Sat, Apr 10, 2010 at 12:23 AM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
jcasa...@systemguards.com.ec 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)
On Mon, Apr 12, 2010 at 8:32 PM, Fujii Masao masao.fu...@gmail.com wrote:
On Mon, Apr 12, 2010 at 11:27 PM, Jaime Casanova
jcasa...@systemguards.com.ec 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
On Mon, Apr 12, 2010 at 1:23 AM, Jaime Casanova
jcasa...@systemguards.com.ec 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
Jaime Casanova wrote:
On Mon, Apr 12, 2010 at 8:32 PM, Fujii Masao masao.fu...@gmail.com 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
On Tue, Apr 13, 2010 at 11:06 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com 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
On Sat, Apr 10, 2010 at 5:39 AM, Jaime Casanova
jcasa...@systemguards.com.ec 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
On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
jcasa...@systemguards.com.ec 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
On Mon, Apr 12, 2010 at 1:21 AM, Fujii Masao masao.fu...@gmail.com 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
On Mon, Apr 12, 2010 at 3:29 PM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
On Mon, Apr 12, 2010 at 1:21 AM, Fujii Masao masao.fu...@gmail.com 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
Jaime Casanova wrote:
On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
jcasa...@systemguards.com.ec 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
On Mon, Apr 12, 2010 at 1:48 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Mon, Apr 12, 2010 at 3:29 PM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
On Mon, Apr 12, 2010 at 1:21 AM, Fujii Masao masao.fu...@gmail.com wrote:
Didn't the standby
accept connections before executing
On Mon, Apr 12, 2010 at 9:27 AM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
On Mon, Apr 12, 2010 at 1:48 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Mon, Apr 12, 2010 at 3:29 PM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
On Mon, Apr 12, 2010 at 1:21 AM, Fujii Masao
On Mon, Apr 12, 2010 at 11:27 PM, Jaime Casanova
jcasa...@systemguards.com.ec 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
On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
jcasa...@systemguards.com.ec 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
26 matches
Mail list logo