I need some clarification on how to monitor BDR nodes. In particular
determining replication lag. As an example, I have a two node cluster with
nodes ‘A’ and ‘B’.I need to be able to look at node ‘B’ and determine if it
is lagging behind node ‘A’, by interrogating node ‘B’ only.
From
On 04/16/2015 07:52 AM, William Dunn wrote:
Hello list,
I am creating a plpgsql procedure in Postgres 9.4 (also testing in
9.3.6) to move all of the tables that are not in a default tablespace
(pg_default, pg_global, or 0) into the tablespace pg_default. However
when it executes I get an error
Thanks for your reply.
This issue has been complained several times, and here is the most recent one:
http://www.postgresql.org/message-id/0ddfb621-7282-4a2b-8879-a47f7cecb...@simply.name
That post is about a server with huge shared_buffers, but ours is just
8GB. Total memory 48GB memory on a
I am in the process of porting some routines from using FoxPro to PostgreSQL
9.3.6.
While the long term goal is to entirely rewrite everything in the system, in
order to get items transferred as soon as possible I am having to try to
convert some of the modules in place. For the most part, this
På fredag 17. april 2015 kl. 00:05:47, skrev Guillaume Lelarge
guilla...@lelarge.info mailto:guilla...@lelarge.info: 2015-04-15 10:46
GMT+02:00 Andreas Joseph Kroghandr...@visena.com mailto:andr...@visena.com:
På onsdag 15. april 2015 kl. 04:34:31, skrev Venkata Balaji N nag1...@gmail.com
I am trying to determine the behavior of a system using ZFS to back a
PostgreSQL instance as it relates to fillfactor and table clustering.
ZFS implements copy-on-write, so when PostgreSQL modifies a block on disk,
the filesystem writes a new block rather than updating the existing block.
Unless
On Thu, Apr 16, 2015 at 5:09 AM, Geoff Speicher gspeic...@umtechx.com wrote:
Therefore one might posit that PostgreSQL should be configured to use 100%
fillfactor and avoid clustering on ZFS. Can anyone comment on this?
Even with COW, I can see fillfactor 100% still have its virtues. For
On 04/16/2015 12:24 PM, TonyS wrote:
I am in the process of porting some routines from using FoxPro to PostgreSQL
9.3.6.
While the long term goal is to entirely rewrite everything in the system, in
order to get items transferred as soon as possible I am having to try to
convert some of the
Hello list,
I am creating a plpgsql procedure in Postgres 9.4 (also testing in 9.3.6)
to move all of the tables that are not in a default tablespace (pg_default,
pg_global, or 0) into the tablespace pg_default. However when it executes I
get an error 'ERROR: invalid input syntax for type oid:'
Hi,
After upgrading our database from 9.3.5 to 9.4.1 last night, the server
suffers from high CPU spikes. During these spikes, there are a lot of
these messages in the logs:
process X still waiting for ExclusiveLock on extension of relation
Y of database Z after 1036.234 ms
And:
On Thu, Apr 16, 2015 at 02:38:56PM -0700, Adrian Klaver wrote:
Well it is an upgrade from one major version to another, so you have the
following options using Postgres core utilities:
And, if you don't want to use core utilities, you can use one of the
trigger-based replication systems to move
On Thu, Apr 16, 2015 at 1:24 PM, Andomar ando...@aule.net wrote:
After upgrading our database from 9.3.5 to 9.4.1 last night, the server
suffers from high CPU spikes. During these spikes, there are a lot of these
messages in the logs:
process X still waiting for ExclusiveLock on extension
2015-04-15 10:46 GMT+02:00 Andreas Joseph Krogh andr...@visena.com:
På onsdag 15. april 2015 kl. 04:34:31, skrev Venkata Balaji N
nag1...@gmail.com:
I'm planning to vacuum FULL a pg_largeobject relation (after vacuumlo'ing
it). The relation is 300GB large so I'm concerned the operation
Dear all,
I have one newbie question which I hope one kind soul of this list can help
me.
The situation is that I have two postgresql servers:
-9.2 running on Ubuntu 12.04 with a database 'db' already created and
populated with data,
-9.3 running on Ubuntu 14.04.02 with no database created
On 04/16/2015 02:01 PM, Octavi Fors wrote:
Dear all,
I have one newbie question which I hope one kind soul of this list can
help me.
The situation is that I have two postgresql servers:
-9.2 running on Ubuntu 12.04 with a database 'db' already created and
populated with data,
-9.3
On Thu, Apr 16, 2015 at 06:14:20PM -0400, Octavi Fors wrote:
at first glance, option 1) seems to me simpler. But does it guarantee
server version upgrade compatibility?
Yes. Use the pg_dump from the later postgres, which can read old
versions and generate any output needed for the new version.
On Thu, Apr 16, 2015 at 4:56 PM, Qingqing Zhou zhouqq.postg...@gmail.com
wrote:
On Thu, Apr 16, 2015 at 5:09 AM, Geoff Speicher gspeic...@umtechx.com
wrote:
Therefore one might posit that PostgreSQL should be configured to use
100%
fillfactor and avoid clustering on ZFS. Can anyone comment
Hi Adrian,
I didn't received any answer from Andrews.
Yes, sorry I didn't describe completely my migration plan.
Right now the database 'db' is in NAS1 mounted via nfs with computer 1
(running ubuntu 12.04 postgresql 9.2).
I want to migrate 'db' to a faster NAS2 mounted via nfs with computer 2
On 04/16/2015 03:14 PM, Octavi Fors wrote:
Hi Adrian,
at first glance, option 1) seems to me simpler. But does it guarantee
server version upgrade compatibility?
Could you/someone please provide an example of commands which I could use?
See Andrews answer.
There is the matter of the
Hi Adrian,
at first glance, option 1) seems to me simpler. But does it guarantee
server version upgrade compatibility?
Could you/someone please provide an example of commands which I could use?
Thanks a lot,
Octavi.
On Thu, Apr 16, 2015 at 5:38 PM, Adrian Klaver adrian.kla...@aklaver.com
On Thu, Apr 16, 2015 at 2:39 PM, Andomar ando...@aule.net wrote:
That post is about a server with huge shared_buffers, but ours is just 8GB.
Total memory 48GB memory on a dedicated server. Checkpoints write around 2%
of the buffers.
Are you able to take some 'perf top' during high CPU spike and
21 matches
Mail list logo