Hi All,
I have my application UI in Java and which is communicating with
Postgresql database.
However whenever my application is running I could see there are too
many postgres.exe are created even though the application is not doing
anything in database.
In general the observation is
On 15/12/2009 5:51 PM, a.bhattacha...@sungard.com wrote:
However whenever my application is running I could see there are too
many postgres.exe are created even though the application is not doing
anything in database.
What is too many ?
What does:
SELECT * FROM pg_stat_activity;
show?
a.bhattacha...@sungard.com, 15.12.2009 10:51:
Hi All,
I have my application UI in Java and which is communicating with
Postgresql database.
However whenever my application is running I could see there are too
many postgres.exe are created even though the application is not doing
anything in
Stumbled across this post by Joe Stagner of Microsoft:
http://misfitgeek.com/blog/aspnet/php-linux-windows-asp-net-performance-ndash-redux/
It is basically a comparisson of ASP.NET vs PHP but it includes
comparissons of multiple RDBMS and operating systems.
Postgres comes out on top for most
a.bhattacha...@sungard.com wrote:
Hi All,
I have my application UI in Java and which is communicating with
Postgresql database.
However whenever my application is running I could see there are too
many postgres.exe are created even though the application is not doing
anything in
Phoenix Kiula wrote:
An easy question for some I hope.
I have a DB from 8.2 days that when I now dump and try to take into
the 8.3.7, it gives me errors about utf-8 stuff.
I tried searching this list's archives but could not come up with an answer.
Google returns some sites like these:
On Tue, Dec 15, 2009 at 1:23 AM, Pavel Stehule pavel.steh...@gmail.com wrote:
Hello
NEW and OLD is comparable in 8.4. In 8.3 and older you have to use
little bit different syntax
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body
On Tue, Dec 15, 2009 at 4:51 AM, a.bhattacha...@sungard.com wrote:
Hi All,
I have my application UI in Java and which is communicating with Postgresql
database.
However whenever my application is running I could see there are too many
postgres.exe are created even though the application
After upgrade to 8.4.1 Perl my variables are no longer being seen by
subroutines:
CREATE OR REPLACE FUNCTION global.perl_test()
RETURNS varchar AS
$BODY$
my $test=x;
test();
return $test;
sub test {
elog(NOTICE,X=.$test);
}
$BODY$
language 'plperlu';
Now,
On Tue, Dec 15, 2009 at 08:35:21AM -0600, Peter wrote:
After upgrade to 8.4.1 Perl my variables are no longer being seen by
subroutines:
CREATE OR REPLACE FUNCTION global.perl_test()
RETURNS varchar AS
$BODY$
my $test=x;
test();
return $test;
sub test {
Howard Cole wrote:
Postgres comes out on top for most of the benchmarks against MySQL and
SQL Server, in fact in the authors original article he goes as far as
recommending using Postgres. More interestingly, the article seems to
indicate that W2K8 server is faster for postgres than Linux in
Hello,
I created database dump on server version 8.3.7 and trying to import it to
server v. 8.1.18, but i see errors.
CREATE DOMAIN
dump.sql:20: ERROR: role userarm does not exist
dump.sql:26: ERROR: type pg_catalog.gtsvector does not exist
dump.sql:29: ERROR: role userarm does not exist
On Tue, Dec 15, 2009 at 11:34 AM, NetLevel Admins adm...@netlevel.ruwrote:
Hello,
I created database dump on server version 8.3.7 and trying to import it to
server v. 8.1.18, but i see errors.
What could be a problem and is there a solution?
Looks like your 8.1.18 doesn't have any
On Tuesday 15 December 2009 8:34:09 am NetLevel Admins wrote:
Hello,
I created database dump on server version 8.3.7 and trying to import it to
server v. 8.1.18, but i see errors.
CREATE DOMAIN
dump.sql:20: ERROR: role userarm does not exist
dump.sql:26: ERROR: type pg_catalog.gtsvector
Hi:
I have questions regarding replication db tech for PG. Is this the right
forumn?
Thanks for any direction !
On Mon, Dec 14, 2009 at 4:57 PM, Richard Broersma
richard.broer...@gmail.com wrote:
When upgrading pg 8.4.1 to 8.4.2 the following error message appeared:
-Error-
[quote]Error copying file from package archive
(...)/postgresql-8.4.2-1-windows.exe to (...)/bin/comerr32.dll[/quote]
After
On Tue, Dec 15, 2009 at 12:15 PM, Dave Page dp...@pgadmin.org wrote:
After selecting retry, the install process completes successfully.
That's not necessarily a problem, it usually means something was still
using that DLL. pgAgent maybe, or pgAdmin?
In my case, the only thing that may have
Gauthier, Dave wrote:
I have questions regarding replication db tech for PG. Is this the
right forumn?
Sure. You can find some slightly rough documentation for help get you
started at
http://www.postgresql.org/docs/current/interactive/high-availability.html
and
On Tue, Dec 15, 2009 at 8:26 PM, Richard Broersma
richard.broer...@gmail.com wrote:
On Tue, Dec 15, 2009 at 12:15 PM, Dave Page dp...@pgadmin.org wrote:
After selecting retry, the install process completes successfully.
That's not necessarily a problem, it usually means something was still
These links are very helpful. Thanks !
At first glance, Bucardo loks like a good one. Is it open (free)? Can anyone
speak about reliability, robustness, etc... ?
Thanks Again.
From: Greg Smith [mailto:g...@2ndquadrant.com]
Sent: Tuesday, December 15, 2009
--- On Fri, 12/11/09, Scott Marlowe scott.marl...@gmail.com wrote:
From: Scott Marlowe scott.marl...@gmail.com
Subject: Re: [GENERAL] pg_dump and ON DELETE CASCADE problem
To: cgg...@yahoo.com
Cc: pgsql-general@postgresql.org, Adrian Klaver akla...@comcast.net,
Craig Ringer
Hello all,
Over the past 6 months or so I have posted to the list a couple times
looking for information regarding recovering databases from corruption. At
the time the incidents of corruption among our users was very low, but the
frequency is starting to increase, most likely due to the
On Tuesday 15 December 2009 2:33:39 pm CG wrote:
Bingo. Showed right up. I did a reindex, and now it shows up searching via
sequential scan or index scan.
So that's pretty scary to have a corrupted index. Once I reindexed, I'm
able to see /a lot/ of data I couldn't before. This is the first
On Tue, Dec 15, 2009 at 3:39 PM, Michael Clark codingni...@gmail.com wrote:
Hello all,
Over the past 6 months or so I have posted to the list a couple times
looking for information regarding recovering databases from corruption. At
the time the incidents of corruption among our users was very
On Tue, Dec 15, 2009 at 9:26 PM, Howard Cole howardn...@selestial.com wrote:
Phoenix Kiula wrote:
An easy question for some I hope.
I have a DB from 8.2 days that when I now dump and try to take into
the 8.3.7, it gives me errors about utf-8 stuff.
I tried searching this list's archives
On 16/12/2009 6:39 AM, Michael Clark wrote:
Hello all,
Over the past 6 months or so I have posted to the list a couple times
looking for information regarding recovering databases from corruption.
At the time the incidents of corruption among our users was very low,
but the frequency is
On 16/12/2009 9:07 AM, Scott Marlowe wrote:
I'd also recommend moving off of OSX as you're using a minority OS as
far as databases are concerned, and you won't have a very large
community to help out when things do go wrong.
It sounds like PostgreSQL is being used as a DB bundled with an app
Michael Clark wrote:
The solution to the problem seemed to be to change the value for the
wal_sync_method setting to fsync_writethrough from the default of fsync.
I was surprised recently to discover the default wasn't
fsync_writethrough on that platform, because it probably should be.
Craig Ringer wrote:
On 16/12/2009 9:07 AM, Scott Marlowe wrote:
I'd also recommend moving off of OSX as you're using a minority OS as
far as databases are concerned, and you won't have a very large
community to help out when things do go wrong
It sounds like PostgreSQL is being used as a DB
On Tue, Dec 15, 2009 at 7:45 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
On 16/12/2009 9:07 AM, Scott Marlowe wrote:
I'd also recommend moving off of OSX as you're using a minority OS as
far as databases are concerned, and you won't have a very large
community to help out when things
* Michael Clark:
The solution to the problem seemed to be to change the value for the
wal_sync_method setting to fsync_writethrough from the default of fsync.
I was curious if there were perhaps any other reasons that we should look
at? Or if there may be other alternatives to changing the
31 matches
Mail list logo