Hi,
+Adding postgresql general list. Hope, some one will provide more
information.
On Mon, Dec 23, 2013 at 1:56 PM, kolsze...@gmail.com kolsze...@gmail.comwrote:
Hi
I Have problem with postmaster processes which unexpectedly consume very
big amount of memory, about 200MB!!!, and as a
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.
My
On Fri, Dec 20, 2013 at 7:42 PM, John R Pierce pie...@hogranch.com 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
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
+Adding postgres general
Hi,
On Mon, Dec 23, 2013 at 9:34 PM, Krzysztof Olszewski kolsze...@gmail.comwrote:
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
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
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
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
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
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
On Mon, Dec 23, 2013 at 5:37 PM, Joe Van Dyk j...@tanga.com 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
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
On Sun, Dec 15, 2013 at 11:57 PM, Andrew Sullivan a...@crankycanuck.cawrote:
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
14 matches
Mail list logo