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
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.
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
an IRC 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 you
d 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
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#limitation
uming connections.
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@p
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
> wrote:
>>
.
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
.
> Maybe 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-gen
overy
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
reSQL. For 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
> 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
>> production
mmunity 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
ool-II 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,
--
T
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
n perhaps pgpool shouldn'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/inde
> 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
;s fork of Paraccel, available only on 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,
ebackup etc. In the
latter case, you need 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
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
.5" and are more significant 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
> 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
libpq).
I 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
--
Se
re flexible
> would be ideal.
I don't know if you are interested in using other than extensions, but
you could do 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
f
ntals were Australia
and North America.
Best regards,
--
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
hing I should try other
than 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
st ignore the broken PostgreSQL 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, Joshu
e
pg_largeobject 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
ve to
it.
http://www.pgpool.net/mailman/listinfo/pgpool-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
sions (since 3.3)
it uses UDP packet for life 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.
etween the two. Is that possible?
If you have 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
vers use the query plans from the master
> machine?
ANALYZE can only be executed on master. Slave creates its own
plan. However 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
in case
> of problems with main (own) DB.
I have no experience 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
Eng
a little bit tired of making this kind
of explanation to users but that's not users fault, I think. Maybe
"crash safe replication" or some such was more appropriate term, but
of course this is just a hindsight.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss
if we turn off auto-commit.
> Did I understand that correctly?
Yes, the chart only explains read queries. Write queries are sent to
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.sraos
the issue by using "global transaction management" technique.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> Hello,
>
> we have a setup with Postgres 9.3.4 running on Ubuntu (don't know the exact
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
--
Sen
ignore lock or
buffer replacement algorithm. Please read
src/backend/storage/buffer/README for more precise information.
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
interleave 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. J
b/contrib_docs/watchdog_master_slave_3.3/en.html
Despite you follow 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 maili
B so
> haven't yet 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://ww
ications to the database while copying data
has been 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
En
a password (as I do
> now), 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://ww
t to call 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:/
r node from backup. if the wal files 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.s
isfy myself
> that certain types of regressions have not occurred. That's quite a
> different thing to a representative workload, obviously.
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:
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, Mich
inistrator or board member now? I would 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://w
ion due to conflict with 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.
Again, this is not what I expected. Am I missing something?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.
change your
> application.
> Have a look at its documentation to make an opinion:
> 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: ht
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.sr
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 (
ot;A. PostgreSQL Error Codes" of
Appendixes.
In most cases it means that transaction is aborted 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 gener
t the
> proper 9.2.4 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
> 2013/4/9 Tatsuo Ishii :
>>> 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 c
> 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 t
compiler version on anchovy ... however, Fedora 19's
> version 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
s node
dead lock situation.
If your 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.sraos
cit transaction if you want them load balanced (if
you run pgpool-II in streaming replication mode, the restriction is
not applied).
Is it possible to turn off auto-start-transaction of Django? Pgpool-II
already wraps every write SQL statements in a trasaction.
--
Tatsuo Ishii
SRA
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,
&
> exceptions that you noticed).
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.sraos
a
>> disaster to me.
>>
> Ok, maybe the time of real universal encoding has not yet come. Then
> we maybe just should add a new parameter "log_encoding" (UTF-8 by
> default) to postgresql.conf. And to use this encoding consistently
> within logging_collector.
> If t
> 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 tra
quot; unify ABC to D. This is a great
space saving:-) The price of this is inablity of
round-trip-conversion. You can convert A, B or C to D, but you cannot
convert D to A/B/C.
BTW, I'm not stick with mule-internal encoding. What we need here is a
"super" encoding which could includ
> Tatsuo Ishii 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 ha
ernal encoding can be handled by emacs, 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.sra
on about release versioning:
http://archives.postgresql.org/pgsql-hackers/2012-06/msg01100.php
I 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 mai
this kind of question. There are many people who are serious 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
/www.pgpool.net/pgpool-web/contrib_docs/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 subscript
ase of standby failure (server down
etc.) you can use automatic failover as usual.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> thanks,
> Manoj
>
>
> On 01/17/2012 05:04 PM, Fujii Masao wrote:
>> On Wed,
test' in the
standby server's recovery.conf to solve part of your problem. The
standby will follow the new primary without 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
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
ave problem 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
> 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.j
answer is "yes," and that the replication will continue so long
Yes, as long as you turn 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-ge
> On Jul 20, 2011, at 18:11, Andrej 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
.
--
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
> communitie
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)
>
en working 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.or
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
cache the result of a query 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.
ws made 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.sr
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
dvantages of using the 9.0's built-in replication as opposed to
> pgpool's replication?
Each replication solution has its own merit/demerit. For example, if
you need synchronous replication, pgpool-II is for you. If you are ok
with async, PostgreSQL's replication is quite nice.
So
to use it a standby. Such a configuration is possible by
using pgpool-II 3.0.
--
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
igging in a little deeper now and I thought this
> might be useful.
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 Is
G: pid 1350: do_md5failed in slot 0
I have used PostgreSQL 9.0 + pgpool-II 3.0 and they work fine with md5
auth. Your log seems to indicate that the password in pool_passwd and
the one in pg_shadow are not identical. Can you verify that?
The query result:
select passwd from pg_shadow wher
e overriden).
Thanks 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
==
does not have the right to create a new 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
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
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 3.
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
Eng
point? If it's obvious, should we disable or warn to use more than
that number?
--
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
1 - 100 of 294 matches
Mail list logo
