Re: [ADMIN] pl/pgsql function spikes CPU 100%

2007-04-24 Thread Jeff Frost
On Fri, 16 Mar 2007, Jeff Frost wrote: On Fri, 16 Mar 2007, Jeff Frost wrote: On Fri, 16 Mar 2007, Tom Lane wrote: Jeff Frost [EMAIL PROTECTED] writes: ... Interestingly, when you strace the backend, it doesn't appear to be doing too much...here's some sample output: select(0, NULL,

Re: [ADMIN] pl/pgsql function spikes CPU 100%

2007-04-24 Thread Tom Lane
Jeff Frost [EMAIL PROTECTED] writes: Well, finally got this system upgraded to 8.1.8, but unfortunately, that did not resolve this. Is there any reasonable way to see where this function is spending it's time? I've grown enamored of oprofile lately --- if you're on a recent Linux system,

[ADMIN] Replication Multi Master Asyncronous

2007-04-24 Thread Muhammad Isnaini
Hi.. I success develop a Replication Multi Master Async through PHP. Just few step to make replication with php, but I want to make this replication can embedded into PostgreSQL. This step by step . Make every record unique in every Every table that create must added by 1 Field ( ex :

Re: [ADMIN] [GENERAL] Regarding WAL

2007-04-24 Thread Alexander Staubo
On 4/24/07, Mageshwaran [EMAIL PROTECTED] wrote: I want to do replication using WAL , please tell the methods by which log shipping is done ie moving the wal files to slaves and executing it. Not possible at the moment: the log shipping facility that was introduced in 8.2 only lets you set up

[ADMIN] pg_buffercache view

2007-04-24 Thread Sorin N. Ciolofan
Dear all, About the pg_buffercache view: I couldn't find the description for this view in the manual at http://www.postgresql.org/docs/8.2/interactive/catalogs.html However I found the readme file provided in the /contrib./pg_buffercache of the source code for version 8.2.3 Here it's written

Re: [ADMIN] [GENERAL] pg_buffercache view

2007-04-24 Thread Bill Moran
In response to Sorin N. Ciolofan [EMAIL PROTECTED]: Dear all, About the pg_buffercache view: I couldn't find the description for this view in the manual at http://www.postgresql.org/docs/8.2/interactive/catalogs.html However I found the readme file provided in the

Re: [ADMIN] [GENERAL] pg_buffercache view

2007-04-24 Thread Sorin N. Ciolofan
Dear Mr. Bill Moran, Thank you for your answer. 1) To be more clear I would like to construct a query using the reldatabase column. In that query you quoted I can't identify the reldatabase column. I want a query that will help me to list how many buffers are used by each database

Re: [ADMIN] Regarding WAL

2007-04-24 Thread Brad Nicholson
On Tue, 2007-04-24 at 09:02 +0530, Mageshwaran wrote: Hi , I want to do replication using WAL , please tell the methods by which log shipping is done ie moving the wal files to slaves and executing it. http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html -- Brad

[ADMIN] Tool to analyze statement sql

2007-04-24 Thread Alexander B.
Hi people, I am suffering to work with tool that doesn't organize sql. On Pl/sql developer has a button called sql beautiful that organize on sql form (but windows). Do you have any suggestion for tools that do this running on linux (specially Suse)? Thanks for any help. Alexander

Re: [ADMIN] Postgresql Help

2007-04-24 Thread Robert Treat
On Monday 23 April 2007 01:21, Mageshwaran wrote: Hi , I am new to postgresql, I have been assigned a task of upgrading postgresql to higher version. In our company we are using 7.1.1,7.1.3,7.4.5 versions of postgresql, can you please tell me which is the stable and suitable version in 8.x

[ADMIN] Help me to decrypt password

2007-04-24 Thread sufian khan
Dear I am using an ERP application. I am administrator of that application. Actually I want to see the users passwords those are stored in encryption format. How I decrypt any password that is store in our database table app_users. Regards Muhammad Sufian Khan Functional