I am not familiar with swarm cluster nor repmgr. So I wonder why you
wouldn't be able to get to the goal you are trying to achieve without
repmgr. Can you please elaborate more?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http
way... I am not sure what you mean by "Master-Master mode" but if
that means you want to issue write queries by connecting to any of
Pgpool-II port, it's already possible in the set up you have created.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp
etters etc. as one of the organizers of the conference.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
; "main_instance"."created", "main_instance"."modified",
> "main_instance"."version", "main_instance"."capacity" FROM "main_instance"
> LIMIT 1 FOR UPDATE NOWAIT
Your session (transction) tried to get
C channel for PostgreSQL.
https://www.postgresql.org/community/irc/
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
need to check the other_pgpool_hostname, other_pgpool_port or
other_wd_port
config values.
If you have further questions, please post to pgpool-gene...@pgpool.net.
https://www.pgpool.net/mailman/listinfo/pgpool-general
Best
extended protocol without server side
> prepares...
Quite correct. Just setting the prepare threshold to 0 does not
prevent PostgreSQL from using extended queries. So the only way not
using extended queires with JDBC is setting the protocol version to 2.
I wonder why PostgreSQL JDBC does not prov
ple vs. extended query
> protocol within v3.
It seems Presto uses v3 protocol only when ODBC driver is used. If
JDBC is used, it is required to set "protocolVersion=2" property of
JDBC driver, which means v2 protocol is used I think.
https://github.com/treasure-data/prestogres#lim
You can disable persistent connection feature of pg_pconnect by
tweaking php.ini.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
Michael,
He already posted the identical question to the Pgpool-II mailing list
yesterday.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> On Wed, Oct 12, 2016 at 10:04 AM, Dylan Luong <dylan.lu...@unisa.
.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Simple question: Is there any reason for event trigger to not support
CREATE/ALTER ROLE/USER?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
ybe we could defer the truncation on the standby in some cases.
Do we want to add this to the TODO list?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postg
recovery
DETAIL: User was holding a relation lock for too long.
HINT: In a moment you should be able to reconnect to the database and repeat
your command.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing th
as not any help in this case:
https://www.postgresql.org/message-id/20130829.164457.863984798767991096.t-ishii%40sraoss.co.jp
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing li
_md5_authentication_through_pgpool-II_but_it_does_not_work._Why.3F
and this:
http://pgpool.net/mediawiki/index.php/FAQ#md5_authentication_does_not_work._Please_help
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.c
toy project, that's fine. But for
serious project it might bring bad performance and users will be
disappointed and speak like "PostgreSQL is slower than MySQL". I saw
that with Zabbix, for example.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en
> On 7/18/2016 9:14 PM, Tatsuo Ishii wrote:
>> I found following comment for using PostgreSQL with MediaWiki:
>>
>> https://www.mediawiki.org/wiki/Compatibility#Database
>>
>> "Anything other than MySQL or MariaDB is not recommended for
>> produc
community to enhance this?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail
I specific mailing list.
http://www.pgpool.net/mailman/listinfo/pgpool-general
> Database-- Postgresql 9.1
> OS -- Linux 6
>
>
> Thanks & Regards,
> Sunil N Shinde
Best regards,
--
Tatsuo
alizable" (or its
variants) are issued, pgpool-II will redirect all subsequent queries
to the primary server until the transaction ends.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-gener
uldn't forward these statements
> to slaves.
Yeah, PostgreSQL used to accept the command on standbys (at least in
9.0). The restriction was added later on. It woule be nice if you send
a bug report to the pgpool-II bug tracker to not forget it.
http://pgpool.net/mediawiki/index.php/Bug_tracking_sys
> I had no idea PowerGres was still going.
>
> You know I threw out an entire box of PowerGres 7.3 CDs when I moved?
PowerGres 7.3! So old days...
> They were in the back of a closet.
Probably I still have a GreatBridge CDs in my house :-)
--
Tatsuo Ishii
SRA OSS, Inc. Japan
E
n AWS as a
> service.
>
> Vertica: Another PostgreSQL-based column store. Unclear on how much
> PostgreSQL code it uses, but uses a version of the PostgreSQL protocol
> and psql client.
>
> FAST: Fujitsu's spin of PostgreSQL, optimized for high performance on
> high-
d to "attach" 'the new standby to make it online
by using pcp_attach_node.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> On 1/6/16 7:03 PM, Tatsuo Ishii wrote:
>> Is it possible to get the parse tree in a C trigger function which is
>> invoked when DML (INSERT/UPDATE/DELETE against a view) is executed?
>
> Yes, it's in fcinfo->flinfo->fn_expr.
Thanks for the info. But is this the p
Is it possible to get the parse tree in a C trigger function which is
invoked when DML (INSERT/UPDATE/DELETE against a view) is executed?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general
> I noticed, that 9.5 release notes (beta2) do not mention
> commit 7e2a18a9161fee7e67642863f72b51d77d3e996.
>
>
> I think this one should be added.
+1.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.c
nificant than this.
It's possible that novice admins accidentally remove postmaster.pid (I
saw this kind of incidents a few times while supporting customers if
my memory serves). Anyway I am happy as long as it's clearly
documented in the release notes of the next versions.
Best regards,
--
Tatsuo Ishii
assume your SSL setting is perfect. If you are not sure, please take
a look at FAQ:
http://pgpool.net/mediawiki/index.php/FAQ#How_can_I_set_up_SSL_for_pgpool-II.3F
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgs
it by hacking pgpool-II. It has built-in raw parser with
some functions to walk through the tree such as
raw_expression_tree_walker(). Also you could do the rewriting only
for particular applications (of course only if the application set
application name).
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
The question is specifically about the replication feature mentioned here
http://www.pgpool.net/mediawiki/index.php/Main_Page for the purposes of
failing over minimizing downtime
this?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
if it was standby.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
*Will J. Dunn*
*willjdunn.com http://willjdunn.com*
On Tue, Jul 21, 2015 at 4:27 PM, Joshua D. Drake j...@commandprompt.com
wrote:
On 07/21/2015 01:21 PM
table.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
check of pgpool, which is pretty much
similar to heartbeat.
If you are up for a commercial product, you may want to consider using
something like EnterpriseDB's failover manager.
Commercial support for pgpool-II is provided by the way.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English
with mysql-proxy. However quick googling suggests
that mysql-proxy is resemble to pgpool-II except that pgpool-II has
failover functionality, while mysql-proxy not.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
DB
since statistics should be same as master, I guess if
you get different plan, then postgresql.conf maybe different among
master and slave.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general
different postgresql.conf settings on slave, you could get
different plans on slave.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
On Sun, Nov 9, 2014 at 8:50 PM, Tatsuo Ishii is...@postgresql.org wrote:
Hi all
PostgreSQL servers as stated above.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
appropriate term, but
of course this is just a hindsight.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
immediately.
Note that there's a small updating delay between PostgreSQL A and B.
So there's small window where data on A and B are differ.
Postgres-XC (or Postgres-XL which is a fork of Postgres-XC) overcomes
the issue by using global transaction management technique.
Best regards,
--
Tatsuo
presentation!
His slide is on the SRA OSS's web site:
http://www.sraoss.co.jp/event_seminar/2014/20140911_pg94_schemaless.pdf
This is definitely worth to download.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via
) - query
will be closer to the reality. Note that dirty page will be written by
bgwriter process at different timing.
Also note that I completely ignore lock or
buffer replacement algorithm. Please read
src/backend/storage/buffer/README for more precise information.
Best regards,
--
Tatsuo Ishii
with the previously-defined ones. This means that
collations must be carefully versioned.
Another idea could be having our own collation data to isolate any
changes from outside world. I vaguley recall this had been discussed
before.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http
the instruction you still have problems, you should ask
pgpool ML.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
looked at rolling our own.
Any comments appreciated.
Glen
Have you looked into this?
http://pg-monz.github.io/pg_monz/index-en.html
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general
recorded to WAL (or archive log) and will be sent to new
slave afterward. The only concern is the additional load to copy
data. You could overcome it by affording more higher spec hardwares.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http
), but in practice it's a barrier that I'd like to eliminate.
+1. I told Amazon's RDS guy in Japan that it is a major pain for
PostgreSQL users to not be able to touch pg_hba.conf.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
it
synchronous (since there is no replication happening).
I thought non eventual consistency type DB can be called
synchronous, no? If I am correct, Posgres-XC is definitely
synchronous.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http
are
available it will just roll forward).
Yes, if you have multiple candicate standbys to be promoted, you
should make a discion on this. Pgpool-II cannot guess your will.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
pgbench with custom
query (purely SELECT). Is there any recommendations/suggestions in
doing that?
(The result will be in public of course).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
On Wed, Nov 13, 2013 at 4:39 PM, Michael
.
Ok, I will look into this when I have enough time.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
like to send
e-mail
them. At least, it does not have information and support page in pgFoundery
homepage.
It's Marc (scra...@hub.org).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list
was holding a relation lock for too long.
HINT: In a moment you should be able to reconnect to the database and repeat
your command.
Again, this is not what I expected. Am I missing something?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http
://pgpool.projects.pgfoundry.org/pgpool-II/doc/pgpool-en.html
The url above is obsoleted. Please visit:
http://www.pgpool.net/docs/latest/pgpool-en.html
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general
Hi,
There is an opensource DaaS project called RedDwarf. It seems the
project is only for MySQL. Does anybody know if the project will
support PostgreSQL in the future?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent
I'm just wondering why postgres_fdw explicitly sets search_path to
pg_catalog. If it does not do that, is there any security risk?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql
because PostgreSQL
detected deadlock.
Grepping source indicates that part of HOT standby code uses the error
code as well, I'm not sure what is the situation when the error code
is supposed to be generated, however.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
installation package for ppc64? or please advise me the steps
to compile from the 9.2.4 source.
I think there's nothing special with installing PostgreSQL from
9.2.4. source code on Power. Please let me know if you have any problem.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http
While debugging this with a coworker we figured out that pg_ctl was attaching
to the tty and then it clicked
that we needed to be using '-t' where I was using -T or (neither).
Are you sure? I checked the pg_ctl source code and could not find any
place attaching to the tty.
--
Tatsuo Ishii
SRA
2013/4/9 Tatsuo Ishii is...@postgresql.org:
While debugging this with a coworker we figured out that pg_ctl was
attaching to the tty and then it clicked
that we needed to be using '-t' where I was using -T or (neither).
Are you sure? I checked the pg_ctl source code and could not find any
of 4.8.0 works for me, so apparently only some flavors of 4.8.0
have the issue.
Does it matter 32/64 bit?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
explation is correct, pgpool easily goes into dead lock
situation even by using simple pgbench query.
Could you please show me self-contained test case?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing
.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Probably this is not the right forum. You'd better to subscribe and
post to pgpool-general list.
http://www.pgpool.net/mailman/listinfo/pgpool-general
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
Hi Tatsuo Ishii,
I am
information loss. For this purpose, I think we can even invent a new
encoding(maybe something like very first prposal of ISO/IEC
10646?). However, using UTF-8 for this purpose seems to be just a
disaster to me.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http
Hello,
Implementing any of these isn't trivial - especially making sure
messages emitted to stderr from things like segfaults and dynamic
linker messages are always correct. Ensuring that the logging
collector knows when setlocale() has been called to change the
encoding and translation of
logging_collector.
If this encoding is not available then fall back to 7-bit ASCII.
What do you mean by not available?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general
).
So, what you wanted to say here is:
If the conversion to this encoding is not avaliable then fall back to
UTF-8
Am I correct?
Also is it possible to completely disable the feature?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
, one of the most
popular editors in the world.
3) No need to worry about locale. Mule-internal encoding has enough
information about language.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general
Tatsuo Ishii is...@postgresql.org writes:
My idea is using mule-internal encoding for the log file instead of
UTF-8. There are several advantages:
1) Converion to mule-internal encoding is cheap because no conversion
table is required. Also no information loss happens
don't know the conclusion though.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
about
pgpool in the list.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/simple_sr_setting2_3.1/index.html
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, you can use replication delay
feature of pgpool-II. It monitors replication delay between master and
standby: if the delay is greater than a threshold, it stopps to send
read query to the standby. In case of standby failure (server down
etc.) you can use automatic failover as usual.
--
Tatsuo
restoring whole database
from the new standby as long as all logs have transferred before the
old primary went down. That means this technique can only be used in
case when the primary is scheduled down though.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http
It seems web and ssh service on pgfoundry are not available at this
moment. Anyone knows why?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
because of inconsistent data among DB
servers. Pgpool-II 3.0 or later can deal with the problem by using
black and white function list though.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql
I'm doing a rebuild to a rpm package postgresql-9.0 with pgpool but your
spec is outdated, there is some spec updated or have to make my changes
manually?
Devrim is in charge of updating the spec file. Devrim?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
on archive logging *and* keep enough archive
log segments.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On Jul 20, 2011, at 18:11, Andrej andrej.gro...@gmail.com wrote:
Can anyone recommend PostgreSQL 9.0 High Performance by G. Smith?
Yes.
+1.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general
.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
PostgreSQL conferenceChina 2011 will be hold in July 15-16 in Guangzhou,
China.
Though PostgreSQL is enterprise-ready for a long time and the user
communities around the world
been working with LPI-Japan.
Correction to this:
Representatives from Fujitsu, Hitach, Miracle Linux, NEC, NEC Soft.,
NTT, and SRA OSS attended the press announcement event.
I hope OSS-DB will significantly contribute to making PostgreSQL more
popular in Japan.
--
Tatsuo Ishii
SRA OSS, Inc
with LPI-Japan.
I hope OSS-DB will significantly contribute to making PostgreSQL more
popular in Japan.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Sorry for off topic posting but...
Since pgfoundry has been down, the schedule for releasing pgpool-II
3.0.4, to be released today, will be delayed. Sorry for
inconvenience. We will start to continue the releasing work as soon as
pgfoundry comes back.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English
which containts no
functions or a query which only contains immutable functions.
Also we should be carefull about views, which may be a result of non
immutable functions.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via
by other projects were not appeared on the page.
It seems this is not the first experience of the trouble. Are there
any problems with the software of pgfoundry or with human process?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
are interested.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
So it depends on you.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
Unfortunately the gdb backtrace does not show enough information
because of optimization, I guess. Can you take a backtrace with
optimization disabled binary?
You can obtain this by editing Makefile around line 147.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
and
the one in pg_shadow are not identical. Can you verify that?
The query result:
select passwd from pg_shadow where usename = 'test';
must be identical the password in pool_passwd for user test.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http
for the suggestion. I'm thinking about to include your idea in
the next major pgpool version up.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
Index: pool_auth.c
===
RCS file
under
/usr/local/etc, you need to create an empty /usr/local/etc/pool_passwd
owned by the same uid as pgpool. After that you should be able to
register your password as decribed in the doc.
Authentication / Access Controls
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp
Hi,
It seems the news section on http://pgfoundry.org wasn't updated for
a while. I thought this is automatically done if each project put a
news. pgpool-II project put news several times, but it never appeas on
the page. Does anybody know who is able to fix this?
--
Tatsuo Ishii
SRA OSS, Inc
Hi,
Does anybody know if there is Wiki system or something like that on
pgfoundry? I want to discuss/record the road maps, TODOs etc. on a
wiki.
I know there is a Wiki on postgresql.org but I don't think it's for
external projects.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http
Pgpool Global Development Group is pleased to announce the
availability of pgpool-II 3.0 beta1. In the mean time new version of
pgpoolAdmin, the GUI tool for pgpool-II, pgpoolAdmin 3.0 beta1 is
released.
Users are encouraged to take part in our beta test program.
pgpool-II 3.0 beta1/pgpoolAdmin
that in production. I'm working on a doc patch to address this better
before 9.0 goes out but I assure you this simple rule of thumb is
already nearing its end of life as a good one for big systems.
What's the problem with 18GB shared_buffers exactly?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English
1 - 100 of 285 matches
Mail list logo