Re: [GENERAL] OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery?

2009-10-21 Thread Greg Smith
On Tue, 20 Oct 2009, Ow Mun Heng wrote: Raid10 is supposed to be able to withstand up to 2 drive failures if the failures are from different sides of the mirror. Right now, I'm not sure which drive belongs to which. How do I determine that? Does it depend on the output of /prod/mdstat and in

Re: [GENERAL] OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery?

2009-10-21 Thread Scott Marlowe
On Wed, Oct 21, 2009 at 12:10 AM, Greg Smith gsm...@gregsmith.com wrote: On Tue, 20 Oct 2009, Ow Mun Heng wrote: Raid10 is supposed to be able to withstand up to 2 drive failures if the failures are from different sides of the mirror.  Right now, I'm not sure which drive belongs to which. How

Re: [GENERAL] OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery?

2009-10-21 Thread Greg Smith
On Tue, 20 Oct 2009, Craig Ringer wrote: You made an exact image of each drive onto new, spare drives with `dd' or a similar disk imaging tool before trying ANYTHING, right? Otherwise, you may well have made things worse, particularly since you've tried to resync the array. Even if the data

Re: [GENERAL] OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery?

2009-10-21 Thread Greg Smith
On Wed, 21 Oct 2009, Scott Marlowe wrote: Actually, later models of linux have a direct RAID-10 level built in. I haven't used it. Not sure how it would look in /proc/mdstat either. I think I actively block memory of that because the UI on it is so cryptic and it's been historically much

Re: [postgis-users] [GENERAL] pgsql2shp : Encoding headache

2009-10-21 Thread Arnaud Lesauvage
InterRob a écrit : Arnaud Lesauvage a écrit : Also, doing a search like : SELECT * FROM mytable WHERE upper(myflied) ILIKE u'%c29f%'; Gives me 0 result. Am I wrong to think that the error 'character 0xc29f of UTF8' relates to the character with code point C29F in UTF8 ? I would do this

Re: [GENERAL] Free Tool to design Postgres Databases

2009-10-21 Thread Mike Christensen
I tried Power Architect for about 5 minutes, just enough time to notice it had no support for UUIDs which makes it all but useless.. I mean, seriously who doesn't use UUIDs :) Maybe they'll fix that, it does look promising.. Search the archives this came up within the last couple of months.  

Re: [GENERAL] multi-company design/structure ?

2009-10-21 Thread Ivano Luberti
The problem is how you use those data ? I have used schemas to split data when I had to manage large amount of data (hundred of thousand records) that are (almost) never going to be used together, if not for statistic purposes and offline processing. If you never need to select those data all

[GENERAL] How to send multiple parameters to a pl/pgsql function

2009-10-21 Thread Sgarbossa Domenico
I need to create a pl/pgsql function witch accept a list of parameters and evaluate them. I've tried this CREATE OR REPLACE FUNCTION get_first_valid (lista_elementi VARCHAR[]) RETURNS VARCHAR AS $$ DECLARE the_oneVARCHAR; BEGIN IF (ARRAY_UPPER(lista_elementi, 1) IS NOT

Re: [GENERAL] PostgreSQL driver for Joomla review

2009-10-21 Thread Csaba Nagy
Hi Thom, Sorry for the delay, I got sick in the meantime. I see that others already did some review, I will do a quick one too, later maybe I'll actually try it out... so after a quick review: * on line 218, the ENCODING '$DBname') part feels wrong, you probably want hardcoded UTF8 encoding

Re: [GENERAL] OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery?

2009-10-21 Thread Ow Mun Heng
-Original Message- From: Greg Smith [mailto:gsm...@gregsmith.com] On Wed, 21 Oct 2009, Scott Marlowe wrote: Actually, later models of linux have a direct RAID-10 level built in. I haven't used it. Not sure how it would look in /proc/mdstat either. I think I actively block memory of

Re: [GENERAL] PostgreSQL driver for Joomla review

2009-10-21 Thread Thom Brown
2009/10/21 Csaba Nagy n...@ecircle-ag.com: Hi Thom, Sorry for the delay, I got sick in the meantime. I see that others already did some review, I will do a quick one too, later maybe I'll actually try it out... so after a quick review: * on line 218, the ENCODING '$DBname') part feels

Re: [GENERAL] How to send multiple parameters to a pl/pgsql function

2009-10-21 Thread Pavel Stehule
I know that postgresql array implementation is not right complete and that if just one element of array is NULL the basics array function (array_dims, array_upper, etc.) returns NULL. I need to send a list of parameters (which could contain NULL values) and evaluate the parameters

[GENERAL] Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT

2009-10-21 Thread Sergey Konoplev
Hi, All Well what do we have? 8 core, 32 GB, RAID 10, CentOS 5.2, Pg 8.3 A query using tsearch in WHERE block with ORDER and LIMIT: select * from test_table where obj_tsvector @@ make_tsquery('some_words', 'utf8_russian') and obj_status_did = 1 order by obj_created desc limit 10; Two indexes -

[GENERAL] How to use Logical Operators in Fulltext Search?

2009-10-21 Thread Gaini Rajeshwar
Hi All, I am doing a fulltext search something like this: SELECT doc_id FROM docs WHERE tsv_title($$'magnetic induction'$$) OR tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$) It is taking approximately 100 secs to execute. But running the query on individual column something

Re: [GENERAL] How to use Logical Operators in Fulltext Search?

2009-10-21 Thread Sam Jas
Can we have a explain plan SELECT doc_id FROM docs WHERE tsv_title($$'magnetic induction'$$) OR tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$) -- Thanks Sam --- On Wed, 21/10/09, Gaini Rajeshwar raja.rajeshwar2...@gmail.com wrote: From: Gaini Rajeshwar

Re: [GENERAL] How to use Logical Operators in Fulltext Search?

2009-10-21 Thread Sam Jas
Also OR operator taking time. --- On Wed, 21/10/09, Gaini Rajeshwar raja.rajeshwar2...@gmail.com wrote: From: Gaini Rajeshwar raja.rajeshwar2...@gmail.com Subject: [GENERAL] How to use Logical Operators in Fulltext Search? To: pgsql-general@postgresql.org mailing list

Re: [GENERAL] Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT

2009-10-21 Thread Tom Lane
Sergey Konoplev gray...@gmail.com writes: Is there a way (or workaround) to make it use i_test_table__created for frequent and i_test_table__tsvector_1 for sparse words? You would need to update to 8.4 for that --- 8.3 does not have any support for statistics estimation for @@. (Whether 8.4

Re: [GENERAL] How to use Logical Operators in Fulltext Search?

2009-10-21 Thread Tom Lane
Gaini Rajeshwar raja.rajeshwar2...@gmail.com writes: I am doing a fulltext search something like this: SELECT doc_id FROM docs WHERE tsv_title($$'magnetic induction'$$) OR tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$) Since you haven't told us what those functions do,

Re: [GENERAL] How to send multiple parameters to a pl/pgsql function

2009-10-21 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com writes: I know that postgresql array implementation is not right complete and that if just one element of array is NULL the basics array function (array_dims, array_upper, etc.) returns NULL. It's not true. Dimensions are stored independent to content.

[GENERAL] PostgreSQL 8.4.1 is supported on RHEL 4 and RHEL 5.2

2009-10-21 Thread utsav
Dear All, Kindly clarify that whether PostgreSQL 8.4.1 is supported on RHEL 4 and RHEL 5.2, and what type of installation binaries are available ( RPM etc) for it. Also can I upgrade the Postgresql 7.4.6-1 to PostgreSQL 8.4.1. Regards, Utsav Turray Disclaimer :- This e-mail and any attachment

Re: [GENERAL] How much lines per day?

2009-10-21 Thread Andreas Kretschmer
Tatsuo Ishii is...@postgresql.org wrote: Hi, While attending a Linux conference, a guy said that 10,923 lines of code are added and 5,547 lines of code are deleted per day in average in Linux development. This is an interesting number and I just wonder anybody ever tries to calculate these

Re: [GENERAL] Function returning 2 columns evaluated twice when both columns are needed

2009-10-21 Thread Merlin Moncure
On Wed, Oct 21, 2009 at 12:37 AM, Pavel Stehule pavel.steh...@gmail.com wrote: 2009/10/21 Merlin Moncure mmonc...@gmail.com: On Tue, Oct 20, 2009 at 5:12 PM, Pavel Stehule pavel.steh...@gmail.com wrote: [ shrug... ]  There are other possible reasons why the planner would fail to flatten a

[GENERAL] Data migration tool certification

2009-10-21 Thread hfdabler
Hello to all, I have been using Talend now for a few months and am very happy with the software. I have seen on the website (http://www.talend.com/partners/index.php ) the page on the Talend certification and the exam. I'm pretty curious to see what it takes to take the exam, if you need to

Re: [GENERAL] multi-company design/structure ?

2009-10-21 Thread John
On Tuesday 20 October 2009 10:05:34 pm Roderick A. Anderson wrote: John wrote: Hi, Is it better to create multi databases or create multi schemas? John, I just gave a talk on multi-tenant Pg clusters at PgConf West 2009 that may help you but ran into vehicle problems and just got home

Re: [GENERAL] multi-company design/structure ?

2009-10-21 Thread John
On Wednesday 21 October 2009 01:23:18 am Ivano Luberti wrote: The problem is how you use those data ? I have used schemas to split data when I had to manage large amount of data (hundred of thousand records) that are (almost) never going to be used together, if not for statistic purposes and

[GENERAL] Pg and pgsphere users

2009-10-21 Thread Isabella Ghiurea
Dear PG community, I would like to know if anyone there is using pgsphere ( v 1.1.0) with PG v 8.3.6 , I have few questions regarding the compatibility of this 2 versions. Thank you, Isabella -- View this message in context:

Re: [GENERAL] How much lines per day?

2009-10-21 Thread Rakotomandimby Mihamina
10/21/2009 08:40 AM, Tatsuo Ishii: Does anyone know such number? With some script binding the PG SCM you could easily find that. It's all about SUMming -- and ++ from commit diffs. -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement

Re: [GENERAL] PostgreSQL 8.4.1 is supported on RHEL 4 and RHEL 5.2

2009-10-21 Thread Devrim GÜNDÜZ
On Wed, 2009-10-21 at 14:43 +0530, utsav wrote: Kindly clarify that whether PostgreSQL 8.4.1 is supported on RHEL 4 and RHEL 5.2, and what type of installation binaries are available ( RPM etc) for it. Per http://yum.pgsqlrpms.org/rpmchart.php , both distros are supported. RPMs are available

[GENERAL] Linux TOP

2009-10-21 Thread Waldomiro
Hi, I have one of my database server that I run the "top" command: top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52, 3.36 Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi, 0.2%si, 0.0%st Mem: 16432240k

[GENERAL] Linux TOP is a indicator?

2009-10-21 Thread Waldomiro
Hi, I have one of my database server that I run the top command: top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52, 3.36 Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi, 0.2%si, 0.0%st Mem:

Re: [GENERAL] Linux TOP

2009-10-21 Thread Rich Shepard
On Wed, 21 Oct 2009, Waldomiro wrote: I'm afraid of two things, one is the load average, I think 3 is too much, another is the swap, almost 4GB of swap, I think that is too much swap. Am I right? Not necessarily. Can I use those indicators to know if my database is ok? Perhaps.

Re: [GENERAL] How much lines per day?

2009-10-21 Thread Jeff Davis
On Wed, 2009-10-21 at 14:40 +0900, Tatsuo Ishii wrote: While attending a Linux conference, a guy said that 10,923 lines of code are added and 5,547 lines of code are deleted per day in average in Linux development. This is an interesting number and I just wonder anybody ever tries to calculate

Re: [GENERAL] Linux TOP is a indicator?

2009-10-21 Thread John R Pierce
Waldomiro wrote: Hi, I have one of my database server that I run the top command: top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52, 3.36 Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi,

[GENERAL] Does anyone know anything about qecr or brahmabrahmabrahmabrahma()

2009-10-21 Thread Radcon Entec
Greetings! PostgreSQL just crashed on a client's machine. There are several strange things in the log file for today. Among the strangest is the following: 2009-10-21 12:28:01 EDT anneal 94S-CAPS1.akst.com ERROR: syntax error at or near qecr at character 2 2009-10-21 12:28:01 EDT anneal

Re: [GENERAL] Does anyone know anything about qecr or brahmabrahmabrahmabrahma()

2009-10-21 Thread Joseph Conway
Radcon Entec wrote: Greetings! PostgreSQL just crashed on a client's machine. There are several strange things in the log file for today. Among the strangest is the following: 2009-10-21 12:28:01 EDT anneal 94S-CAPS1.akst.com ERROR: syntax error at or near qecr at character 2

Re: [GENERAL] [pgeu-general] PGDay.EU 2009 - approaching fast!

2009-10-21 Thread Thom Brown
I've put the English schedule (Désolé utilisateurs Français) on a calendar for my own use, but made it public in case anyone else might find it helpful, like syncing it with a mobile device etc: XML:

Re: [GENERAL] Linux TOP is a indicator?

2009-10-21 Thread Scott Marlowe
On Wed, Oct 21, 2009 at 12:43 PM, Waldomiro waldom...@shx.com.br wrote: Hi, I have one of my database server that I run the top command: top - 16:16:30 up 42 days, 13:23,  4 users,  load average: 3.13, 3.52, 3.36 Tasks: 624 total,   1 running, 623 sleeping,   0 stopped,   0 zombie Cpu(s):  

Re: [GENERAL] Linux TOP is a indicator?

2009-10-21 Thread Scott Marlowe
As a followup to my previous post, here's what a healthy, well behaved but running under moderate load db server looks like: top - 15:47:51 up 436 days, 2:31, 3 users, load average: 12.03, 11.86, 12.26 Tasks: 394 total, 7 running, 387 sleeping, 0 stopped, 0 zombie Cpu(s): 17.3%us,

Re: [GENERAL] Linux TOP

2009-10-21 Thread Greg Smith
On Wed, 21 Oct 2009, Waldomiro wrote: top - 16:16:30 up 42 days, 13:23,  4 users,  load average: 3.13, 3.52, 3.36 Cpu(s):  1.4%us,  1.1%sy,  0.0%ni, 84.4%id, 12.9%wa,  0.0%hi,  0.2%si,  0.0%st Mem:  16432240k total, 16344596k used,    87644k free,    27548k buffers Swap: 10241428k total, 

Re: [GENERAL] Linux TOP

2009-10-21 Thread Scott Marlowe
On Wed, Oct 21, 2009 at 4:01 PM, Greg Smith gsm...@gregsmith.com wrote: On Wed, 21 Oct 2009, Waldomiro wrote: top - 16:16:30 up 42 days, 13:23,  4 users,  load average: 3.13, 3.52, 3.36 Cpu(s):  1.4%us,  1.1%sy,  0.0%ni, 84.4%id, 12.9%wa,  0.0%hi,  0.2%si, 0.0%st Mem:  16432240k total,

Re: [GENERAL] Linux TOP

2009-10-21 Thread Tom Lane
Scott Marlowe scott.marl...@gmail.com writes: In this: Mem: 16432240k total, 16344596k used,87644k free,27548k buffers Swap: 10241428k total, 3680860k used, 6560568k free, 6230376k cached The 6.2G cached is considered part of the 16G used So it's not using more memory than it

Re: [GENERAL] Linux TOP

2009-10-21 Thread Greg Smith
On Wed, 21 Oct 2009, Scott Marlowe wrote: In this: Mem: 16432240k total, 16344596k used,87644k free,27548k buffers Swap: 10241428k total, 3680860k used, 6560568k free, 6230376k cached The 6.2G cached is considered part of the 16G used So it's not using more memory than it has.

Re: [GENERAL] Linux TOP

2009-10-21 Thread Scott Marlowe
On Wed, Oct 21, 2009 at 4:25 PM, Greg Smith gsm...@gregsmith.com wrote: On Wed, 21 Oct 2009, Scott Marlowe wrote: In this: Mem:  16432240k total, 16344596k used,    87644k free,    27548k buffers Swap: 10241428k total,  3680860k used,  6560568k free,  6230376k cached The 6.2G cached is

Re: [GENERAL] cast numeric with scale and precision to numeric plain

2009-10-21 Thread Scott Bailey
Sim Zacks wrote: I'm using 8.2.4 Numeric with scale precision always shows the trailing zeros. Numeric plain only shows numbers after the decimal point that are being used. I would like to have the data in my table with scale and precision, but my views to be cast to numeric without any

[GENERAL] postgres doesn't start after crash

2009-10-21 Thread Patrick Brückner
Hi, after a computer crash my postgres 8.2.14 installation under Windows XP SP3 doesn't start anymore. Here is the log file: C:\Dokumente und Einstellungen\Admin2009-10-21 23:57:09 LOG: database system was interrupted while in recovery at 2009-10-21 22:21:14 2009-10-21 23:57:09 HINT: This

[GENERAL] auto-filling a field on insert

2009-10-21 Thread semi-ambivalent
If I have a table with fields A, B, C and D how could I do something such that if I insert values in fields A, B and C field D would be auto-filled with the value A||B||C? Just a pointer of where to begin looking is fine. Triggers? Copy ... From? Table or field definitions? thx -- Sent via

Re: [GENERAL] auto-filling a field on insert

2009-10-21 Thread David Fetter
On Wed, Oct 21, 2009 at 07:17:44PM -0700, semi-ambivalent wrote: If I have a table with fields A, B, C and D how could I do something such that if I insert values in fields A, B and C field D would be auto-filled with the value A||B||C? Just a pointer of where to begin looking is fine.

Re: [GENERAL] postgres doesn't start after crash

2009-10-21 Thread Scott Marlowe
2009/10/21 Patrick Brückner payda...@gmail.com: Hi, after a computer crash my postgres 8.2.14 installation under Windows XP SP3 doesn't start anymore. Here is the log file: 2009-10-21 23:57:10 FATAL: could not count blocks of relation 1663/68065/68157: Permission denied I assume it has

[GENERAL] Reversing flow of WAL shipping

2009-10-21 Thread David Jantzen
Hey Folks, I want to run a warm standby scenario by you. I'm pretty sure it'll work, but it's a very large database so even the slightest mistake can mean a major setback. Scenario: Server A is the provider node, shipping WAL files to Server B. Server B is destined to become the

[GENERAL] Preventing database listing?

2009-10-21 Thread Adam Rich
This seems like a simple question that would have come up, but I'm not able to find an answer in google, PG docs, or PG mailing list archives. How do I prevent a user from being able to list all databases in my cluster? I want to restrict them to seeing just the databases they have connect

Re: [GENERAL] Preventing database listing?

2009-10-21 Thread Sam Jas
Below are the options that you can use to create user and assign them privileges according to your environment. Command: CREATE USER Description: define a new database role Syntax: CREATE USER name [ [ WITH ] option [ ... ] ] where option can be:   SUPERUSER | NOSUPERUSER     |

Re: [GENERAL] postgres doesn't start after crash

2009-10-21 Thread Sam Jas
Did you find what the reason of crash was? Log seems that the data is corrupted as the system was crashed. Smart way it to reload data from the valid backup and start your work. If you don’t have a valid backup then at last touch the file (68157) and try to restart your db. -- Thanks Sam

Re: [GENERAL] Preventing database listing?

2009-10-21 Thread John R Pierce
Adam Rich wrote: This seems like a simple question that would have come up, but I'm not able to find an answer in google, PG docs, or PG mailing list archives. How do I prevent a user from being able to list all databases in my cluster? I want to restrict them to seeing just the databases