On 02/08/11, Rory Campbell-Lange (r...@campbell-lange.net) wrote:
> I am trying to select arrays in a set-returning function, but receiving
> the error: "array value must start with "{" or dimension information".
>
> This issue appears to relate to locationnodes.rs_people_c sometimes
> having an e
On Wed, Aug 3, 2011 at 2:38 AM, Fujii Masao wrote:
> On Tue, Aug 2, 2011 at 2:59 PM, senthilnathan
> wrote:
>> We have system(Cluster) with Master replicating to 2 stand by servers.
>>
>> i.e
>>
>> M |---> S1
>>
>> |---> S2
>>
>> If master failed, we do a trigger file at S1 to tak
On Tue, Aug 2, 2011 at 2:59 PM, senthilnathan wrote:
> We have system(Cluster) with Master replicating to 2 stand by servers.
>
> i.e
>
> M |---> S1
>
> |---> S2
>
> If master failed, we do a trigger file at S1 to take over as master. Now we
> need to re-point the standby S2 as slav
On Tue, Aug 2, 2011 at 8:41 PM, Merlin Moncure wrote:
> Basically this is formalizing good practice for failing over nodes and
> re-syncing to a promoted master. I will say though that one
> unfortunate side effect of using HS/SR for HA is that you need *four*
> servers to really protect yoursel
On Tue, Aug 2, 2011 at 8:17 PM, Pedro Sam wrote:
> I've been trying to use repmgr for just that purpose. Looks like it simply
> creates/modifies a recovery.conf pointing primary_conninfo to the new master,
> and then restart. It does not seem to have the ability to resolve any
> timeline conf
On Tue, Aug 2, 2011 at 2:17 PM, Pedro Sam wrote:
> I've been trying to use repmgr for just that purpose. Looks like it simply
> creates/modifies a recovery.conf pointing primary_conninfo to the new master,
> and then restart. It does not seem to have the ability to resolve any
> timeline conf
No takers?
Some background I've changed my TOAST type from EXTENDED to MAIN.
On Thu, Jul 28, 2011 at 10:50 AM, bubba postgres
wrote:
>
> After some changes on my DB I notice that where I used to have a large
> pg_toast_X table, I now have a large pg_largeobject table.
> Can't find an explana
I am trying to select arrays in a set-returning function, but receiving
the error: "array value must start with "{" or dimension information".
This issue appears to relate to locationnodes.rs_people_c sometimes
having an empty array. The return type into which
locationnodes.rs_people_c is returned
I've been trying to use repmgr for just that purpose. Looks like it simply
creates/modifies a recovery.conf pointing primary_conninfo to the new master,
and then restart. It does not seem to have the ability to resolve any timeline
conflicts at all.
Am I using repmgr incorrectly?
-Origin
This message has been digitally signed by the sender.
Re___GENERAL__9_0_Streaming_Replication_Problem_to_two_slaves.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
On Tue, 2011-08-02 at 11:55 -0600, Scott Marlowe wrote:
> > Is this likely that the disks are too slow on the replication
> > servers, or is something else happening, such as the restoration of
> logs is considerably slower than on the primary?
>
> Could be. Are the drives on the slaves much sl
On Tue, Aug 2, 2011 at 9:24 AM, Michael Best wrote:
> On 07/25/2011 11:38 AM, Michael Best wrote:
>>
>> I have the servers configured, and get the replication up and running,
>> and then it will run for the better part of a day, and then the slaves
>> appear to stop receiving or requesting updates
*> What is the procedure to make the failed master as working slave?*
Check whether the following steps works for you...
Assume the following is your use case.,
Master > Slave(Stand by..)
Master replicating to slave. At time when master failed, the slave takes
over as new master. Now
*> What is the procedure to make the failed master as working slave?*
Check whether the following steps works for you...
Assume the following is your use case.,
Master > Slave(Stand by..)
Master replicating to slave. At time when master failed, the slave takes
over as new master. Now
On Tue, Aug 2, 2011 at 2:55 PM, Merlin Moncure wrote:
> On Tue, Aug 2, 2011 at 12:59 AM, senthilnathan
> wrote:
>> We have system(Cluster) with Master replicating to 2 stand by servers.
>>
>> i.e
>>
>> M |---> S1
>>
>> |---> S2
>>
>> If master failed, we do a trigger file at S1 to
Greetings,
I realize that the windows pginstaller isn't really maintained anymore
but I've run into a problem with it that has me a bit mystified. I'm
trying to upgrade from a postgresql 8.3.13 installation on windows but
when I run the upgrade.bat script and it gets to the postgresql
instal
On 07/25/2011 11:38 AM, Michael Best wrote:
I have the servers configured, and get the replication up and running,
and then it will run for the better part of a day, and then the slaves
appear to stop receiving or requesting updates, there doesn't appear to
be anything in the logs other than
On
On Tue, Aug 2, 2011 at 12:59 AM, senthilnathan
wrote:
> We have system(Cluster) with Master replicating to 2 stand by servers.
>
> i.e
>
> M |---> S1
>
> |---> S2
>
> If master failed, we do a trigger file at S1 to take over as master. Now we
> need to re-point the standby S2 as sla
Hi,
2011-08-01 16:11 keltezéssel, Paul Tilles írta:
> I have an executable which uses ecpg which was created on a system using
> postgres
> version 8.2.6. I sent it to a site with version 8.4.7 installed. The
> executable fails
> with a memory fault.
>
> Is there a problem doing this?
Try rec
We have system(Cluster) with Master replicating to 2 stand by servers.
i.e
M |---> S1
|---> S2
If master failed, we do a trigger file at S1 to take over as master. Now we
need to re-point the standby S2 as slave for the new master (i.e S1)
While trying to start standby S2,the
Many thanks guys !!
Everyone who suggested cause of problem due to LC_COLLATE setting C was
correct.
Problem is resolved.
Apologies for the multiple post.
Kind regards,
JE
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf
Hi Atul,
On 1.8.2011 16:12, Atul Goel wrote:
We are planning to upgrade a postgres 8.0 database to postgres 9.0
(Actually already done in Dev). The application is J2EE application with
Hibernate. My question are
1)Is there a list of things that needs to be taken care while
upgrading(known issue
On 08/02/11 12:29 AM, Gianpiero Venditti wrote:
First of all thanks for the quick replies, i'll describe my problem
more in detail.
I'm using postgress with the latest release of GNU Gatekeeper.
More specifically I need a query that returns a row with exactly a
single column (a text) in one c
First of all thanks for the quick replies, i'll describe my problem more in
detail.
I'm using postgress with the latest release of GNU Gatekeeper.
More specifically I need a query that returns a row with exactly a single
column (a text) in one case and a row with exactly two columns (a text an
24 matches
Mail list logo
