Re: [GENERAL] Lock contention in TransactionIdIsInProgress()

2015-11-09 Thread Julian v. Bock
Hi > "JJ" == Jeff Janes writes: JJ> This is a known issue and is fixed for 9.6 in commit JJ> 8a7d0701814a4e. thanks for the quick reply. Is there a chance this will get into the 9.5 branch as well? Regards, Julian v. Bock -- Julian v. Bock Projektleitung Software-En

[GENERAL] Re: [GENERAL] 回复: [GENERAL] ??: postgres cpu 100% need help

2015-11-09 Thread Pavel Stehule
2015-11-08 14:22 GMT+01:00 莎士比亚说: <657985...@qq.com>: > Hi moran and others; > > yesterday i get the pg problem again, and i use perf top Observation > follows: > PerfTop: 11574 irqs/sec kernel: 2.2% exact: 0.0% [4000Hz cycles], > (all, 32 CPUs) > 81.39% postgres [.] s_lock

[GENERAL] Backup and Restore BDR databases

2015-11-09 Thread Roland van Laar
Hello, I'm using BDR with master-master replication. It works like a charm. I have a question about backups and restoring them. I use this script to backup my database: https://wiki.postgresql.org/wiki/Automated_Backup_on_Linux However I'm getting problems with a pg_restore: pg_restore -h l

Re: [GENERAL] Error when test on DBT2 Postgresql

2015-11-09 Thread Adrian Klaver
On 11/08/2015 07:40 PM, Tim Chou wrote: Hi Adrian, Thank you all the time. I also realized that DBT2 has some bugs. Actually, I have sent an email to DBT2's mailing list. However, no one responded me. The latency of a txn is not high in my test. But the number of txns processed in one minute are

[GENERAL] can postgres run well on NFS mounted partitions?

2015-11-09 Thread anj patnaik
Can anyone advise if there are problems running postgres over NFS mounted partitions? I do need reliability and high speed. Thank you.

Re: [GENERAL] can postgres run well on NFS mounted partitions?

2015-11-09 Thread Patric Bechtel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Anj, anj patnaik schrieb am 06.11.2015 um 23:37: > Can anyone advise if there are problems running postgres over NFS mounted > partitions? > > I do need reliability and high speed. then don't do this. Period. Put postgres where your data is. /P

Re: [GENERAL] can postgres run well on NFS mounted partitions?

2015-11-09 Thread John McKown
On Mon, Nov 9, 2015 at 1:09 PM, Patric Bechtel wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi Anj, > > anj patnaik schrieb am 06.11.2015 um 23:37: > > Can anyone advise if there are problems running postgres over NFS > mounted partitions? > > > > I do need reliability and high sp

[GENERAL] BDR - Remove & Join

2015-11-09 Thread Will McCormick
I have a script which is meant to remove a node from bdr replication. Two nodes in replication node A and node B. The script does the following. 1. On node A - SELECT bdr.bdr_part_by_node_names(ARRAY['node B']); 2. On node A -Checks that the node_status is marked as 'k' in bdr.bdr_nodes 3. I th

[GENERAL] run 2 instances of postgres 9.4 on same linux VM

2015-11-09 Thread anj patnaik
I have a linux 6.5 RHEL VM in which I am running an instance of PG 9.4. In order to test NFS, I want to run a second instance on same VM but different file system. Has anyone done this and is it possible with no issues? Or is it better to run different versions of PG on same server? Please advis

Re: [GENERAL] run 2 instances of postgres 9.4 on same linux VM

2015-11-09 Thread Adrian Klaver
On 11/09/2015 11:40 AM, anj patnaik wrote: I have a linux 6.5 RHEL VM in which I am running an instance of PG 9.4. In order to test NFS, I want to run a second instance on same VM but different file system. http://www.postgresql.org/docs/9.4/interactive/app-initdb.html init the cluster on the

Re: [GENERAL] run 2 instances of postgres 9.4 on same linux VM

2015-11-09 Thread Adrian Klaver
On 11/09/2015 03:48 PM, anj patnaik wrote: I found this link explaining how to launch multiple instances. I was not able to find detailed steps like these in the postgres docs. Is this accurate from what you perceive? It also says to have separate init.d scripts (startup). Thanks https://openso

Re: [GENERAL] run 2 instances of postgres 9.4 on same linux VM

2015-11-09 Thread John R Pierce
On 11/9/2015 11:40 AM, anj patnaik wrote: I have a linux 6.5 RHEL VM in which I am running an instance of PG 9.4. In order to test NFS, I want to run a second instance on same VM but different file system. Has anyone done this and is it possible with no issues? Or is it better to run differen

Re: [GENERAL] run 2 instances of postgres 9.4 on same linux VM

2015-11-09 Thread John R Pierce
On 11/9/2015 5:50 PM, John R Pierce wrote: cp postgresql-X.Y postgresql-9.4B ooops, typo ... cp postgresql-9.4 postgresql-9.4B -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: ht

Re: [GENERAL] run 2 instances of postgres 9.4 on same linux VM

2015-11-09 Thread John R Pierce
On 11/9/2015 5:50 PM, John R Pierce wrote: these instructions are specific to RHEL 6/CentOS6 and assume you've installed postgresql from the yum.postgresql.org repository. all commands run as root. /path/to/new/data must be owned by postgresql:postgresql and have 700 permissions. cd

Re: [GENERAL] BDR - Remove & Join

2015-11-09 Thread Craig Ringer
On 10 November 2015 at 05:10, Will McCormick wrote: > I then run a script which I used to setup replication before removal. The > problem I encounter is node B after join in bdr.bdr_nodes is stuck in status > 'c'. [snip] > We are using the following version of bdr: 0.9.2.0 Please update to 0.9

[GENERAL] xa compatibility

2015-11-09 Thread Xaver Thum
Hi all, is there an option (provided by Postgres) accessing a Postgres DB via the standard XA interface ? I don't mean the usage of JDBC's class PGXADataSource, but the usual XA methods xa_open, xa_prepare, xa_commit, ... of the XA standard. Thanks in advance, Xaver --- Diese E-Mail wur