or configuration changes!
I guess pgpool is running on IP which is accepted by PostgreSQL using
trust auth method, which does not ask a password. Probably you set
backend_hostname to 'localhost'? Then it matches with the line in
pg_hba.conf:
hostall all 127
th method to
'password'. With this setting, if a passowrd is not found in
pool_passwd, then pgpool asks the password to PostgreSQL.
Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
processed on standby
for some reasons. In order to study the cause of error, I need a
pgpool log with debug level 1 (log_min_messages = debug1). Can you
provide it?
BTW, cross posting pgpool-general and pgsql-general is not
recommended. Please post to pgpool-general only next time.
do not behave like real tables aside from being able to be
> selected from (i.e., no SQL update/delete command).
>
> The code should produce an explicit error for that relkind as well.
If so, then the regression test should be fixed as well. Currently
there's no test case for sequences.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
is
way. I know this requires non trivial code modifications to PostgreSQL
but would be better than to make binaries with random NAMEDATALEN
values.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
a pointer to a specification of
GBK18030?
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
> Hi pgsql-general,
>
> Will there be any option to attend the upcoming PG conference remotely?
>
> Will the talks and papers be posted online following the conference, if not?
You can contact the conference organizer via email.
https://www.pgcon.org/2023/contact.php
Best reag
end it doesn't exist anymore»
You can call Pgpool-II whatever you like. Important thing for me (and
probably for users) is, if it can solve user's problem or not.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
them, too). S0 and S1 then
> "should" vote that S0 take over the VIP. But, if S2 is still up and
> can connect to "the world", does it voluntarily decide to give up the
> VIP since it's all alone?
Yes, because S2 pgpool is not the leader anymore. In this case S
nd
once it is recognized as "down" by other nodes, it will not be used
without manual intervention. Thus the disaster described above will
not happen in pgpool.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
many standby nodes,
> some of them might continue replicating from the old primary if they
> happen to be in the same network partition, and so on.
As of pg0 and existing standby in the same network as pg0, you can
either manually or automatically make them to follow pg0.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
t is set to "quarantine" state from
pgpool's point of view, which means clients cannot access pg1 via
pgpool.
w0 and w1 will decide to promote pg0.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
I think that depends what you want to
avoid using fencing. If the purpose is to avoid having two primary
servers at the same time, Pgpool-II achieve that as described above.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
> But, I heard PgPool is still affected by Split brain syndrome.
Can you elaborate more? If more than 3 pgpool watchdog nodes (the
number of nodes must be odd) are configured, a split brain can be
avoided.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index
g only for specific application name
- turn off load balancing only for specific database
- turn off load balancing if current transaction includes write query
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
ase share the company/client names using these
> tools for large PG databases?
I can't give you names but we (SRA OSS) have many customers using
PostgreSQL and some of them are using Pgpool-II.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
rect.
Yeah. Pgpool-II has query cache but PgBouncer does not.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
of EXTRACT
function.
SELECT EXTRACT(EPOCH FROM i1) AS epoch_i1, EXTRACT(EPOCH FROM i2) AS epoch_i2
FROM ( SELECT '1 day 2 hours'::interval AS i1, '26 hours'::interval AS i2) AS s;
epoch_i1 | epoch_i2
--+--
93600.00 | 93600.00
(1 row)
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
> An another question .. How does the enterprise customers using PostgreSQL can
> subscribe to official support ?
Please take a look at this URL:
https://www.postgresql.org/support/
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en.php
Japanes
detected in the startup process, then recovery would still try to
> replay as much WAL as possible from the archives or pg_wal before a
> failover.
Great. That should make my life a lot easier. I will look into the
code to confirm it.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: ht
.
The motivation of this question behind is I want to have a complete
copy of the primary server using promote command.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
| syslog local faclity
> syslog_ident | pgpool
> | syslog program ident string
When log_destination = stderr, you need to start pgpool with -n option
and redirect stderr to log file. Othewise log will not write to the
log file because
; logdir = '/data/pgpool'
1 or 2 should work. You might want to check whether 'stderr' is
actually set to log_destination parameter by using psql:
pgpool show log_destination;
If it's set but still logs are sent to syslog, try reloading or
restarting pgpool.
By the way thi
Hi Alan,
This is not the best forum to discuss Pgpool-II related topics. I
advice you to go to the Pgpool-II dedicated forum:
https://www.pgpool.net/mailman/listinfo/pgpool-general
> Hi,
>
> I'm following the steps from:
>
> https://access.crunchydata.com/documentation/pgpool/4.0.0/example-clu
t-byte2 = in-byte2 + 0x80 (should be 0xb0-0xb9)
out-byte3 = in-byte3
out-byte4 = in-byte4 + 0x80 (should be 0xb0-0xb9)
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
I
think we can leave it as it is.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
avoid a table lookup overhead which is necessary in
conversion between GB18030 and UTF8 and so on.
However I don't come up with such a mathematical conversion method for
now.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
in with only words but easy with help of the
> following graph.
>
> Most frequently used 20902 Chinese characters and 984 symbols in GBK is
> encoded with 2 bytes, which is a subset of GB18030.
It does not sound fair argument unless you are going to implement only
GBK compatible part o
he server was lost. Attempting reset: Succeeded.
test=#
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> in line with the way PG usually does it ;-)
>
> Did I miss a doc somewhere in my searches???
The logical replication protocol builds on the primitives of the
physical streaming replication protocol as stated in the document. The
explanation of 'k' and 'w' messages
; have created a network load balancer in AWS, created a target group with
> all the three pgpool nodes as targets).
>
> Regards,
> Venkatesh.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
ver.keyk": No such file or directory
> Seems like
> something you should discuss with the pgpool people.
True. The issue is almost nothing to do with PostgreSQL. I recommend
to discuss in the pgpool mailing list:
https://www.pgpool.net/mailman/listinfo/pgpool-general
BTW, pgpool 3.7.5 i
gt; SELECT;
Thanks. Is it a valid SQL statement according to the standard?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
According to the manualof RowDescription message
https://www.postgresql.org/docs/12/protocol-message-formats.html
Specifies the number of fields in a row (can be zero).
Does 0 fields could actually happen?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http
I version up, please
refer to the release notes sections.
https://pgpool.net/mediawiki/index.php/Documentation
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
avily normalized and may not be easy for applications to
extract information. By defining views, apps would have convenient and
intuitive way to get information from base tables.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
t currently it supports
count and sum.
https://www.postgresql.org/message-id/20190628195620.c306e3003a83bb85a12f54c5%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
t
> cannot be used in an expression.
Thanks. Yes, you are correct. The line should be something like:
,case when grouping(i_category)+grouping(i_class) = 0 then i_category end
> Regards
> s.
>
> On 11.03.2019 06:30, Tatsuo Ishii wrote:
>> I played with TPC-DS and found som
the instruction here.
https://ankane.org/tpc-ds
PostgreSQL is master branch HEAD. For me, the SQL above looks to be
valid.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
y suggestions?
>
> I tried \encoding WIN1252. Did not work.
What's your database encoding? (\l command on psql prompt will show it).
Also what's the result of chcp (with no argument).
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
current discussions.
>
> Of course. I will wait for the text to be settled down.
Now that CoC is out,
https://www.postgresql.org/about/policies/coc/
I would like to start the translation work. Can somebody suggest me
how I can proceed?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
City" Akihabara).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
>> Hi,
>>
>> PGconf.ASIA 2018 will be held on December 10 to 12 in Tokyo and we are
>> now accepting proposals for talks.
>>
&
Hi PostgreSQL lovers,
The call for papers for PGConf.ASIA 2018 will be closed on 31st July,
2018 (Japan time).
I am looking forward to receiving your great proposals!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
>
Hi PostgreSQL lovers,
The call for papers for PGConf.ASIA 2018 will be closed on 31st July,
2018 (Japan time).
I am looking forward to receiving your great proposals!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
>
ation works when
>> it's changed is expected to be minimal, unlike the manual translation
>> works.
>
> Good idea, but let's wait till the text is official; I'm not sure if
> we'll change the draft again in response to the current discussions.
Of course. I wi
7;s changed is expected to be minimal, unlike the manual translation
works.
One concern is, who checks for the correctness of the translations. I
think committers could do the job since there are good number of
non-English native speakers in the group.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
are ok for you, there are some. Please ask me
in a private email (I don't want to spam the list).
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
nyway.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
Hi,
Yes, definitely I am hanging out here.
If you have more specific questions to Pgpool-II, you are encouraged
to be subscribed to the Pgpool-II mailing list.
https://www.pgpool.net/mailman/listinfo/pgpool-general
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http
ction to PGPool will it accept?
Yes, you can use encrypted connections with Pgpool-II. See FAQ:
https://pgpool.net/mediawiki/index.php/FAQ#How_can_I_set_up_SSL_for_pgpool-II.3F
and the manual:
http://www.pgpool.net/docs/latest/en/html/runtime-ssl.html
for more details.
Best regards,
--
Tatsu
traffic control between frontend and backend.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> Hi,
>
> currently browsing the source code in src/include/tcop. What does tcop stand
> for? Can not find any hints in the files.
Traffic cop.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
52 matches
Mail list logo
