* 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 th
On Tue, Dec 15, 2009 at 7:45 PM, 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
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
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.
There
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 -
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 starti
On Tue, Dec 15, 2009 at 9:26 PM, Howard Cole 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 but could no
On Tue, Dec 15, 2009 at 3:39 PM, 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
> fr
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
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 increase
--- On Fri, 12/11/09, Scott Marlowe wrote:
> From: Scott Marlowe
> Subject: Re: [GENERAL] pg_dump and ON DELETE CASCADE problem
> To: cgg...@yahoo.com
> Cc: pgsql-general@postgresql.org, "Adrian Klaver" ,
> "Craig Ringer"
> Date: Friday, December 11, 2009, 1:17 PM
> On Thu, Dec 10, 2009 at 1
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 3:3
On Tue, Dec 15, 2009 at 8:26 PM, Richard Broersma
wrote:
> On Tue, Dec 15, 2009 at 12:15 PM, Dave Page 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
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
http://wiki.postgresql.or
On Tue, Dec 15, 2009 at 12:15 PM, Dave Page 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 been open was
On Mon, Dec 14, 2009 at 4:57 PM, Richard Broersma
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 selecting retry, the
Hi:
I have questions regarding replication db tech for PG. Is this the right
forumn?
Thanks for any direction !
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_cata
On Tue, Dec 15, 2009 at 11:34 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.
>
>
>>
> What could be a problem and is there a solution?
>
Looks like your 8.1.18 doesn't have any users in it.
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 ex
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 ma
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;
>s
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 4:51 AM, 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 anyt
On Tue, Dec 15, 2009 at 1:23 AM, Pavel Stehule 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
>
Thanks, Pavel! Thi
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:
http://
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 databas
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, 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 dat
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?
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 tha
31 matches
Mail list logo