Hi,
+Adding postgresql general list. Hope, some one will provide more
information.
On Mon, Dec 23, 2013 at 1:56 PM, kolsze...@gmail.com wrote:
> Hi
>
> I Have problem with "postmaster" processes which unexpectedly consume very
> big amount of memory, about 200MB!!!, and as a consequence whole av
>
> And /usr/local/pgsql was re-initdbed with a 9.0 cluster, because
> previously it was the 9.3 cluster?
>
> And you are sure /usr/local/bin has the 9.3 binaries?
>
> Personally I would say at this point the relationships between versions
> are so confused it would seem best to start from scratch
On Fri, Dec 20, 2013 at 7:42 PM, John R Pierce wrote:
> On 12/20/2013 4:14 PM, Adrian Klaver wrote:
>
>>
>> Personally I would say at this point the relationships between versions
>> are so confused it would seem best to start from scratch.
>>
>
> the 80 tablespaces aren't helping this one bit.
>
After the restart of a PostgreSQL 9.3.1 hot standby doing streaming
replication, the database would not come up again and the logs show
"index contains unexpected zero page at block 0" errors as shown below:
LOG: entering standby mode
LOG: redo starts at 6/55A16990
LOG: consistent reco
+Adding postgres general
Hi,
On Mon, Dec 23, 2013 at 9:34 PM, Krzysztof Olszewski wrote:
> Hi
>
> thanx for your answer
>
> "Using EXPLAIN ANALYZE BUFFERS"
> how it helps me with "How can I estimate memory needed for postgres" ?
>
Using this information, i believe we can estimate the memory u
On 12/23/2013 06:45 AM, Joseph Kregloh wrote:
And /usr/local/pgsql was re-initdbed with a 9.0 cluster, because
previously it was the 9.3 cluster?
And you are sure /usr/local/bin has the 9.3 binaries?
Personally I would say at this point the relationships between
versions
On 12/23/2013 6:50 AM, Joseph Kregloh wrote:
Well the original architect started out in the 80s with banking
databases they just kept that model without revisiting if it works
well or not, that might explain it a little bit. But also given the
size of our tables we use the physical disks an
Sometime ago i was looking for something like this and because at this time
XC was a little baby i tried installing bucardo but i gave up when stucked
fighting with perl modules. So, after testing some other solutions i decided
to make my own, just "touching" the trigger part of the pyreplica proje
We use symmetricDS pretty extensively, across oracle and postgres
databases. It has its flaws and its strengths. It shines when there's
multiple database platforms involved, when the volume of transactions is
not too high, and supports multi master. Its optimized for wan topologies,
so its great if
This has been brought up a few times in the past:
http://www.postgresql.org/message-id/CAAZKuFZF5=raA=rlncqeg_8gsj9vi4_e-fi1aomk4zp+dxc...@mail.gmail.com
http://www.postgresql.org/message-id/ec26f5ce-9f3b-40c9-bf23-f0c2b96e3...@gmail.com
Any chance it could be fixed? I can't figure out a way to ea
I tried making some cast functions as follows, but it doesn't seem to work
properly:
create or replace function iso_timestamp(timestamptz) returns json as $$
select ('"' ||
substring(xmlelement(name x, $1)::text from 4 for 32) || '"'
)::json
$$ language sql immutable;
create c
On Mon, Dec 23, 2013 at 5:37 PM, Joe Van Dyk wrote:
> I tried making some cast functions as follows, but it doesn't seem to work
> properly:
>
> create or replace function iso_timestamp(timestamptz) returns json as $$
> select ('"' ||
> substring(xmlelement(name x, $1)::text from 4 for
Though I will agree that slony is a nice and a great tool w.r.t.
replication (specifically selective replication). But I would dis-agree on
below points:
* Cascading replication chains (a really big deal when you want
multiple slaves in the secondary facility and don't want to hog
your band
On Sun, Dec 15, 2013 at 11:57 PM, Andrew Sullivan wrote:
> I thought people'd like to know about this. For those who don't know,
> ARIN is the Regional Internet Registry for North America and the
> Carribean. That is, if you have an IP address and you are operating
> in that region, you depend o
14 matches
Mail list logo
