Kevin Grittner kevin.gritt...@wicourts.gov writes:
I got a failure on the random test.
This used to be common. Peter tweaked the test a few years ago to
reduce the probability of failure, but IIRC it's still not zero (and
probably can't be made zero without rendering the test meaningless).
I
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
Robert Haas robertmh...@gmail.com writes:
On Mon, Apr 12, 2010 at 11:03 PM, Bruce Momjian br...@momjian.us wrote:
Fine, then we will just have to live with exclusion constraints and
contraint exclusion.
I am not necessarily 100% averse to changing it... just saying that it
shouldn't be done
Murali M. Krishna murali1...@yahoo.com writes:
I would like to start using gdb.
...
, but this is what I get.
gdb) attach 1731
Attaching to program: /usr/local/pgsql/bin/postgres, process 1731
ptrace: Operation not permitted.
Try running gdb as the postgres user, ie, su to postgres first.
Hi,
Does anyone know how to generate the following WAL records from psql?
I'm now fixing pg_lesslog, which I reported a bug. Now code is
almost okay and I'd like to add test tools to show pg_lesslog can
handle all the WAL record correctly.
XLOG_MULTIXACT_ZERO_OFF_PAGE
I'm breaking this out to a separate email thread, since i think the
original question may hvae been lost in the I've applied this patch
part that made people ignore it at the end of a long thread ;) There
are usually people who have thoughts about this kind of thing :-) So,
thoughts/suggestions on
On Tue, Apr 13, 2010 at 14:25, Chetan Suttraway
chetan.suttra...@enterprisedb.com wrote:
Hi,
I am trying to install postgres 8.4.3.1 on windows machine which has
chinese locale.
The install wizard throws warning message and continues.
However the logs show that initdb failed and so the
On Tue, Apr 13, 2010 at 6:08 PM, Magnus Hagander mag...@hagander.netwrote:
On Tue, Apr 13, 2010 at 14:25, Chetan Suttraway
chetan.suttra...@enterprisedb.com wrote:
Hi,
I am trying to install postgres 8.4.3.1 on windows machine which has
chinese locale.
The install wizard throws
On Tue, Apr 13, 2010 at 1:50 PM, Chetan Suttraway
chetan.suttra...@enterprisedb.com wrote:
On Tue, Apr 13, 2010 at 6:08 PM, Magnus Hagander mag...@hagander.net
wrote:
On Tue, Apr 13, 2010 at 14:25, Chetan Suttraway
chetan.suttra...@enterprisedb.com wrote:
Hi,
I am trying to install
On Thu, Apr 1, 2010 at 8:24 PM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Apr 1, 2010 at 7:18 AM, Simon Riggs si...@2ndquadrant.com wrote:
I'm not willing to investigate this further myself at this stage. This
looks like risk for little benefit.
That's kind of what I figured. I'll see
On Tue, Apr 13, 2010 at 9:18 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Thu, Apr 1, 2010 at 8:24 PM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Apr 1, 2010 at 7:18 AM, Simon Riggs si...@2ndquadrant.com wrote:
I'm not willing to investigate this further myself at this stage. This
On Tue, Apr 13, 2010 at 10:27 PM, Robert Haas robertmh...@gmail.com wrote:
Can you explain how to recreate the problem that this patch fixes?
1. Configure and start the primary server.
2. Configure the standby server.
3. Remove all of the WAL files in pg_xlog of the standby.
4. Start the
Simon Riggs wrote:
On Thu, 2010-04-08 at 19:02 +0300, Heikki Linnakangas wrote:
Simon Riggs wrote:
OK, that seems better. I'm happy with that instead.
Have you tested this? Is it ready to commit?
Only very briefly. I think the code is ready, but please review and test
to see I didn't miss
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
Robert Haas wrote:
On Tue, Apr 6, 2010 at 10:36 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Robert Haas wrote:
* If standby_mode is enabled, and neither primary_conninfo nor
restore_command are set, the standby would get stuck.
It's not really stuck, it will replay
Robert Haas wrote:
On Mon, Apr 12, 2010 at 6:41 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Why is standby_keep_segments used even if max_wal_senders is zero?
In that case, ISTM we don't need to keep any WAL files in pg_xlog
for the standby.
True. I don't think we
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
Tom Lane escribió:
Robert Haas robertmh...@gmail.com writes:
On Mon, Apr 12, 2010 at 11:03 PM, Bruce Momjian br...@momjian.us wrote:
Fine, then we will just have to live with exclusion constraints and
contraint exclusion.
I am not necessarily 100% averse to changing it... just saying
Magnus Hagander wrote:
Before I did that I wrote a small perlscript that reads pgtz.c and
compares what's there to what's in the registry of the current
machine. Turns out I had missed one, which is Argentina Standard Time.
This script should probably live in CVS, and be run when Microsoft
Alvaro Herrera alvhe...@commandprompt.com writes:
Magnus Hagander wrote:
This script should probably live in CVS, and be run when Microsoft
releases new timezone data. Where should I put it - src/timezone or
somewhere in src/tools? (it does read pgtz.c in the current directory,
but it doesn't
Heikki Linnakangas wrote:
I could reproduce this on my laptop, standby is about 20% slower. I ran
oprofile, and what stands out as the difference between the master and
standby is that on standby about 20% of the CPU time is spent in
hash_seq_search(). The callpath is GetSnapshotDat() -
Tom Lane wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
Magnus Hagander wrote:
This script should probably live in CVS, and be run when Microsoft
releases new timezone data. Where should I put it - src/timezone or
somewhere in src/tools? (it does read pgtz.c in the current
Joachim Wieland j...@mcknight.de writes:
If we still cannot do this, then what I am asking is: What does the
project need to be able to at least link against such a compression
algorithm?
Well, what we *really* need is a convincing argument that it's worth
taking some risk for. I find that
Josh Berkus j...@agliodbs.com writes:
There are basically 2 major parts for materialized views:
A) Planner: Getting the query planner to swap in the MatView for part of
a query automatically for query plan portions which the MatView supports;
B) Maintenance: maintaining the MatView data
Koichi Suzuki escribió:
Hi,
Does anyone know how to generate the following WAL records from psql?
I'm now fixing pg_lesslog, which I reported a bug. Now code is
almost okay and I'd like to add test tools to show pg_lesslog can
handle all the WAL record correctly.
p...@thetdh.com wrote:
It would be useful to have a relation such that all dirtied
buffers got written out even for failed transactions (barring
a crash) and such that read-any-undeleted were easy to do,
despite the non-ACIDity. The overhead of a side transaction
seems overkill for such
Josh Berkus wrote:
All,
Not sure when this happened, but someone added a very informative hint
for the case where you ambiguously refer to a base table name when you
needed to refer to the alias. Nice work, we should do more of this
helpful hinting.
I agree. I see this hint was added in
On Tue, Apr 13, 2010 at 8:01 PM, Bruce Momjian br...@momjian.us wrote:
Yea, having some things in our system be non-transactional is odd and
hard to understand. Just thinking about it, it seems it would introduce
all sorts of odd behaviors.
I think it would be really useful, though, for users
Robert Haas wrote:
On Tue, Apr 13, 2010 at 8:01 PM, Bruce Momjian br...@momjian.us wrote:
Yea, having some things in our system be non-transactional is odd and
hard to understand. ?Just thinking about it, it seems it would introduce
all sorts of odd behaviors.
I think it would be really
On Tue, Apr 13, 2010 at 8:24 PM, Bruce Momjian br...@momjian.us wrote:
I think it would be really useful, though, for users and maybe even
for system internals. Working out the semantics is a challenge, but
not an insurmountable one, I think.
Yea, it is going to feel like a ship with a leaky
On Tue, Apr 13, 2010 at 11:49 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Robert Haas wrote:
On Tue, Apr 6, 2010 at 10:36 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Robert Haas wrote:
* If standby_mode is enabled, and neither primary_conninfo
This replication test that was working well earlier (it ran daily), stopped
working
after reinstall of new instances of cvs HEAD. I think the change must have been
today (or at least
recent).
This test copies a schema from a 8.4.3 instance to the 9.0 primary:
pg_dump -c -h /tmp -p 5432 -n
On Wed, April 14, 2010 02:34, Erik Rijkers wrote:
This replication test that was working well earlier (it ran daily), stopped
working
after reinstall of new instances of cvs HEAD. I think the change must have
been today (or at least
recent).
This test copies a schema from a 8.4.3 instance
Alvaro-san;
Thank you for a great advice. I successfully generated all the WAL
records listed below. By deleteing and VACUUMing a table with
btree_gist based index, I was successful to generate all the GIST WAL
records.
Still have the following WAL record to create:
CLOG_TRUNCATE
35 matches
Mail list logo