Re: [GENERAL] Problem connecting PostgreSQL 8.2 to Rails 1.2

People, I found the answer here: http://wiki.rubyonrails.org/rails/pages/PostgreSQL I fixed it with 1 (one!) command line: gem install postgres -- --with-pgsql-include-dir=/usr/local/pgsql/include --with-pgsql-lib-dir=/usr/local/pgsql/lib More info: $ $ $ gem install postgres -- --with-pgsql-

[GENERAL] [pgsql.general] Problem connecting PostgreSQL 8.2 to Rails 1.2

Hello people, I just installed PostgreSQL on my Mac. I used the package available here: http://www.entropy.ch/software/macosx/postgresql/ Here is a screendump of initdb... $ $ $ $ $ /usr/local/bin/initdb -E UTF8 -D /usr/local/pgsql/data The files belonging to this database system will be owned b

[GENERAL] [pgsql] Simple backup utility like mysqldump?

Hello People, I'm running PostgreSQL 8.1.1 on my freebsd box. I'm curious if PostgreSQL has a utility for backing up small databases like mysqldump or Oracle's export utility. -b ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [GENERAL] Zombie processes

everything right from the start. Does this seem to you to be a java caveat, or is it an area where the query planner could be improved? Thanks- Bjorn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peterson, Bjorn Sent: Wednesday, March 30, 2005 8:25 AM To

Re: [GENERAL] Zombie processes

2 minutes, which is acceptable for our purposes. Thanks for your response- Bjorn -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 1:31 AM To: Peterson, Bjorn Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Zombie processes Peter

[GENERAL] Zombie processes

tat_activity for about 3 minutes then goes away, but the process referenced by the pg_stat_activity remains active and consumes 50% of the CPU resources indefinitely until I kill it off.  I let it run for over an hour yesterday.  I can reproduce this every time I run this query.   Any ideas?  

Re: [GENERAL] Tomcat Connection Pool?

> > On 03/09/2003 22:56 Bjørn T Johansen wrote: >> Oki, thx... Any ideas to what is sensible values also? >> (Like number of maxIdle compared to maxActive, etc..) >> > > I think sensible values are going to be very dependent on the number of > requests. One way to find out might be to write a littl

[GENERAL] Column number 4 is out of range 0..3 ?

I just got this message for all the records returned by "select * from table", what does this mean? (I don't have any restriction on the values in column 4...) Regards, BTJ --- Bjørn T Johansen (BSc,MNIF

[GENERAL] PostgreSQL ODBC question.

lp in any way? Thanx, Bjorn Segers [EMAIL PROTECTED]