Which distribution? Which release of PostgreSQL? Fedora 22, PostgreSQL release 9.4.1-1 has a source RPM you can download here:
I'm running Fedora 22 x86_64. What I'd do is (transcript) is:
$mkdir pg
joarmc@mckown5 2015-08-08T20:33:22 ~
$cd pg
joarmc@mckown5 2015-08-08T20:33:24 ~/pg
$wget http://dl.fedoraproject.org/pub/fedora/linux/releases/22/Server/source/SRPMS/p/postgresql-9.4.1-1.fc22.src.rpm
--2015-08-08 20:33:29-- http://dl.fedoraproject.org/pub/fedora/linux/releases/22/Server/source/SRPMS/p/postgresql-9.4.1-1.fc22.src.rpm
Resolving dl.fedoraproject.org (dl.fedoraproject.org)... 209.132.181.24, 209.132.181.26, 209.132.181.27, ...
Connecting to dl.fedoraproject.org (dl.fedoraproject.org)|209.132.181.24|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 43861446 (42M) [application/x-rpm]
Saving to: ‘postgresql-9.4.1-1.fc22.src.rpm’
postgresql-9.4.1-1.fc22.src.rpm 100%[==========================================================================================>] 41.83M 1.10MB/s in 39s
2015-08-08 20:34:08 (1.07 MB/s) - ‘postgresql-9.4.1-1.fc22.src.rpm’ saved [43861446/43861446]
joarmc@mckown5 2015-08-08T20:34:08 ~/pg
joarmc@mckown5 2015-08-08T20:33:22 ~
$cd pg
joarmc@mckown5 2015-08-08T20:33:24 ~/pg
$wget http://dl.fedoraproject.org/pub/fedora/linux/releases/22/Server/source/SRPMS/p/postgresql-9.4.1-1.fc22.src.rpm
--2015-08-08 20:33:29-- http://dl.fedoraproject.org/pub/fedora/linux/releases/22/Server/source/SRPMS/p/postgresql-9.4.1-1.fc22.src.rpm
Resolving dl.fedoraproject.org (dl.fedoraproject.org)... 209.132.181.24, 209.132.181.26, 209.132.181.27, ...
Connecting to dl.fedoraproject.org (dl.fedoraproject.org)|209.132.181.24|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 43861446 (42M) [application/x-rpm]
Saving to: ‘postgresql-9.4.1-1.fc22.src.rpm’
postgresql-9.4.1-1.fc22.src.rpm 100%[==========================================================================================>] 41.83M 1.10MB/s in 39s
2015-08-08 20:34:08 (1.07 MB/s) - ‘postgresql-9.4.1-1.fc22.src.rpm’ saved [43861446/43861446]
joarmc@mckown5 2015-08-08T20:34:08 ~/pg
$rpm2cpio postgresql-9.4.1-1.fc22.src.rpm | cpio -dium
88212 blocks
joarmc@mckown5 2015-08-08T20:34:55 ~/pg
88212 blocks
joarmc@mckown5 2015-08-08T20:34:55 ~/pg
$ls -l
total 86996
-rw-r--r--. 1 joarmc joarmc 1046 Feb 5 2015 ecpg_config.h
-rwxr-xr-x. 1 joarmc joarmc 1219 Feb 5 2015 generate-pdf.sh
-rw-r--r--. 1 joarmc joarmc 2024 Feb 5 2015 Makefile.regress
-rw-r--r--. 1 joarmc joarmc 1030 Feb 5 2015 pg_config.h
-rw-rw-r--. 1 joarmc joarmc 16889913 Feb 5 2015 postgresql-9.3.6.tar.bz2
-rw-rw-r--. 1 joarmc joarmc 91 Feb 5 2015 postgresql-9.3.6.tar.bz2.sha256
-rw-rw-r--. 1 joarmc joarmc 43861446 Feb 17 08:34 postgresql-9.4.1-1.fc22.src.rpm
-rw-rw-r--. 1 joarmc joarmc 17549976 Feb 5 2015 postgresql-9.4.1.tar.bz2
-rw-rw-r--. 1 joarmc joarmc 91 Feb 5 2015 postgresql-9.4.1.tar.bz2.sha256
-rw-rw-r--. 1 joarmc joarmc 10520549 Feb 5 2015 postgresql-9.4.1-US.pdf
-rw-r--r--. 1 joarmc joarmc 85 Feb 5 2015 postgresql-bashprofile
-rw-r--r--. 1 joarmc joarmc 1167 Feb 5 2015 postgresql-config-comment.patch
-rw-r--r--. 1 joarmc joarmc 2004 Feb 5 2015 postgresql-logging.patch
-rw-r--r--. 1 joarmc joarmc 1387 Feb 5 2015 postgresql-man.patch
-rw-r--r--. 1 joarmc joarmc 71 Feb 5 2015 postgresql.pam
-rw-r--r--. 1 joarmc joarmc 1126 Feb 5 2015 postgresql-perl-rpath.patch
-rw-rw-r--. 1 joarmc joarmc 116281 Jan 5 2015 postgresql-setup-2.0.tar.gz
-rw-r--r--. 1 joarmc joarmc 68805 Feb 5 2015 postgresql.spec
-rw-r--r--. 1 joarmc joarmc 47 Feb 5 2015 postgresql.tmpfiles.d
-rw-r--r--. 1 joarmc joarmc 2114 Feb 5 2015 postgresql-var-run-socket.patch
-rw-r--r--. 1 joarmc joarmc 2395 Feb 5 2015 rpm-pgsql.patch
joarmc@mckown5 2015-08-08T20:35:16 ~/pg
total 86996
-rw-r--r--. 1 joarmc joarmc 1046 Feb 5 2015 ecpg_config.h
-rwxr-xr-x. 1 joarmc joarmc 1219 Feb 5 2015 generate-pdf.sh
-rw-r--r--. 1 joarmc joarmc 2024 Feb 5 2015 Makefile.regress
-rw-r--r--. 1 joarmc joarmc 1030 Feb 5 2015 pg_config.h
-rw-rw-r--. 1 joarmc joarmc 16889913 Feb 5 2015 postgresql-9.3.6.tar.bz2
-rw-rw-r--. 1 joarmc joarmc 91 Feb 5 2015 postgresql-9.3.6.tar.bz2.sha256
-rw-rw-r--. 1 joarmc joarmc 43861446 Feb 17 08:34 postgresql-9.4.1-1.fc22.src.rpm
-rw-rw-r--. 1 joarmc joarmc 17549976 Feb 5 2015 postgresql-9.4.1.tar.bz2
-rw-rw-r--. 1 joarmc joarmc 91 Feb 5 2015 postgresql-9.4.1.tar.bz2.sha256
-rw-rw-r--. 1 joarmc joarmc 10520549 Feb 5 2015 postgresql-9.4.1-US.pdf
-rw-r--r--. 1 joarmc joarmc 85 Feb 5 2015 postgresql-bashprofile
-rw-r--r--. 1 joarmc joarmc 1167 Feb 5 2015 postgresql-config-comment.patch
-rw-r--r--. 1 joarmc joarmc 2004 Feb 5 2015 postgresql-logging.patch
-rw-r--r--. 1 joarmc joarmc 1387 Feb 5 2015 postgresql-man.patch
-rw-r--r--. 1 joarmc joarmc 71 Feb 5 2015 postgresql.pam
-rw-r--r--. 1 joarmc joarmc 1126 Feb 5 2015 postgresql-perl-rpath.patch
-rw-rw-r--. 1 joarmc joarmc 116281 Jan 5 2015 postgresql-setup-2.0.tar.gz
-rw-r--r--. 1 joarmc joarmc 68805 Feb 5 2015 postgresql.spec
-rw-r--r--. 1 joarmc joarmc 47 Feb 5 2015 postgresql.tmpfiles.d
-rw-r--r--. 1 joarmc joarmc 2114 Feb 5 2015 postgresql-var-run-socket.patch
-rw-r--r--. 1 joarmc joarmc 2395 Feb 5 2015 rpm-pgsql.patch
joarmc@mckown5 2015-08-08T20:35:16 ~/pg
And Bob's your uncle. Note that postgresql.spec is 4th from the bottom of that list. It's way too big to post.
On Sat, Aug 8, 2015 at 7:31 PM, AI Rumman <rummandba@xxxxxxxxx> wrote:
Hi,How to get postgresql official rpm spec file?Please let me know. I want to build my own Postgresql rpm.Thanks.
Schrodinger's backup: The condition of any backup is unknown until a restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown