Re: [GENERAL] official rpm build spec file

2015-08-08 Thread John McKown
Which distribution? Which release of PostgreSQL? Fedora 22, PostgreSQL release 9.4.1-1 has a source RPM you can download here: http://dl.fedoraproject.org/pub/fedora/linux/releases/22/Server/source/SRPMS/p/postgresql-9.4.1-1.fc22.src.rpm I'm running Fedora 22 x86_64. What I'd do is (transcript) is

[GENERAL] official rpm build spec file

2015-08-08 Thread AI Rumman
Hi, How to get postgresql official rpm spec file? Please let me know. I want to build my own Postgresql rpm. Thanks.

Re: [GENERAL] pg_start_backup: file has vanished from pg_subtrans/

2015-08-08 Thread David Steele
On 8/7/15 7:01 AM, Leo Baltus wrote: While backing up some postgresql-8.4.2 instances using pg_start_backup()/pg_stop_backup() We noticed that sometimes rsync complains: file has vanished: "./data/pg_subtrans/3A37" rsync warning: some files vanished before they could be transferred

Re: [GENERAL] Inconsistent behaviour calling pg_try_advisory_xact_lock with sub-query and when JOIN'ing

2015-08-08 Thread Andreas Joseph Krogh
På lørdag 08. august 2015 kl. 09:59:53, skrev Andreas Joseph Krogh < andr...@visena.com >: På fredag 07. august 2015 kl. 23:26:14, skrev David G. Johnston < david.g.johns...@gmail.com >: On Fri, Aug 7, 2015 at 1:51 PM, Andreas Joseph Kro

Re: [GENERAL] Inconsistent behaviour calling pg_try_advisory_xact_lock with sub-query and when JOIN'ing

2015-08-08 Thread Andreas Joseph Krogh
På fredag 07. august 2015 kl. 23:26:14, skrev David G. Johnston < david.g.johns...@gmail.com >: On Fri, Aug 7, 2015 at 1:51 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På fredag 07. august 2015 kl. 20:55:28, skrev Tom Lane mailto:t...@sss.pgh.pa.us