From: Alvaro Herrera alvhe...@2ndquadrant.com
MauMau escribió:
One concern is that umount would fail in such a situation because
postgres has some open files on the filesystem, which is on the
shared disk in case of traditional HA cluster.
See my reply to Noah. If postmaster stays around
waiting for backends to terminate after sending SIGQUIT. The state
name is natural.
I don't have strong objection to your idea if it makes the code cleaner and
more understandable. Thank you very much.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
not be able to respond to the immediate shutdown request.
What DBAs want from pg_ctl stop -mi is to shutdown the database server as
immediately as possible. So I think 5 second is reasonable.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
shutdown.
Some problems with killall -9 postgres are:
1. It's not available on Windows.
2. It may kill other database server instances running on the same machine.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
, especially in the documentation and source code
comments, as English is not my mother tongue.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
really name it SignalAlmostAllChildren(), could we ..
I see. thank you.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
From: Jeff Janes jeff.ja...@gmail.com
On Tue, Jun 18, 2013 at 3:40 PM, MauMau maumau...@gmail.com wrote:
Really? Would the catcache be polluted with entries for nonexistent
tables? I'm surprised at this. I don't think it is necessary to speed up
the query that fails with nonexistent tables
and a reasonable behavior, is it described
anywhere?
Regards
MauMau
myfunc.pgc
Description: Binary data
myfunc.sql
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
function is irrelevant. The
leak occurs even when you do not use PL/pgSQL.
[Wordaround]
Use CREATE TABLE IF NOT EXISTS and TRUNCATE (or ON COMMIT DROP in case of
temporary tables) to avoid repeated creation/deletion of the same table.
Regards
MauMau
--
Sent via pgsql-hackers mailing list
would you approach this?
Thanks Craig, you gave me some interesting insights. All of these topics
are interesting, and I'd like to work on them when I have acquired enough
knowledge and experience in PostgreSQL development.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql
From: Craig Ringer cr...@2ndquadrant.com
On 06/09/2013 08:32 AM, MauMau wrote:
- Failure of a disk containing data directory or tablespace
If checkpoint can't write buffers to disk because of disk failure,
checkpoint cannot complete, thus WAL files accumulate in pg_xlog/.
This means that one
hope PostgreSQL will provide a reliable archiving facility that is ready
to use.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
From: Joshua D. Drake j...@commandprompt.com
On 06/08/2013 07:36 AM, MauMau wrote:
3. You cannot know the reason of archive_command failure (e.g. archive
area full) if you don't use PostgreSQL's server logging.
This is because archive_command failure is not logged in syslog/eventlog.
Wait
can't happen events has
occurred like PostgreSQL's bug. I didn't expect postgres dumps core simply
because disk is full. I want postgres to shutdown with FATAL message in
that exact case.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
full is encountered at end-of-recovery
checkpoint, force archiving all unarchived WAL files and delete/recycle them
at that time.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
if all of the child
processes do not terminate within 10 seconds since the start of immediate
shutdown or FatalError condition.
3. On Windows, kill(SIGKILL) calls TerminateProcess().
4. Documentation change to describe the behavior of immediate shutdown.
Regards
MauMau
As I promised yesterday, I'll show you the precise call stack:
#0 0x003fa0cf542e in __lll_lock_wait_private () from /lib64/libc.so.6
#1 0x003fa0c7bed5 in _L_lock_9323 () from /lib64/libc.so.6
#2 0x003fa0c797c6 in malloc () from /lib64/libc.so.6
#3 0x003fa0c2fd99 in
From: Tom Lane t...@sss.pgh.pa.us
MauMau maumau...@gmail.com writes:
How about the case where some backend crashes due to a bug of PostgreSQL?
In this case, postmaster sends SIGQUIT to all backends, too. The
instance
is expected to disappear cleanly and quickly. Doesn't the hanging
backend
From: Peter Eisentraut pete...@gmx.net
On 1/30/13 9:11 AM, MauMau wrote:
When I ran pg_ctl stop -mi against the primary, some applications
connected to the primary did not stop. The cause was that the backends
was deadlocked in quickdie() with some call stack like the following.
I'm sorry
? If it's okay
and you want, I'll submit the patch.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
From: Tom Lane t...@sss.pgh.pa.us
MauMau maumau...@gmail.com writes:
I think the solution is the typical one. That is, to just remember the
receipt of SIGQUIT by setting a global variable and call siglongjmp() in
quickdie(), and perform tasks currently done in quickdie() when
sigsetjmp
From: Fujii Masao masao.fu...@gmail.com
On Sun, Jan 27, 2013 at 12:17 AM, MauMau maumau...@gmail.com wrote:
Although you said the fix will solve my problem, I don't feel it will.
The
discussion is about the crash when the standby restarts after the
primary
vacuums and truncates a table
From: Fujii Masao masao.fu...@gmail.com
On Thu, Jan 24, 2013 at 11:53 PM, MauMau maumau...@gmail.com wrote:
I'm wondering if the fix discussed in the above thread solves my problem.
I
found the following differences between Horiguchi-san's case and my case:
(1)
Horiguchi-san says the bug
From: Fujii Masao masao.fu...@gmail.com
On Thu, Jan 24, 2013 at 7:42 AM, MauMau maumau...@gmail.com wrote:
I searched through PostgreSQL mailing lists with WAL contains references
to
invalid pages, and i found 19 messages. Some people encountered similar
problem. There were some discussions
might relate to this problem. Does this fix
the problem?
[BUG] lag of minRecoveryPont in archive recovery
http://www.postgresql.org/message-id/20121206.130458.170549097.horiguchi.kyot...@lab.ntt.co.jp
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
will
not be overwritten.
Could you give me opinions what to do? I'm willing to submit these fixes.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
tomorrow or the next day. Could you include the fix in the
weekend release?
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
of use of PostgreSQL.
So I believe PG should handle the problem, not the archive_command.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
think about this fix?
I think having PG automatically destroy archive files is bordering on
insane.
I agree. Before that, PG cannot know the archive location, so PG cannot
delete the partially filled archive files.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers
From: Kevin Grittner kevin.gritt...@wicourts.gov
MauMau maumau...@gmail.com wrote:
For information, what kind of breakage would occur?
I imagined removing KEEPONLYALNUM would just accept
non-alphanumeric characters and cause no harm to those who use
only alphanumeric characters.
This would
From: Fujii Masao masao.fu...@gmail.com
On Thu, May 10, 2012 at 8:18 AM, Euler Taveira eu...@timbira.com wrote:
On 09-05-2012 19:17, MauMau wrote:
Then, does it make sense to remove #define KEEPONLYALNUM in 9.1.4?
Would it
cause any problems? If no, I wish that, because it eliminates the need
From: Kevin Grittner kevin.gritt...@wicourts.gov
MauMau maumau...@gmail.com wrote:
For information, what kind of breakage would occur?
I imagined removing KEEPONLYALNUM would just accept
non-alphanumeric characters and cause no harm to those who use
only alphanumeric characters.
This would
KEEPONLYALNUM
in contrib/pg_trgm/trgm.h? If no, what kind of problems would happen?
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
From: Fujii Masao masao.fu...@gmail.com
On Wed, May 9, 2012 at 9:10 PM, MauMau maumau...@gmail.com wrote:
This question may be appropriate for pgsql-general, but let me ask here
because the only relevant discussion seems to have been done on
pgsql-hackers:
http://archives.postgresql.org/pgsql
Hello
I encountered a bug which always causes PostgreSQL to crash on Windows.
Attached is a patch that fixes it. Please review it and include it in the
upcoming minor releases of supported versions.
The following is a bug report.
Your name :MauMau
Your email address :maumau...@gmail.com
.
if (old_pid != 0)
{
pg_usleep(100);
pid = get_pgpid();
if (pid == old_pid postmaster_is_alive(pid))
{
write_stderr(_(%s: could not start server\n
Examine the log output.\n),
progname);
exit(1);
}
}
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers
() sets the process handle in the structure passed
to it. We can pass the process handle to WaitForSingleObject8) to know
whether postmaster is alive.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
() sets the process handle in the structure passed
to it. We can pass the process handle to WaitForSingleObject8) to know
whether postmaster is alive.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
effective solution will be accepted.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
From: Magnus Hagander mag...@hagander.net
2011/7/16 MauMau maumau...@gmail.com:
Hello,
The attached file is a revised patch which reflects all review comments by
Magnus in:
http://archives.postgresql.org/pgsql-hackers/2011-07/msg00839.php
I have applied this patch after another round
/SysCache may be the cause.
2011/9/28 MauMau maumau...@gmail.com:
Q1: When are the RelCache/SysCache entries removed from
CacheMemoryContext?
Are they removed only when the corresponding relations are deleted? If so,
many tables and indexes is not friendly for the current PostgreSQL?
Regards
MauMau
/SysCache. As
far as I read the code, PostgreSQL seems to use memory for RelCache/SysCache
without limit until the relations are dropped.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
the reason. I will
report it to the customer and ask him to consider taking the following
measures:
* reduce shared_buffers
* run somefunc() and VACUUM in different psql sessions
* process 100,000 tables in multiple psql sessions
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql
to rethink your schema. 10 tables is
far beyond what any sane design could require, and is costing you on
many levels (I'm sure the OS and filesystem aren't that happy with it
either).
I agree. I'll suggest that to the customer, too. Thank you very much.
Regards
MauMau
--
Sent via pgsql
., somefunc just copy records), the virtual memory of
postgres does not increase.
Is there anything to reason about his comment?
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
From: Tom Lane t...@sss.pgh.pa.us
MauMau maumau...@gmail.com writes:
I re-submitted a patch and added a comment on the page below. I chose
patch from the comment type drop-down box, but the patch status does
not
change from waiting on author. I expected the patch status would become
needs
() and
set PostgreSQL to it in DllInstall(). DllInstall() is not called when /i
is not specified. So, event_source remains empty.
To solve the problem, we need to use wcstombs_s() instead of strncpy(), and
initialize event_source to PostgreSQL when it is defined.
Regards
MauMau
--
Sent via
open CommitFest 2001-9 shortly. Please
review it again.
Regards
MauMau
multi_event_source_v2.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
on the same machine to
distinguish themselves in the event log Edit Patch - Move To Another
CommitFest - Delete Patch
https://commitfest.postgresql.org/action/patch_view?id=562
What should I do? Where should I refer to handle patch status correctly?
Regards
MauMau
--
Sent via pgsql-hackers mailing
for me.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
MLs
such as pgsql-general, pgsql-jdbc etc.
What could be wrong?
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Items list a few days
later. (But I'm reluctant to pollute those pages with bug fixes which apply
to previous versions. That can't be helped.)
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
through system() call.
Please give me your ideas. Of course, I would be very happy if some
experienced community member could address this problem.
And finally, do you think this should be handled as a bug, or an improvement
in 9.2?
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql
Hello,
I posted a patch for bug #6011 to pgsql-hackers several days ago. How can I
check the status of bug fixes? I'm worried that the patch might be
forgotten, because bug #5842 was missed for two months until Bruce noticed
it.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql
From: Tom Lane t...@sss.pgh.pa.us
MauMau maumau...@gmail.com writes:
The bad thing is that pg_ctl continues to wait until the specified
duration
passes, even if postgres fails to start. For example, it is naturally
desirable for pg_ctl to terminate when postgresql.conf contains a syntax
error
counts such as the number of bugs per major/minor release,
not-fixed bugs, new features in each major release, etc.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
if someone could test it
on 64-bit Windows who has the 64-bit environment.
I'll add this patch to the first CommitFest of 9.2. Thank you in advance for
reviewing it.
Regards
MauMau
multi_event_source.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers
Andrew,
From: Andrew Dunstan and...@dunslane.net
builddoc.bat failed on my system and reading it made my head hurt. So I
did what I've done with other bat files and rewrote it in Perl. The
result is attached. It works for me, and should be a dropin replacement.
Just put it in the src/tools/msvc
From: Kevin Grittner kevin.gritt...@wicourts.gov
MauMau maumau...@gmail.com wrote:
Make pg_ctl's -s option suppress informational event logging.
This will ultimately be up to a committer (and I'm not one), but to
me it seems reasonable to back-patch if it is addressed this way
.
Yes, I was torn between pgsql-hackers and pgsql-general. I didn't want to
unintentionally give misconception about 9.0 quality to general users, so I
kept the mail here in the end.
Regards,
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
From: Andrew Dunstan and...@dunslane.net
On Thu, May 19, 2011 10:32 am, Robert Haas wrote:
2011/5/16 MauMau maumau...@gmail.com:
Can't open perl script make-errcodes-table.pl: No such file or
directory
I think this is the root of the problem. We have no script called
make-errcodes-table.pl
4.01 Transitional//EN
http://www.w3.org/TR/html4/loose.dtd;
HTML
HEAD
TITLE
PostgreSQL 9.1beta1 Documentation/TITLE
META
...
/BODY
/HTML
Docs build complete.
--
Regards,
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers
servicename] [-U username] [-P password] [-D datadir]
[-w] [-t seconds] [-o options]
Regards,
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
that some committer will modify and commit the
change directly?
Regards,
MauMau
From: MauMau maumau...@gmail.com
Sent: Saturday, May 07, 2011 9:35 AM
Subject: Re: [BUGS] BUG #6011: Some extra messages are output in the event
log at PostgreSQL startup
Magnus Hagander mag...@hagander.net writes:
Any
because
starting/stopping the database/application is infrequent once the system is
in steady operation. -- this may sound abrupt, though.
Regards,
MauMau
- Original Message -
From: Dave Page dp...@pgadmin.org
To: Tom Lane t...@sss.pgh.pa.us
Cc: MauMau maumau...@gmail.com; pgsql-hackers
From: Tom Lane t...@sss.pgh.pa.us
MauMau maumau...@gmail.com writes:
I've encountered one problem on Windows. I need to support running all of
my
products on one host simultaneously. Plus, I need to log messages in
syslog/event log. On Linux, I can distinguish the messages of one product
.
Regards
MauMau
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
I'm sorry that I've mistakenly sent an empty mail. This is the intended
mail.
Andrew Dunstan and...@dunslane.net wrote in message
news:4d889879.3080...@dunslane.net...
On 03/22/2011 08:22 AM, MauMau wrote:
I would appreciate your opinions and advice. I'll try making the patch
while I'm
301 - 369 of 369 matches
Mail list logo