Re: [GENERAL] The server's LC_CTYPE locale

L 8.1.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 (Debian 4.0.3-1) #show lc_ctype ; he_IL.utf8 #SHOW SERVER_ENCODING; UTF8 Any ideas what the problem ? -- -------------- Michael Ben-Nes - Internet Consultant and Director. http://www.epoch.c

Re: [GENERAL] The server's LC_CTYPE locale

Tom Lane wrote: Michael Ben-Nes <[EMAIL PROTECTED]> writes: Im got the following error when the query string was one of the Hebrew chars: SELECT upper('׳©'); ERROR: invalid multibyte character for locale HINT: The server's LC_CTYPE locale is probably

[GENERAL] The server's LC_CTYPE locale

-linux-gnu, compiled by GCC cc (GCC) 4.0.3 (Debian 4.0.3-1) #show lc_ctype ; he_IL.utf8 #SHOW SERVER_ENCODING; UTF8 Any ideas what the problem ? -- -------------- Michael Ben-Nes - Internet Consultant and Director. http://www.epoch.co.il - wea

Re: [GENERAL] I dont get it,

Tom Lane wrote: Michael Ben-Nes <[EMAIL PROTECTED]> writes: pg_dump -Fc sourcedb > sourcedb-Fc.dump pg_dump -a sourcedb > sourcedb.dump createdb test pg_restore -c -s -d test sourcedb-Fc.dump psql test < sourcedb.dump Is there a particularly good reason for doing it t

[GENERAL] I dont get it, dump / restore failures to the same cluster.

a newer server / cluster. but its impossible if pg_dump not dumping accurate data. Thanks for the help Miki -- -- Michael Ben-Nes - Internet Consultant and Director. http://www.epoch.co.il - weaving the Net. Cellular: 054-4848113 --

[GENERAL] initdb & utf-8

in different table ? Back in the 7.0.x days i created a cluster with Hebrew encoding, and now I cant dump/restore it to a C / utf-8 / other iso Cluster. Is there a way around it ? Thanks -- -- Michael Ben-Nes - Internet Consultant and Director

Re: [GENERAL] Block Size and various FS settings

After a week of testing i decided to go with JFS as the FS for Postgres. im not an expert benchmarker so i hope i initiated the right parameters in bonnie. Any way here are the results of bonnie++ & pgbench: http://www.canaan.co.il/users/miki/stats/stats.html Cheers Michael Ben

[GENERAL] Block Size and various FS settings

Hi Everyone Im setting up a machine that will host postgres 8.0.3. The main tables will be: Product - around 5 million records. keywords - around 80 million records. The machine that will host it is IBM x345 with two XEON, 3GB RAM, ServeRAID 6i and 6 15K HD. The OS ( Centos4.1 ) will be

Re: [GENERAL] Querry and SMP mechine

Martijn van Oosterhout wrote: On Sun, Aug 07, 2005 at 01:04:51PM +0300, Michael Ben-Nes wrote: Hello Im using postgres 8.0.1 on Debian Sarge with 2 XEON 2.4 HT. doing cat /etc/cpuinfo shows that linux sees 4 cpu ( the HT effect ). I noticed that when im runing a big query only one of

[GENERAL] Querry and SMP mechine

Hello Im using postgres 8.0.1 on Debian Sarge with 2 XEON 2.4 HT. doing cat /etc/cpuinfo shows that linux sees 4 cpu ( the HT effect ). I noticed that when im runing a big query only one of the CPUs become loaded. Is it normal behavior ? am i missing something ? Thanks -- ---

Re: [GENERAL] Raid and tablespaces configuration

You sure there are 5 HD ? Raid 10 suppose to have 4 HD Raid 0 suppose to have 2 HD Total of 6 ?? Any way Raid 0 is fast but give no reability. i prefer raid 1 or 10. Himanshu Baweja wrote: Currently my server has two raid controllers both with 5 disks attached:: On raid1: i have the data

Re: [GENERAL] SQL History

You can set postgresql.conf to log all queries to a file. Sadly you cant distinguish between the databases. Hrishikesh Deshmukh wrote: Hi All, Does Postgresql have a "sql history of queries run" capability? Any ideas/pointers will be a great help. Could one capture the order and SQL queries run?! T

Re: [GENERAL] PostgreSQL 8.0.2 Now Available

I want to be 100% sure. Currently my server runing 8.0.1 and my HTTP server ( another computer ) runing php which compiled on PG 7.4.7 and its working great. I need to recompile all the clients on all the other servers ( php / psql ) including PHP ? THanks Marc G. Fournier wrote: For those alre

Re: [GENERAL] Installing PostgreSQL in Debian

Yep :) but that Expermental Peter Eisentraut wrote: Michael Ben-Nes wrote: I recomend you to compile PG from source so you can use the new 8.0.1 PostgreSQL 8.0.1 is available in the Debian experimental suite, package name "postgresql-8.0". -- -- Cana

Re: [GENERAL] Installing PostgreSQL in Debian

I recomend you to compile PG from source so you can use the new 8.0.1 Cheers S Ram wrote: Hello, PostgreSQL is distributed as .RPM files. How do I install this in Debian? Thanks __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallb

[GENERAL] Log each DB to a diffrent file

Hi Everyone Im trying to log each DB to a different file. So I added: log_line_prefix ='%d :' To the postgresql.conf Later using syslog-ng i added a rule to redirect local0 + postgres + 'DB Name' to specific file. But sadly that didnt worked as its only work on one line queries. every select cons

[GENERAL] the impact of encoding on performance.

Hi All Snip <<< The drawback of using locales other than C or POSIX in PostgreSQL is its performance impact. It slows character handling and prevents ordinary indexes from being used by LIKE. For this reason use locales only if you actually need them. snip; What is the impact of the locale on

[GENERAL] Wierd memory problem with Apache / PHP. Related to pg_query ?

Hi all, I got a problem with uploading files which encounter the memory limit when their size is not even close to the memory limit itself, let me explain. Here is my code that i made for testing the problem (along the code i echoed the function memory_get_usage() to know how much memory was a

Re: [GENERAL] Large Objects

Joshua D. Drake wrote: Frank D. Engel, Jr. wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'd advise use of BYTEA as well. It's much simpler to work with than the OIDs, and has simpler semantics. You do need to escape data before handing it to the query string, and handle escaped results

Re: [GENERAL] What HW / OS is recommeded

I think and please correct me that Postgres loves RAM, the more the better. Any way RAID5 is awful with writing, go with RAID1 ( mirroring ) I use Debian Sarge and im very happy. Perl is very slow, maybe you can use PHP ? Alex wrote: Hi, we are planning to upgrade our servers but deciding on the r

[GENERAL] online backup in critical systems

Hello Im working with postgresql since version 7.0.x and im very very pleased. the DB is incredible and work very well. Lately i been asked to work on a project which require Data safety. means to avid data lost because fail of hardware or software. I thought of Replication or / and dump + log