Hello.
I am configuring warm-standby as documented here:
http://www.postgresql.org/docs/8.4/interactive/warm-standby.html
I am using "pg_standby", & may have it working corrrectly, but am not sure.
1) The standby database never 'starts', right? (/etc/init.d/postgresql-8.4
start" times out; I ca
Hello.
Thanks for the informative replies.
So, is Hot Standby the recommended way to do HA?
My application does not need to be able to do queries on the standby.
On Mon, Jan 23, 2012 at 9:53 AM, Simon Riggs wrote:
> On Mon, Jan 23, 2012 at 2:48 PM, Gary Webster wrote:
>
> > I am
Hello.
Sorry if this is redundant, but I can't find any 'cookbook' for getting
this setup.
The best I've found is here:
http://wiki.postgresql.org/images/5/58/06.5_-_Devrim_Gunduz_-_PostgreSQLClusteringWithRedHatClusterSuite--LT.pdf
but, it doesn't go into setup details.
I have a few questions/i
Hello. I'm hoping someone has seen this before.
We are trying to use Postgres Plus v9.1.3 as the Persistence Manager in
Jackrabbit (Apache JCR) clustering (
http://wiki.apache.org/jackrabbit/Clustering).
Whenever the JCR is under load, the ws_bundle TOAST table in the
repository schema, grows out
BTW, how bad is that? Corruption?
On Mon, Jul 23, 2012 at 8:35 PM, Craig Ringer wrote:
> On 07/24/2012 05:13 AM, Gary Webster wrote:
>
> Hello. I'm hoping someone has seen this before.
>
> We are trying to use Postgres Plus v9.1.3 as the Persistence Manager in
>
ch (100s of GB). It is even bigger than the data
store!
I agree that this may not be an 'error' in Postgres, but somehow it is not
playing well with Jackrabbit clustering.
On Mon, Jul 23, 2012 at 5:40 PM, Joshua D. Drake wrote:
>
> On 07/23/2012 02:13 PM, Gary Webster wrote
On Tue, Jul 24, 2012 at 1:41 PM, Joshua D. Drake wrote:
>
> On 07/24/2012 08:58 AM, Gary Webster wrote:
>
>> Hello.
>> Thanks for the response.
>>
>> There are several 'idle in transaction' on this server/app, but to a
>> different db/schema.
>
On Wed, Jul 25, 2012 at 2:44 PM, Joshua D. Drake wrote:
>
> On 07/25/2012 11:37 AM, Gary Webster wrote:
>
> This is a cluster issue, not a database issue. So if you have an
>> idnle in transaction, then it is affecting your JCR schema as well.
>>
>> OK,
Hello.
How bad is this?
2012-08-01 06:30:03 PDT 15961 [local] cp_repository_na2 ERROR: missing
chunk number 0 for toast value 1086399 in pg_toast_987417
2012-08-01 06:30:03 PDT 15961 [local] cp_repository_na2 STATEMENT: VACUUM
(FULL);
Does this mean I have db corruption, or just that the vac
Hello.
When running two 'separate' instances of Postgres on the same machine (diff
ports), do I also have two separate installs of the binaries (prefix), or
only two separate datadir ?
If the former, should I make another "postgresb" superuser, or use the same
one?
If I have two separate prefix
Hello.
The subject says most of what I know at this point.
We are still not getting along with Apache Jackrabbit.
After a few hours of using Postgres as the Persistence Manager, the JCR
gets stuck, apparently on a simple DB update statement.
This problem does not occur at all if we substitute MyS
On Wed, Aug 29, 2012 at 10:17 PM, Craig Ringer wrote:
> On 08/30/2012 03:37 AM, Gary Webster wrote:
>
>> Hello.
>> The subject says most of what I know at this point.
>>
>> We are still not getting along with Apache Jackrabbit.
>> After a few hours of using
On Thu, Aug 30, 2012 at 3:33 AM, Albe Laurenz wrote:
> Gary Webster wrote:
> > The subject says most of what I know at this point.
> >
> > We are still not getting along with Apache Jackrabbit.
> > After a few hours of using Postgres as the Persistence Manager, the
>
13 matches
Mail list logo