/FreeBSD for a while but
have never seen problems you mentioned.
---
Tatsuo Ishii
uxPPC R4. So I guess there's something special with YDL
and R5, not with your builds. (BTW, what is YDL?) I'm going to try R5
after official R5 is released.
---
Tatsuo Ishii
ould cause the error. I suppose I ought to dig into the
docs when I get a few spare minutes...
What is the version of PostgreSQL and what kind of platform are you
using?
--
Tatsuo Ishii
production system.
--
Tatsuo Ishii
with a vacuum
caused the problem.
After removing the vacuum all worked fine but after using the script a few
times the database starts to get very slow.
Are you saying vacuum on Cobalt does not work? I've never seen it before.
(we have Cobalt 2700J(that looks like same as yours) and RaQ2).
--
Tatsuo
of clients. However, usually the message is just a wanrning, and
should not do anything bad with the backend except that it silently
exits.
--
Tatsuo Ishii
0, it
is not allowed to add new features).
--
Tatsuo Ishii
Bruce's book is
based on 7.0.
--
Tatsuo Ishii
extracted and re-assembled.
How small is the "chunk"? If you have an index on it, it must be much
smaller than 8k. I recommend lower than 2k.
P.S. Can you give me the dump file so that I could dig into the
problem. I think pg_dump -t the_table_you_have_problems is probably
enough.
--
Tatsuo Ishii
#0]
exit(0)
/usr/local/postgres/bin/postmaster: reaping dead processes...
/usr/local/postgres/bin/postmaster: CleanupProc: pid 19113 exited with
status 0
Another possibility is you have two postmasters running. You connect
to wrong postmaster?
--
Tatsuo Ishii
Soon.
I already have such functions + operator definitions. I could post
them if there is enough interest.
--
Tatsuo Ishii
On Fri, Apr 14, 2000 at 03:44:09PM +0900, Tatsuo Ishii wrote:
Oh, he is using the multibyte support and expects an automatic code
conversion between KOI8-R and UNICODE that is not supported yet.
Not exactly. If you had a look on my first message, you would see that the
problem I see
for your Chinese texts?
--
Tatsuo Ishii
using for your Chinese texts?
Sorry, I lost your reply mail but I recall that you could show Chinese
character on your Linux. If so, can you send me the actual Chinese
text? (shorter one is preferable, say 10 bytes are enough).
--
Tatsuo IShii
look at:
http://www.sra.co.jp/people/t-ishii/tmp/gb.jpg
--
Tatsuo Ishii
be ok. I'm not sure if the data size exceeds
1GB, though.
--
Tatsuo Ishii
s into $img variable */
pg_lowrite($lobj,$img);
pg_loclose($lobj);
pg_exec($con,"end");
--
Tatsuo Ishii
different PostgreSQL
installations.
--
Tatsuo Ishii
be enabled to use this function
The connection then fails. Is there some way around this, short of
upgrading all my production servers?
Recompile your 7.0.2 without --enable-multibyte option.
--
Tatsuo Ishii
How would you go about mirroring a database server such that if all updates
to the main database are also made to the backup?
Try usogres. It works pretty well for me (PostgreSQL 7.0.2).
--
Tatsuo Ishii
Subject: [ANNOUNCE] usogres-0.0.5 released
From: Hosokawa Tetsuichi [EMAIL PROTECTED
to detect if PostgreSQL up and running other than
trying to make an actual communication with backend...
--
Tatsuo Ishii
Hello, Can anybody check and confirm(or not) this:
if pgsql(DEVEL, from cvs-server) is built with locale and multibyte then
"select * from table where row ilike '%a%'" crashes pgsql.
"select * from table where row ilike 'a%'" doesn't craches.
"select * from table where row like '%a%'"
On Sun, Dec 10, 2000 at 12:37:52AM +0900, Tatsuo Ishii wrote:
I found a silly bug with src/backend/utils/adt/like.c. Can you try out
attached pacthes?
It looks good. pgsql doesn't crash now. thank you.
Ok, I will commit the pacthes.
--
Tatsuo Ishii
lues('text in EUC_CN');
\encoding EUC_TW
update t1 set euc_tw = 'text in EUC_CN';
Not so convenience, though.
--
Tatsuo Ishii
From: Dave [EMAIL PROTECTED]
Subject: Re: [GENERAL] Does column header support multibyte character?
Date: Thu, 02 Nov 2000 23:49:30 +0800
Message-ID: [EMAIL PROTECTED]
Thank
to postmaster (this is ok). But if postmaster won't die with the
signal, then killproc sends SIGKILL to postmaster (this is not
good). SIGINT or SIGQUIT should be sent in this case.
BTW, pg_ctl only works with version 7.0 or higher.
--
Tatsuo Ishii
between:
UTF-8 -- EUC-CN
UTF-8 -- EUC-TW
UTF-8 -- Big5
--
Tatsuo Ishii
quot; file should work. What kind of problems do
you have?
(I am not sure about RaQ3i, since I do not have it)
--
Tatsuo Ishii
for years
and now it has +4000 subscribers. I believe this kind of thing has
been already done in the world (maybe Japan, Russia ...?), but I think
we should encourage them more, like having pointers to such lists on
the pgsql web site.
--
Tatsuo Ishii
YellowDog 1.2 (PPC). The web server is Apache 1.3.12 with PHP 4.0.x.
--
Tatsuo Ishii
ade sure to utilize
PHP's Japanese character set conversion functions. However, this proved to
be a challenge.
Is this available for v4 of PHP yet?
No.
--
Tatsuo Ishii
I want to set encoding hungarian language.
I try to set LATIN2, but char order is "abc..".
The good order is "abc...".
What is the soultion?
configure PostgreSQL with --enable-locale option and rebuild it.
--
Tatsuo Ishii
Ok, if I change to use EUC_TW or UTF-8 encoding, do I need to make any
changes to my code?
No.
What do I need to do differently on the web content?
Nothing, I guess.
Thanks
-Original Message-
From: Tatsuo Ishii [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 10, 2001 8:39 AM
watch out the second byte of Big5. What would
happen if "stop" appears in the second byte of Big5 string provided by
"in" in splitword?
--
Tatsuo Ishii
void splitword(uchar *out, uchar *in, uchar stop)
{
int i, j;
while(*in == ' ') in++; /* skip past any spaces */
fo
w should I handle this?
You mean ascii by "English"? Then it's ok since ascii chars always
lower than 0x80.
-Original Message-
From: Tatsuo Ishii [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 7:16 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: [
) distributions. If this
doesn't work for you, then you could set a variable in
/proc(file-max).
--
Tatsuo Ishii
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED
in the UTF-8
encoding. However, the locale support thinks that it is ISO 8859-2 (in
your case) and it try to do the case conversion using the ISO 8859-2
locale. As a result, you see invalid UTF-8 sequences.
Does it match your situation?
--
Tatsuo Ishii
---(end of broadcast
representation in the backend when the
encoding translatin is necessary. My guess is you set the database
encoding to LATIN2, not LATIN1. Can you show me the result of the
query:
select * from pg_database;
--
Tatsuo Ishii
---(end of broadcast)---
TIP 5: Have
to insert this character in a special way? The client is
set to the same encoding as the database is.
Can I have a physical copy of your database so that I could dig into
the problem? I mean an archive file using tar of whole contents of
$PGDATA...
--
Tatsuo Ishii
---(end
UTF-8 to 88569-2 before calling
strcoll(), toupper() or tolower(). This might be terribly slow,
though.
BTW, if you use only ISO 8859-2, then why you need to store data as
UTF-8 in the database?
--
Tatsuo Ishii
---(end of broadcast)---
TIP 2: you can
I have no problems with exactly the same configuration as you
said. Can you make distclean and try again?
--
Tatsuo Ishii
hello,
I have a problem during compilation of Postgresql 7.1
I configure it with --enable-multibyte=LATIN2 --enable-odbc --enable-locale
Everything goes OK.
Then I
)...
Maybe I need to insert this character in a special way? The client is
set to the same encoding as the database is.
Can I have a physical copy of your database so that I could dig into
the problem? I mean an archive file using tar of whole contents of
$PGDATA...
--
Tatsuo Ishii
I got data from
takes Vince a day or two to catch up ... yes, we are officially released,
and Tom just dump'd some major stats changes into HEAD ...
On Mon, 7 May 2001, Tatsuo Ishii wrote:
Does this mean that we have officially released 7.1.1? I could not
find any statements regarding 7.1.1
reading throught the release docs, I see that you can set the enconding at the
database level,
and am wondering if it is at all possiable to set the encoding at the table level
instead?
No.
--
Tatsuo Ishii
---(end of broadcast)---
TIP 2: you
. If a
byte is greater than 7f, then it should be a Japanese, otherwise
ASCII.
Anyway, I recommend you to study about Japanese encodings first.
See:
ftp://ftp.ora.com/pub/examples/nutshell/ujip/doc/cjk.inf
--
Tatsuo Ishii
---(end of broadcast)---
TIP 6: Have
for views?
--
Tatsuo Ishii
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
, say 1GB. I'm not
sure why, but I suspect there is a siginificant overhead to lookup
shared buffers.
--
Tatsuo Ishii
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere
On Tue, Aug 28, 2001 at 06:03:55PM +0800, Michael R. Fahey wrote:
I compiled 7.1.3 with configure --multibyte=UNICODE and
--enable-unicode-conversion (Red Hat Linux 6.1, Kernel 2.2.19).
Now I'm trying to follow the instructions given by Tatsuo Ishii in his
18 March 2001 post on how
need to change the encoding of the DB anyway.
try:
psql -c update pg_database set encoding = 7 where datname =
'template1' template1
--
Tatsuo Ishii
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
this?
Hard to tell without knowing what the configuration option was and
what kind of API you are using...
--
Tatsuo Ishii
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
in the sense of
encoding handling. Modify your Java applications to meet the new JDBC
driver's requirements (do not ask me how, because I'm not a Java
programmer) or stay with the old driver.
--
Tatsuo Ishii
---(end of broadcast)---
TIP 3: if posting/reading
[Moved to general]
We are attempting to introduce LINUX/POSTGRESQL into our environment.
We will test TURBOLINUX on the mainframe. Has anyone installed POSTGRESQL
on the MAINFRAME?
I got an account on IBM/S390/Turbo Linux combo and happily ran
PostgreSQL 7.1.
--
Tatsuo Ishii
= SJIS
Theses are read:
o the internal encoding in PHP is EUC-JP (this is recommended)
o charsets of any input from forms etc. are automatically determined
o charsets for all final pages produced by PHP are SJIS
Interesting?:-)
--
Tatsuo Ishii
---(end of broadcast
the query in UTF-8 encoding?
--
Tatsuo Ishii
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
://pgfoundry.org/projects/pgpool/) has alread done this.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
, 0xF9, 0xFA, 0xFB, 0xFC, 0xFD, 0xFE, 0xFF
};
--
Tatsuo Ishii
SRA OSS, Inc. Japan
Hi.
I have a strange problem in postgres 8.1.4 (gentoo 64bit on AMD64
platform)
My database is created vith LATIN-2 encoding for correct vieving of
nacional specific characters ( czech language
mails or ~1.7GB DB is confortably
searched by Sylph-Searcher. Sylph-Searcher runs on UNIX/Linux/Windows.
Sylph-Searcher can be downloaded from:
http://sylpheed.sraoss.jp/en/download.html#searcher
enjoy,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
---(end of broadcast
On 7/18/07, Tatsuo Ishii [EMAIL PROTECTED] wrote:
Hi,
Hi,
We are pleased to announce that Sylph-Searcher 1.0.0 is released.
Sylph-Searcher is a client program for searching mail boxes. Supported
mail box format is MH style, i.e. 1 mail = 1 file.
Sylph-Searcher uses tsearch2
On 7/19/07, Tatsuo Ishii [EMAIL PROTECTED] wrote:
Yes, sylpheed does not need PostgreSQL. sylph-searcher is an
independent application and actually is consisted of two programs:
syldbimport and sylph-searcher. syldbimport reads given mail files
and stores them into PostgreSQL database
, we divide Japanese texts into space
separted words by using specialized tool, which has huge dictionary
to look for word boundaries. To make things easier, I have written a
simple C function which calls the tool and returns the space separated
texts.
Just for your information.
--
Tatsuo Ishii
SRA
Yamamoto, who is the author
of Sylpheed, a mail client.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
you are
interested in CJK part, though.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
i have installed the pgpool in the server and start it. but how can i
know it's working? i means that the clients connected to the database
by the pgpool.
Enable log_connections on your PostgreSQL server(s)'s configuration
and see if incoming connections come from pgpool.
--
Tatsuo Ishii
SRA
i have installed the pgpool in the server and start it. but how can i
know it's working? i means that the clients connected to the database
by the pgpool.
Enable log_connections on your PostgreSQL server(s)'s configuration
and see if incoming connections come from pgpool.
--
Tatsuo Ishii
SRA
publisher.
--
Tatsuo Ishii
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
languages and countries
could work?
If there's enough demand to justify the cost for adding new language
for the exam, we look forward to add new one.
--
Tatsuo Ishii
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Am Sonntag, den 12.06.2005, 17:59 +0900 schrieb Tatsuo Ishii:
For the contents too. I dont think the source code installation
should be so much in the focus of the certification.
Since PostgreSQL is an open source database, I think it is important
to understand how to install
On Jun 11, 2005, at 11:24 PM, Tatsuo Ishii wrote:
Thank you for interested in PostgreSQL CE. There is a sample
examination problems page:
http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
You could find some idea what the exam looks like.
question 10 answer depends
of someone's knowledge (at a point in time, anyway) is a
degree or certification. By themselves they don't say much, but I
think in conjunction with experience they are seen as a good thing by
PHBs.
Thanks to SRA for making this happen!
Thank you!
--
Tatsuo Ishii
or terminate with semicolon to execute query
\q to quit
euc_tw=# \encoding
EUC_TW
euc_tw=# set client_encoding to 'BIG5';
SET
I suspect you have some problems with your PostgreSQL installation.
--
Tatsuo Ishii
1. Would like to try if you've ever successfully put Chinese characters
Am Sonntag, 12. Juni 2005 05:24 schrieb Tatsuo Ishii:
Thank you for interested in PostgreSQL CE. There is a sample
examination problems page:
http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
Regarding question 3,
Select one incorrect statement regarding
, but I don't have the compiled tree.
The question is targted for 7.4. postgresql-7.4.8.tar.gz takes 58M to
unpack on my Linux/ext3 box. 80M for compiled tree. So I admit that
above number 60MB should be a little bit raised.
--
Tatsuo Ishii
---(end of broadcast
Peter Eisentraut [EMAIL PROTECTED] writes:
Am Freitag, 24. Juni 2005 17:06 schrieb Tatsuo Ishii:
Really? I vaguley recall that someone who came from US complained
about the sort order of en locale. I thought English speakers prefer C
locale.
I have never seen an English dictionary
including UTF-8.
--
Tatsuo Ishii
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
It depends what language you want to sort. Lots of languages do not
have a sort alphabet. For example, Japanese. It can be quite
difficult to sort unusual languages like this. I am not aware of any
standard technique for sorting Japanese text other than keeping an
arbitrarily sorted
is case
sensitive because it is simply comparing the ASCII codes.
You could use lower/upper to get case insensitive ordering with C locale.
--
Tatsuo Ishii
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
) in PGCluster
have been copied from pgpool. Instead I have been getting good
feedbacks/bug fixes from the author of PGCluster. It is kind of a
collaboration work, and I think this is one of the greatest thing with
open source softwares.
--
SRA OSS, Inc. Japan
Tatsuo Ishii
---(end
. Japan
Tatsuo Ishii
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
to the job
either.
pgpool(without Slony-I) replicates schema changes. And PGCluter too.
--
SRA OSS, Inc. Japan
Tatsuo Ishii
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Tatsuo Ishii
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
, but not using fulltext ...)
I heard that MySQL has tons of problems with its multibyte support
(for example SELECT does not return correct data). I don't know if
MySQL AB has fixed the problem or not though.
--
SRA OSS, Inc. Japan
Tatsuo Ishii
---(end of broadcast
problems, please post it to pgpool-general and let's solve
it. That's the open source way.
--
SRA OSS, Inc. Japan
Tatsuo Ishii
ObNit: ORAC isn't really synchronous; it just looks that way.
This is multimaster async replication. But it can be further broken
down into four types:
Sure; I
. (This
principle is why it's also a good thing that Red Hat Enterprise isn't
always completely up to date with the community sources.)
Right. It's your freedom that you do not use pgpool until you think
it's solid enough.
--
SRA OSS, Inc. Japan
Tatsuo Ishii
---(end
On Fri, 2005-10-14 at 10:48, Andrew Sullivan wrote:
On Fri, Oct 14, 2005 at 11:54:19PM +0900, Tatsuo Ishii wrote:
Enforcement? There would be plenty of ways to achieve that. For
example, you could set pg_hba.conf so that on ly the host where pgpool
is running on could connect
?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
some thoughts on
how the postgresql community has dealt with this...
Try pgpool-HA.
http://pgfoundry.org/projects/pgpool/
--
Tatsuo Ishii
SRA OSS, Inc. Japan
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
zone 'jst' from t2;
timezone
-
17:34:56+09
(1 row)
test=# select t::time from t2;
t
--
12:34:56
(1 row)
--
Tatsuo Ishii
SRA OSS, Inc. Japan
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
zone 'jst' from t2;
timezone
-
17:34:56+09
(1 row)
test=# select t::time from t2;
t
--
12:34:56
(1 row)
--
Tatsuo Ishii
SRA OSS, Inc. Japan
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
Tatsuo Ishii wrote:
Hi,
test=# select t at time zone 'jst' from t2;
timezone
-
17:34:56+09
(1 row)
test=# select t::time from t2;
t
--
12:34:56
(1 row)
Hello,
timezone_test=# select cast(t as time with time zone) from t2
From: Magnus Hagander [EMAIL PROTECTED]
Subject: Re: [GENERAL] timestamp with time zone
Date: Thu, 13 Dec 2007 07:45:18 +0100
Message-ID: [EMAIL PROTECTED]
Tatsuo Ishii wrote:
Hi,
test=# select t at time zone 'jst' from t2;
timezone
-
17:34:56+09
Hi,
This is a newbie pgpool question. I have 2 servers (master-slave) and Slony
is doing the replication. I had installed pgpool for load balance where i
had disabled the replication_mode=false and load_balance_mode=true in
pgpool.conf
pcp_node_info gives this output.
by using -d
(debug) option?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
I have 3 postgresql services running and I have them correctly
referenced in the pgpool.conf file.
However, I get the following error when I try to create db's to them
using the following command:
psql -p db_name
psql: server
programs (not just making examins) is
not a trivial work. Moreover it costs a lot of money (over $40,000 per
year in our case). Josh, how do you overcome those problems?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
---(end of broadcast)---
TIP 3: Have you
installation.
For your convenience, I have attatched a dump containing a table
(called t1) which has the UTF-8 character in question.
$ createdb -E UTF_8 test
$ gunzip -c /tmp/t1.dump.gz|psql test
$ psql -c set client_encoding to SJIS;select * from t1 test
--
Tatsuo Ishii
SRA OSS, Inc. Japan
t1.dump.gz
installation.
For your convenience, I have attatched a dump containing a table
(called t1) which has the UTF-8 character in question.
$ createdb -E UTF_8 test
$ gunzip -c /tmp/t1.dump.gz|psql test
$ psql -c set client_encoding to SJIS;select * from t1 test
--
Tatsuo Ishii
SRA OSS, Inc. Japan
t1.dump.gz
I don't see any strange thing.
There has been no mapping from UTF-8 0xc2a0 to SJIS in PostgreSQL
since the day one. That means, you should get the error on 7.4.3, as
well as on 8.3. Are you sure that you don't have the error on 7.4.3?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
SHIFT_JIS_2004
original conv.c file
conv.c-- cracked file
Thanks
2008/2/15, Tatsuo Ishii [EMAIL PROTECTED]:
I don't see any strange thing.
There has been no mapping from UTF-8 0xc2a0 to SJIS in PostgreSQL
since the day one. That means, you should get the error on 7.4.3, as
well as on 8.3
Similar case has been already happened.
For example, I have propsed to implement WITH RECURSIVE clause and the
work is supported by Sumitomo Electric Information Systems Co.,
Ltd. (http://www.sei-info.co.jp/) and SRA OSS, Inc. Japan
(http://www.sraoss.co.jp).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
not decided yet though.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
connection slot and
reuse it for the new connection. So even if there are 300
database/user combinations, it's ok to set max_pool as low as, for
example, 4. Of course this will have unwanted side effect in that
connection caches are not very well kept, though.
--
Tatsuo Ishii
and
num_init_children
So - would it then be worth doing pgpool?
You could limit the number of connections to PostgreSQL.
--
Tatsuo Ishii
On Sat, 15 Jan 2005 11:12:04 +0900 (JST), Tatsuo Ishii
[EMAIL PROTECTED] wrote:
John Cunningham wrote:
concerned that if I drop the number of connections to less than
1 - 100 of 285 matches
Mail list logo