Re: [GENERAL] Table Partitioning Advice Request

Rule is not advisable, Trigger is the best solution. --- Thanks Sam Jas --- On Thu, 17/12/09, Vincenzo Romano wrote: From: Vincenzo Romano Subject: [GENERAL] Table Partitioning Advice Request To: pgsql-general@postgresql.org Date: Thursday, 17 December, 2009, 11:05 AM Hi all. I'm pla

Re: [GENERAL] Fw: password authentication failed

yes. I have an entry in pg_hba.conf file as well I have made entry in .pgpass also. Thanks Sam Jas --- On Thu, 17/12/09, A. Kretschmer wrote: From: A. Kretschmer Subject: Re: [GENERAL] Fw: password authentication failed To: pgsql-general@postgresql.org Date: Thursday, 17 December, 2009, 6

[GENERAL] Fw: password authentication failed

password authentication failed for user "bucardo"  at ./bucardo_ctl line 191 /bucardo_ctl show all ../bucardo_ctl add db test I have created bucardo user with password goat & it is a superuser. Kindly suggest me to resolve this issue. I am following below link. http://bu

Re: [GENERAL] READ ONLY & I/O ERROR

at is the reason for this issue? How can we ensure that it is not a database issue? We are using GridSQL: 1.1.0.9 PostgreSQL 8.3 Architecture Details: CentOS 5.3 64 bit Areca high point rocket raid 3520 8 port 32 GB RAM -- Thanks Sam Jas --- On Mon, 30/11/09, Greg Smith wrote:

Re: [GENERAL] WARNING: worker took too long to start; cancelled on VACCUM ANALYZE

May you try to de-install AV & try to take a dump ? Thanks Dhaval --- On Tue, 1/12/09, a.bhattacha...@sungard.com wrote: From: a.bhattacha...@sungard.com Subject: [GENERAL] WARNING: worker took too long to start; cancelled on VACCUM ANALYZE To: pgsql-general@postgresql.org Date: Tuesday,

Re: [GENERAL] Error on VACCUM ANALYZE

Is there any other processes running over the same system like antivirus or similar software on the machine? Have you changed any configuration parameters around the memory size such as shared_buffers? -- Thanks Sam Jas --- On Thu, 26/11/09, a.bhattacha...@sungard.com wrote: From

Re: [GENERAL] READ ONLY & I/O ERROR

How can i enable journaling as i am not so good at OS & H/W level. Can you give me some detail description. Thanks Sam Jas --- On Thu, 26/11/09, Grzegorz Jaśkiewicz wrote: From: Grzegorz Jaśkiewicz Subject: Re: [GENERAL] READ ONLY & I/O ERROR To: "Sam Jas"

[GENERAL] READ ONLY & I/O ERROR

ver, after running fsck also we are getting the same error. I will appreciate you if somebody help me to get rid out of this issue.   -- Thanks Sam Jas The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

Re: [GENERAL] Processing Delay

I suspect the issue is with the memories. Is it possible for you to send us the following details. (1) size of database you are managing on cluster ? (2) postgresql.conf file (3) Total RAM/ SHMMAX (4) query which is taking more time.  -- Thanks Sam Jas --- On Wed, 25/11/09, Michael

Re: [GENERAL] get a log of queries that take up a lot of CPU or take a very long time.

select procpid, current_query, now() - query_start as duration, backend_start from pg_stat_activity where current_query not like '%IDLE%' order by duration desc limit 10; Hope it may help you!!!. -- Thanks Sam Jas --- On Mon, 23/11/09, Tim Uckun wrote: From: Tim Uckun Subject

Re: [GENERAL] Strange performance degradation

t may help you!!! -- Thanks Sam Jas --- On Mon, 23/11/09, Tom Lane wrote: From: Tom Lane Subject: Re: [GENERAL] Strange performance degradation To: "Bill Moran" Cc: "Lorenzo Allegrucci" , pgsql-performa...@postgresql.org, pgsql-general@postgresql.org Date: Monday, 23 N

Re: [GENERAL] Strange performance degradation

Is there any idle connections exists ? -- Thanks Sam Jas --- On Fri, 20/11/09, Lorenzo Allegrucci wrote: From: Lorenzo Allegrucci Subject: [GENERAL] Strange performance degradation To: pgsql-performa...@postgresql.org Cc: pgsql-general@postgresql.org Date: Friday, 20 November, 2009, 9

Re: [GENERAL] Dblink to Oracle

Following link will give you details about “Heterogeneous Services Generic Connectivity”. http://oracledbnews.blogspot.com/2008/04/oracle-connections-to-non-oracle.html -- Thanks Sam Jas --- On Thu, 19/11/09, Nicola Farina wrote: From: Nicola Farina Subject: [GENERAL] Dblink to

Re: [GENERAL] Can anyone help setting up pgbouncer?

d. pgbouncer -d -v pgbouncer.ini Hope above info. may help you. -- Thanks Sam Jas --- On Fri, 13/11/09, Nick wrote: From: Nick Subject: [GENERAL] Can anyone help setting up pgbouncer? To: pgsql-general@postgresql.org Date: Friday, 13 November, 2009, 7:10 AM Im trying to set up pgbounc

Re: [GENERAL] DB Restart

uxton Subject: Re: [GENERAL] DB Restart To: "Sam Jas" Cc: "general" Date: Thursday, 12 November, 2009, 12:56 PM Sam Jas wrote: > Thanks for your reply. > > No we are not running OOM. ulimit o/p is as below. > > [postg...@server1 ~]$ ulimit > unlimited Un

Re: [GENERAL] DB Restart

Thanks for your reply. No we are not running OOM. ulimit o/p is as below. [postg...@server1 ~]$ ulimit unlimited --- On Thu, 12/11/09, Richard Huxton wrote: From: Richard Huxton Subject: Re: [GENERAL] DB Restart To: "Sam Jas" Cc: "general" Date: Thursday, 12 Nove

[GENERAL] DB Restart

:25.32 postgres: stats collector process  3992 postgres  15   0 88220 1848 1104 S  0.0  0.0   0:00.09 sshd: postg...@pts/11  3993 postgres  15   0 66060 1628 1200 S  0.0  0.0   0:00.02 -bash --Thanks Sam Jas Connect more, do more and share more with Yahoo! India Mail. Learn more. http

Re: [GENERAL] Donwload location for PostgreSQL version 8.2.7

Try the following link. May be help u. ftp://ftp-archives.postgresql.org/pub/source/v8.2.7/ -- Thanks Sam Jas --- On Mon, 9/11/09, Anand <1008an...@gmail.com> wrote: From: Anand <1008an...@gmail.com> Subject: [GENERAL] Donwload location for PostgreSQL version 8.2.7 To: p

Re: [GENERAL] Connection Problems!

java memory parameter.  Your Java application really needs a lot of memory (more than 128 MB by default!). -- Thanks Sam Jas --- On Tue, 3/11/09, Đỗ Ngọc Trí Cường wrote: From: Đỗ Ngọc Trí Cường Subject: [GENERAL] Connection Problems! To: pgsql-general@postgresql.org Date: Tuesday, 3 N

[GENERAL] Failed to update RowID generator

Hi, I am first time posting on this forum. I am getting “Failed to update RowID generator” error when I am trying to load data in gridsql. I checked that error came from underlying database postgreSQL. We are using postgresql 8.2.   ERROR [DatabaseLoad] -> Error While Loading : org.postgre

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

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?

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     | CREATED

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

Also OR operator taking time. --- On Wed, 21/10/09, Gaini Rajeshwar wrote: From: Gaini Rajeshwar Subject: [GENERAL] How to use Logical Operators in Fulltext Search? To: "pgsql-general@postgresql.org mailing list" Date: Wednesday, 21 October, 2009, 1:12 PM Hi All,   I am doing a fulltext searc

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

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 wrote: From: Gaini Rajeshwar Subject: [GENERAL] How to use Logical Operato