Adding debian version 14.5-3.debian/14.5-3debian

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

70 files changed, 2596 insertions, 0 deletions

diff --git a/debian/changelog b/debian/changelog
new file mode 100644
index 0000000..9e0e440
--- /dev/null
+++ b/debian/changelog
@@ -0,0 +1,191 @@
+postgresql-14 (14.5-3) unstable; urgency=medium
+
+  * Stop building lib packages, postgresql-15 is already in unstable..
+    (Closes: #1022152)
+
+ -- Christoph Berg <myon@debian.org>  Sat, 22 Oct 2022 14:48:48 +0200
+
+postgresql-14 (14.5-2) unstable; urgency=medium
+
+  * Test-Depend on locales-all instead of locales.
+  * Add Italian debconf translation by Ceppo, thanks! (Closes: #1019162)
+
+ -- Christoph Berg <myon@debian.org>  Fri, 09 Sep 2022 22:23:26 +0200
+
+postgresql-14 (14.5-1) unstable; urgency=medium
+
+  * New upstream version.
+
+    + Do not let extension scripts replace objects not already belonging to
+      the extension (Tom Lane) (CVE-2022-2625)
+
+      This change prevents extension scripts from doing CREATE OR REPLACE if
+      there is an existing object that does not belong to the extension.  It
+      also prevents CREATE IF NOT EXISTS in the same situation.  This prevents
+      a form of trojan-horse attack in which a hostile database user could
+      become the owner of an extension object and then modify it to compromise
+      future uses of the object by other users.  As a side benefit, it also
+      reduces the risk of accidentally replacing objects one did not mean to.
+
+      The PostgreSQL Project thanks Sven Klemm for reporting this problem.
+
+  * Update lintian overrides.
+
+ -- Christoph Berg <myon@debian.org>  Wed, 10 Aug 2022 14:45:40 +0200
+
+postgresql-14 (14.4-1) unstable; urgency=medium
+
+  * New upstream release.
+
+    + Prevent possible corruption of indexes created or rebuilt with the
+      CONCURRENTLY option (Álvaro Herrera)
+
+      An optimization added in v14 caused CREATE INDEX ... CONCURRENTLY and
+      REINDEX ... CONCURRENTLY to sometimes miss indexing rows that were
+      updated during the index build.  Revert that optimization. It is
+      recommended that any indexes made with the CONCURRENTLY option be
+      rebuilt after installing this update.  (Alternatively, rebuild them
+      without CONCURRENTLY.)
+
+ -- Christoph Berg <myon@debian.org>  Tue, 14 Jun 2022 09:49:41 +0200
+
+postgresql-14 (14.3-1) unstable; urgency=medium
+
+  * New upstream release.
+
+    * Confine additional operations within security restricted operation
+      sandboxes (Sergey Shinderuk, Noah Misch)
+
+      Autovacuum, CLUSTER, CREATE INDEX, REINDEX, REFRESH MATERIALIZED VIEW,
+      and pg_amcheck activated the security restricted operation protection
+      mechanism too late, or even not at all in some code paths. A user having
+      permission to create non-temporary objects within a database could
+      define an object that would execute arbitrary SQL code with superuser
+      permissions the next time that autovacuum processed the object, or that
+      some superuser ran one of the affected commands against it.
+
+      The PostgreSQL Project thanks Alexander Lakhin for reporting this
+      problem. (CVE-2022-1552)
+
+    * Fix default signature length for gist_ltree_ops indexes
+      (Tomas Vondra, Alexander Korotkov)
+
+      The default signature length (hash size) for GiST indexes on ltree
+      columns was accidentally changed while upgrading that operator class to
+      support operator class parameters. If any operations had been done on
+      such an index without first upgrading the ltree extension to version
+      1.2, they were done assuming that the signature length was 28 bytes
+      rather than the intended 8.  This means it is very likely that such
+      indexes are now corrupt.  For safety we recommend re-indexing all GiST
+      indexes on ltree columns after installing this update.  (Note that GiST
+      indexes on ltree[] columns, that is arrays of ltree, are not affected.)
+
+ -- Christoph Berg <myon@debian.org>  Tue, 10 May 2022 10:34:28 +0200
+
+postgresql-14 (14.2-1) unstable; urgency=medium
+
+  * New upstream release.
+
+ -- Christoph Berg <myon@debian.org>  Wed, 09 Feb 2022 10:39:43 +0100
+
+postgresql-14 (14.1-5) unstable; urgency=medium
+
+  * Provide postgresql-14-jit-llvm (= ${llvm:Version}) so extensions can
+    depend on a matching llvm version.
+
+ -- Christoph Berg <myon@debian.org>  Mon, 03 Jan 2022 16:08:18 +0100
+
+postgresql-14 (14.1-4) unstable; urgency=medium
+
+  [ Christoph Berg ]
+  * Disable LLVM JIT on s390x for now. (See #1002029)
+
+  [ Christian Ehrhardt ]
+  * postgresql-common/server/postgresql.mk: avoid gcc 11 ICE on armhf and
+    armel.
+
+ -- Christoph Berg <myon@debian.org>  Mon, 20 Dec 2021 18:21:21 +0100
+
+postgresql-14 (14.1-3) unstable; urgency=medium
+
+  * Use system default clang/llvm version. (Closes: #1000915)
+  * Use centralized debian/rules logic in postgresql-common.
+
+ -- Christoph Berg <myon@debian.org>  Fri, 03 Dec 2021 09:56:49 +0100
+
+postgresql-14 (14.1-2) unstable; urgency=medium
+
+  * Enable outline-atomics on arm64 (affects Ubuntu focal only).
+
+ -- Christoph Berg <myon@debian.org>  Tue, 16 Nov 2021 11:56:37 +0100
+
+postgresql-14 (14.1-1) unstable; urgency=medium
+
+  * New upstream release.
+
+    + Make the server and libpq reject extraneous data after an SSL or GSS
+      encryption handshake (Tom Lane)
+
+      A man-in-the-middle with the ability to inject data into the TCP
+      connection could stuff some cleartext data into the start of a
+      supposedly encryption-protected database session.
+
+      This could be abused to send faked SQL commands to the server, although
+      that would only work if the server did not demand any authentication
+      data.  (However, a server relying on SSL certificate authentication
+      might well not do so.) (CVE-2021-23214)
+
+      This could probably be abused to inject faked responses to the client's
+      first few queries, although other details of libpq's behavior make that
+      harder than it sounds.  A different line of attack is to exfiltrate the
+      client's password, or other sensitive data that might be sent early in
+      the session.  That has been shown to be possible with a server
+      vulnerable to CVE-2021-23214. (CVE-2021-23222)
+
+      The PostgreSQL Project thanks Jacob Champion for reporting these
+      problems.
+
+  * libpq-dev: Depend on libssl-dev, `pkg-config --exists libpq` requires it.
+
+ -- Christoph Berg <myon@debian.org>  Fri, 05 Nov 2021 12:05:46 +0100
+
+postgresql-14 (14.0-1) unstable; urgency=medium
+
+  * First PG14 release.
+  * Depend on postgresql-common 229 for scram-sha-256 authentication by
+    default.
+
+ -- Christoph Berg <myon@debian.org>  Tue, 28 Sep 2021 13:56:00 +0200
+
+postgresql-14 (14~rc1-1) experimental; urgency=medium
+
+  * First PG14 release candidate.
+  * Enable spinlocks on riscv64.
+  * Fix awk to be mawk, spotted by Yangfl. (Closes: #987786)
+  * configure.ac: Remove check for autoconf 2.69.
+  * Spanish debconf translation by Jonathan Bustillos, thanks!
+    (Closes: #986775)
+  * Flatten debian/*.lintian-overrides symlinks.
+
+ -- Christoph Berg <myon@debian.org>  Thu, 23 Sep 2021 12:39:42 +0200
+
+postgresql-14 (14~beta3-1) experimental; urgency=medium
+
+  * New beta version.
+  * libpq5.symbols: Add PQsendFlushRequest.
+
+ -- Christoph Berg <myon@debian.org>  Tue, 10 Aug 2021 13:11:12 +0200
+
+postgresql-14 (14~beta2-1) experimental; urgency=medium
+
+  * New beta version.
+  * libpq5.symbols: Add PQmblenBounded, PQsetTraceFlags, remove PQtraceSetFlags.
+  * debian/tests/installcheck: Use --make-testtablespace-dir.
+
+ -- Christoph Berg <myon@debian.org>  Wed, 23 Jun 2021 11:03:06 +0200
+
+postgresql-14 (14~beta1-1) experimental; urgency=medium
+
+  * New major upstream version 14; packaging based on postgresql-13.
+
+ -- Christoph Berg <myon@debian.org>  Tue, 18 May 2021 13:40:56 +0200
diff --git a/debian/control b/debian/control
new file mode 100644
index 0000000..573df13
--- /dev/null
+++ b/debian/control
@@ -0,0 +1,291 @@
+Source: postgresql-14
+Section: database
+Priority: optional
+Maintainer: Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org>
+Uploaders:
+ Martin Pitt <mpitt@debian.org>,
+ Peter Eisentraut <petere@debian.org>,
+ Christoph Berg <myon@debian.org>,
+Standards-Version: 4.5.0
+Rules-Requires-Root: no
+Build-Depends:
+ autoconf,
+ bison,
+ clang [!alpha !hppa !hurd-i386 !ia64 !kfreebsd-amd64 !kfreebsd-i386 !m68k !powerpc !riscv64 !s390x !sh4 !sparc64 !x32],
+ debhelper-compat (= 13),
+ dh-exec (>= 0.13~),
+ docbook-xml,
+ docbook-xsl (>= 1.77),
+ dpkg-dev (>= 1.16.1~),
+ flex,
+ gdb <!nocheck>,
+ gettext,
+ libicu-dev,
+ libio-pty-perl <!nocheck>,
+ libipc-run-perl <!nocheck>,
+ libkrb5-dev,
+ libldap2-dev,
+ liblz4-dev,
+ libpam0g-dev | libpam-dev,
+ libperl-dev,
+ libreadline-dev,
+ libselinux1-dev [linux-any],
+ libssl-dev,
+ libsystemd-dev [linux-any],
+ libxml2-dev,
+ libxml2-utils,
+ libxslt1-dev,
+ llvm-dev [!alpha !hppa !hurd-i386 !ia64 !kfreebsd-amd64 !kfreebsd-i386 !m68k !powerpc !riscv64 !s390x !sh4 !sparc64 !x32],
+ mawk,
+ perl (>= 5.8),
+ pkg-config,
+ postgresql-common (>= 245~),
+ python3-dev,
+ systemtap-sdt-dev,
+ tcl-dev,
+ uuid-dev,
+ xsltproc,
+ zlib1g-dev | libz-dev,
+Homepage: http://www.postgresql.org/
+Vcs-Browser: https://salsa.debian.org/postgresql/postgresql
+Vcs-Git: https://salsa.debian.org/postgresql/postgresql.git -b 14
+
+Package: libpq-dev
+Architecture: any
+Section: libdevel
+Depends:
+ libpq5 (= ${binary:Version}),
+ libssl-dev,
+ ${misc:Depends},
+ ${shlibs:Depends},
+Suggests:
+ postgresql-doc-14,
+Description: header files for libpq5 (PostgreSQL library)
+ Header files and static library for compiling C programs to link
+ with the libpq library in order to communicate with a PostgreSQL
+ database backend.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: libpq5
+Architecture: any
+Section: libs
+Depends:
+ ${misc:Depends},
+ ${shlibs:Depends},
+Pre-Depends:
+ ${misc:Pre-Depends},
+Multi-Arch: same
+Description: PostgreSQL C client library
+ libpq is a C library that enables user programs to communicate with
+ the PostgreSQL database server.  The server can be on another machine
+ and accessed through TCP/IP.  This version of libpq is compatible
+ with servers from PostgreSQL 8.2 or later.
+ .
+ This package contains the run-time library, needed by packages using
+ libpq.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: libecpg6
+Architecture: any
+Section: libs
+Depends:
+ ${misc:Depends},
+ ${shlibs:Depends},
+Pre-Depends:
+ ${misc:Pre-Depends},
+Multi-Arch: same
+Description: run-time library for ECPG programs
+ The libecpg shared library is used by programs built with ECPG
+ (Embedded PostgreSQL for C).
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: libecpg-dev
+Architecture: any
+Section: libdevel
+Depends:
+ libecpg-compat3 (= ${binary:Version}),
+ libecpg6 (= ${binary:Version}),
+ libpgtypes3 (= ${binary:Version}),
+ libpq-dev,
+ ${misc:Depends},
+ ${shlibs:Depends},
+Description: development files for ECPG (Embedded PostgreSQL for C)
+ This package contains the necessary files to build ECPG (Embedded
+ PostgreSQL for C) programs.  It includes the development libraries
+ and the preprocessor program ecpg.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+ .
+ Install this package if you want to write C programs with SQL statements
+ embedded in them (rather than run by an external process).
+
+Package: libecpg-compat3
+Architecture: any
+Section: libs
+Depends:
+ ${misc:Depends},
+ ${shlibs:Depends},
+Pre-Depends:
+ ${misc:Pre-Depends},
+Multi-Arch: same
+Description: older version of run-time library for ECPG programs
+ The libecpg_compat shared library is used by programs built with ecpg.
+ (Embedded PostgreSQL for C).
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: libpgtypes3
+Architecture: any
+Section: libs
+Depends:
+ ${misc:Depends},
+ ${shlibs:Depends},
+Pre-Depends:
+ ${misc:Pre-Depends},
+Multi-Arch: same
+Description: shared library libpgtypes for PostgreSQL 14
+ The libpgtypes shared library is used by programs built with ecpg.
+ (Embedded PostgreSQL for C).
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: postgresql-14
+Architecture: any
+Depends:
+ locales | locales-all,
+ postgresql-client-14,
+ postgresql-common (>= 229~),
+ ssl-cert,
+ tzdata,
+ ${misc:Depends},
+ ${shlibs:Depends},
+Provides:
+ postgresql-contrib-14,
+ postgresql-14-jit-llvm (= ${llvm:Version}) [!alpha !hppa !hurd-i386 !ia64 !kfreebsd-amd64 !kfreebsd-i386 !m68k !powerpc !riscv64 !s390x !sh4 !sparc64 !x32],
+Recommends:
+ sysstat,
+Description: The World's Most Advanced Open Source Relational Database
+ PostgreSQL, also known as Postgres, is a free and open-source relational
+ database management system (RDBMS) emphasizing extensibility and SQL
+ compliance. It features transactions with Atomicity, Consistency, Isolation,
+ Durability (ACID) properties, automatically updatable views, materialized
+ views, triggers, foreign keys, and stored procedures. It is designed to handle
+ a range of workloads, from single machines to data warehouses or Web services
+ with many concurrent users.
+ .
+ This package provides the database server for PostgreSQL 14.${cassert}
+XB-Postgresql-Catversion: ${postgresql:Catversion}
+
+Package: postgresql-client-14
+Architecture: any
+Multi-Arch: foreign
+Depends:
+ libpq5 (>= ${source:Upstream-Version}),
+ postgresql-client-common (>= 182~),
+ sensible-utils,
+ ${misc:Depends},
+ ${shlibs:Depends},
+Suggests:
+ postgresql-14,
+ postgresql-doc-14,
+Provides:
+ postgresql-client,
+Description: front-end programs for PostgreSQL 14
+ This package contains client and administrative programs for
+ PostgreSQL: these are the interactive terminal client psql and
+ programs for creating and removing users and databases.
+ .
+ This is the client package for PostgreSQL 14. If you install
+ PostgreSQL 14 on a standalone machine, you need the server package
+ postgresql-14, too. On a network, you can install this package on
+ many client machines, while the server package may be installed on
+ only one machine.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: postgresql-server-dev-14
+Architecture: any
+Section: libdevel
+Depends:
+ clang-${llvm:Version} [!alpha !hppa !hurd-i386 !ia64 !kfreebsd-amd64 !kfreebsd-i386 !m68k !powerpc !riscv64 !s390x !sh4 !sparc64 !x32],
+ libpq-dev (>= 14~~),
+ llvm-${llvm:Version}-dev [!alpha !hppa !hurd-i386 !ia64 !kfreebsd-amd64 !kfreebsd-i386 !m68k !powerpc !riscv64 !s390x !sh4 !sparc64 !x32],
+ postgresql-client-14,
+ postgresql-common (>= 142~),
+ ${misc:Depends},
+ ${shlibs:Depends},
+Breaks:
+ postgresql-server-dev-all (<< 181~),
+Description: development files for PostgreSQL 14 server-side programming
+ Header files for compiling SSI code to link into PostgreSQL's backend; for
+ example, for C functions to be called from SQL.
+ .
+ This package also contains the Makefiles necessary for building add-on
+ modules of PostgreSQL, which would otherwise have to be built in the
+ PostgreSQL source-code tree.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: postgresql-doc-14
+Architecture: all
+Build-Profiles: <!nodoc>
+Multi-Arch: foreign
+Section: doc
+Depends:
+ ${misc:Depends},
+Breaks:
+ postgresql-common (<< 158~),
+Description: documentation for the PostgreSQL database management system
+ This package contains all README files, user manual, and examples for
+ PostgreSQL 14. The manual is in HTML format.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: postgresql-plperl-14
+Architecture: any
+Depends:
+ perl,
+ postgresql-14 (= ${binary:Version}),
+ ${misc:Depends},
+ ${shlibs:Depends},
+Provides:
+ postgresql-plperl,
+Description: PL/Perl procedural language for PostgreSQL 14
+ PL/Perl enables an SQL developer to write procedural language functions
+ for PostgreSQL 14 in Perl.  You need this package if you have any
+ PostgreSQL 14 functions that use the languages plperl or plperlu.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: postgresql-plpython3-14
+Architecture: any
+Depends:
+ postgresql-14 (= ${binary:Version}),
+ ${misc:Depends},
+ ${shlibs:Depends},
+Provides:
+ postgresql-plpython3,
+Description: PL/Python 3 procedural language for PostgreSQL 14
+ PL/Python 3 enables an SQL developer to write procedural language functions
+ for PostgreSQL 14 in Python 3.  You need this package if you have any
+ PostgreSQL 14 functions that use the languages plpython3 or plpython3u.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: postgresql-pltcl-14
+Architecture: any
+Depends:
+ postgresql-14 (= ${binary:Version}),
+ ${misc:Depends},
+ ${shlibs:Depends},
+Provides:
+ postgresql-pltcl,
+Description: PL/Tcl procedural language for PostgreSQL 14
+ PL/Tcl enables an SQL developer to write procedural language functions
+ for PostgreSQL 14 in Tcl.  You need this package if you have any
+ PostgreSQL 14 functions that use the languages pltcl or pltclu.
+ .
+ PostgreSQL is an object-relational SQL database management system.
diff --git a/debian/copyright b/debian/copyright
new file mode 100644
index 0000000..b78eca2
--- /dev/null
+++ b/debian/copyright
@@ -0,0 +1,333 @@
+Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/
+Upstream-Name: PostgreSQL
+Source: https://www.postgresql.org/ftp/source/
+
+### PostgreSQL copyrights ###
+
+Files: *
+Copyright: Portions Copyright (c) 1996-2019, PostgreSQL Global Development Group
+           Portions Copyright (c) 1994, The Regents of the University of California
+License: PostgreSQL
+ Permission to use, copy, modify, and distribute this software and its
+ documentation for any purpose, without fee, and without a written agreement
+ is hereby granted, provided that the above copyright notice and this
+ paragraph and the following two paragraphs appear in all copies.
+ .
+ IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR
+ DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING
+ LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
+ DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE
+ POSSIBILITY OF SUCH DAMAGE.
+ .
+ THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,
+ INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
+ AND FITNESS FOR A PARTICULAR PURPOSE.  THE SOFTWARE PROVIDED HEREUNDER IS
+ ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO
+ PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
+
+Files: src/backend/regex/*
+Copyright: Copyright (c) 1998, 1999 Henry Spencer.  All rights reserved.
+License: Custom-regex
+ Development of this software was funded, in part, by Cray Research Inc.,
+ UUNET Communications Services Inc., Sun Microsystems Inc., and Scriptics
+ Corporation, none of whom are responsible for the results.  The author
+ thanks all of them.
+ .
+ Redistribution and use in source and binary forms -- with or without
+ modification -- are permitted for any purpose, provided that
+ redistributions in source form retain this entire copyright notice and
+ indicate the origin and nature of any modifications.
+ .
+ I'd appreciate being given credit for this package in the documentation
+ of software which uses it, but that is not a requirement.
+ .
+ THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES,
+ INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
+ AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL
+ HENRY SPENCER BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
+ EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
+ PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
+ OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
+ WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
+ OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
+ ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+
+Files: src/backend/regex/regc_locale.c
+Copyright: Copyright (c) 1998 by Scriptics Corporation.
+License: Tcl
+
+Files: src/backend/regex/re_syntax.n
+Copyright: Copyright (c) 1998 Sun Microsystems, Inc.
+           Copyright (c) 1999 Scriptics Corporation
+License: Tcl
+
+Files: src/bin/pg_dump/*
+Copyright: Portions Copyright (c) 2000, Philip Warner
+License: Custom-pg_dump
+  Rights are granted to use this software in any way so long as this notice is
+  not removed.  The author is not responsible for loss or damages that may
+  result from its use.
+
+Files: src/backend/snowball/libstemmer/* src/include/snowball/libstemmer/*
+Copyright: Copyright (c) 2001, Dr Martin Porter,
+           Copyright (c) 2002, Richard Boulton.
+License: BSD-3-Clause
+Comment:
+ This module uses the word stemming code developed by the Snowball project,
+ http://snowballstem.org which is released by them under a BSD-style license.
+ Postgres' files under src/backend/snowball/libstemmer/ and
+ src/include/snowball/libstemmer/ are taken directly from the Snowball files,
+ with only some minor adjustments of file inclusions.
+ See src/backend/snowball/README for details.
+
+Files: src/backend/utils/mb/Unicode/*.txt
+Copyright: Copyright (C) 2001 earthian@tama.or.jp, All Rights Reserved.
+           Copyright (C) 2001 I'O, All Rights Reserved.
+           Copyright (C) 2006 Project X0213, All Rights Reserved.
+License: Custom-Unicode
+ You can use, modify, distribute this table freely.
+
+Files:
+ src/common/sha2.c
+ src/include/common/sha2.h
+Copyright: Copyright (c) 2000-2001, Aaron D. Gifford
+License: BSD-3-Clause
+
+### contrib copyrights ###
+
+Files: contrib/fuzzystrmatch/dmetaphone.c
+Copyright: Copyright 2000, Maurice Aubrey <maurice@hevanet.com>
+           Copyright 2003, North Carolina State Highway Patrol
+License: double-metaphone
+ This module is free software; you may redistribute it and/or
+ modify it under the same terms as Perl itself.
+ .
+ All rights reserved.
+ .
+ Permission to use, copy, modify, and distribute this software and its
+ documentation for any purpose, without fee, and without a written agreement
+ is hereby granted, provided that the above copyright notice and this
+ paragraph and the following two paragraphs appear in all copies.
+ .
+ IN NO EVENT SHALL THE NORTH CAROLINA STATE HIGHWAY PATROL BE LIABLE TO ANY
+ PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES,
+ INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
+ DOCUMENTATION, EVEN IF THE NORTH CAROLINA STATE HIGHWAY PATROL HAS BEEN
+ ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+ .
+ THE NORTH CAROLINA STATE HIGHWAY PATROL SPECIFICALLY DISCLAIMS ANY
+ WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
+ MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  THE SOFTWARE PROVIDED
+ HEREUNDER IS ON AN "AS IS" BASIS, AND THE NORTH CAROLINA STATE HIGHWAY PATROL
+ HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR
+ MODIFICATIONS.
+ .
+ The license of Perl is:
+ .
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of either:
+ .
+ a) the GNU General Public License as published by the Free Software
+    Foundation; either version 1, or (at your option) any later
+    version, or
+ .
+ b) the "Artistic License" which comes with Perl.
+ .
+ On Debian GNU/Linux systems, the complete text of the GNU General
+ Public License version 1 can be found in
+ `/usr/share/common-licenses/GPL-1' and the Artistic Licence in
+ `/usr/share/common-licenses/Artistic'.
+
+Files:
+ contrib/pageinspect/btreefuncs.c
+ contrib/pgrowlocks/*
+ contrib/pgstattuple/*
+Copyright: Copyright (c) 2006 Satoshi Nagayasu <nagayasus@nttdata.co.jp>
+           Copyright (c) 2001, 2002, 2005-2006 Tatsuo Ishii
+License: nagaysau-ishii
+ Permission to use, copy, modify, and distribute this software and
+ its documentation for any purpose, without fee, and without a
+ written agreement is hereby granted, provided that the above
+ copyright notice and this paragraph and the following two
+ paragraphs appear in all copies.
+ .
+ IN NO EVENT SHALL THE AUTHOR BE LIABLE TO ANY PARTY FOR DIRECT,
+ INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING
+ LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
+ DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED
+ OF THE POSSIBILITY OF SUCH DAMAGE.
+ .
+ THE AUTHOR SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT
+ LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
+ A PARTICULAR PURPOSE.  THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS
+ IS" BASIS, AND THE AUTHOR HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE,
+ SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
+
+Files: contrib/pgcrypto/blf.*
+Copyright: PuTTY is copyright 1997-2007 Simon Tatham.
+           Portions copyright Robert de Bath, Joris van Rantwijk, Delian
+           Delchev, Andreas Schultz, Jeroen Massar, Wez Furlong, Nicolas Barry,
+           Justin Bradford, Ben Harris, Malcolm Smith, Ahmad Khalifa, Markus
+           Kuhn, and CORE SDI S.A.
+License: blf
+ Permission is hereby granted, free of charge, to any person
+ obtaining a copy of this software and associated documentation files
+ (the "Software"), to deal in the Software without restriction,
+ including without limitation the rights to use, copy, modify, merge,
+ publish, distribute, sublicense, and/or sell copies of the Software,
+ and to permit persons to whom the Software is furnished to do so,
+ subject to the following conditions:
+ .
+ The above copyright notice and this permission notice shall be
+ included in all copies or substantial portions of the Software.
+ .
+ THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
+ EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
+ MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
+ NONINFRINGEMENT.  IN NO EVENT SHALL THE COPYRIGHT HOLDERS BE LIABLE
+ FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF
+ CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
+ WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
+
+Files:
+ contrib/pgcrypto/crypt-des.c
+ contrib/pgcrypto/md5.*
+ contrib/pgcrypto/sha1.*
+Copyright: Copyright (c) 1994 David Burren
+           Copyright (C) 1995, 1996, 1997, and 1998 WIDE Project.
+License: BSD-3-clause
+
+Files:
+ contrib/pgcrypto/internal*
+ contrib/pgcrypto/mbuf.*
+ contrib/pgcrypto/openssl.c
+ contrib/pgcrypto/pgcrypto.*
+ contrib/pgcrypto/pgp*
+ contrib/pgcrypto/px*
+Copyright: Copyright (c) 2001, 2005 Marko Kreen
+License: BSD-2-clause
+ Redistribution and use in source and binary forms, with or without
+ modification, are permitted provided that the following conditions
+ are met:
+ 1. Redistributions of source code must retain the above copyright
+        notice, this list of conditions and the following disclaimer.
+ 2. Redistributions in binary form must reproduce the above copyright
+        notice, this list of conditions and the following disclaimer in the
+        documentation and/or other materials provided with the distribution.
+ .
+ THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS'' AND
+ ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE
+ FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
+ DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
+ OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
+ HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
+ LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
+ OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
+ SUCH DAMAGE.
+
+Files: contrib/pgcrypto/imath.*
+Copyright: Copyright (C) 2002 Michael J. Fromberger
+License: imath
+ All Rights Reserved.
+ .
+ Permission is hereby granted, free of charge, to any person
+ obtaining a copy of this software and associated documentation files
+ (the "Software"), to deal in the Software without restriction,
+ including without limitation the rights to use, copy, modify, merge,
+ publish, distribute, sublicense, and/or sell copies of the Software,
+ and to permit persons to whom the Software is furnished to do so,
+ subject to the following conditions:
+ .
+ The above copyright notice and this permission notice shall be
+ included in all copies or substantial portions of the Software.
+ .
+ THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
+ EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
+ MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
+ NONINFRINGEMENT.  IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS
+ BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN
+ ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN
+ CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
+ SOFTWARE.
+
+Files: contrib/pgcrypto/rijndael.*
+Copyright: Dr Brian Gladman
+License: rijndael
+ Copyright in this implementation is held by Dr B R Gladman but I
+ hereby give permission for its free direct or derivative use subject
+ to acknowledgment of its origin and compliance with any conditions
+ that the originators of the algorithm place on its exploitation.
+
+### licenses ###
+
+License: BSD-3-Clause
+ All rights reserved.
+ .
+ Redistribution and use in source and binary forms, with or without
+ modification, are permitted provided that the following conditions are met:
+ .
+ 1. Redistributions of source code must retain the above copyright notice, this
+ list of conditions and the following disclaimer.
+ .
+ 2. Redistributions in binary form must reproduce the above copyright notice,
+ this list of conditions and the following disclaimer in the documentation
+ and/or other materials provided with the distribution.
+ .
+ 3. Neither the name of the copyright holder nor the names of its contributors
+ may be used to endorse or promote products derived from this software without
+ specific prior written permission.
+ .
+ THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
+ DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE
+ FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
+ DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
+ SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
+ CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
+ OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
+ OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+
+License: Tcl
+ This software is copyrighted by the Regents of the University of
+ California, Sun Microsystems, Inc., Scriptics Corporation, ActiveState
+ Corporation and other parties.  The following terms apply to all files
+ associated with the software unless explicitly disclaimed in
+ individual files.
+ .
+ The authors hereby grant permission to use, copy, modify, distribute,
+ and license this software and its documentation for any purpose, provided
+ that existing copyright notices are retained in all copies and that this
+ notice is included verbatim in any distributions. No written agreement,
+ license, or royalty fee is required for any of the authorized uses.
+ Modifications to this software may be copyrighted by their authors
+ and need not follow the licensing terms described here, provided that
+ the new terms are clearly indicated on the first page of each file where
+ they apply.
+ .
+ IN NO EVENT SHALL THE AUTHORS OR DISTRIBUTORS BE LIABLE TO ANY PARTY
+ FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES
+ ARISING OUT OF THE USE OF THIS SOFTWARE, ITS DOCUMENTATION, OR ANY
+ DERIVATIVES THEREOF, EVEN IF THE AUTHORS HAVE BEEN ADVISED OF THE
+ POSSIBILITY OF SUCH DAMAGE.
+ .
+ THE AUTHORS AND DISTRIBUTORS SPECIFICALLY DISCLAIM ANY WARRANTIES,
+ INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY,
+ FITNESS FOR A PARTICULAR PURPOSE, AND NON-INFRINGEMENT.  THIS SOFTWARE
+ IS PROVIDED ON AN "AS IS" BASIS, AND THE AUTHORS AND DISTRIBUTORS HAVE
+ NO OBLIGATION TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR
+ MODIFICATIONS.
+ .
+ GOVERNMENT USE: If you are acquiring this software on behalf of the
+ U.S. government, the Government shall have only "Restricted Rights"
+ in the software and related documentation as defined in the Federal
+ Acquisition Regulations (FARs) in Clause 52.227.19 (c) (2).  If you
+ are acquiring the software on behalf of the Department of Defense, the
+ software shall be classified as "Commercial Computer Software" and the
+ Government shall have only "Restricted Rights" as defined in Clause
+ 252.227-7013 (c) (1) of DFARs.  Notwithstanding the foregoing, the
+ authors grant the U.S. Government and others acting in its behalf
+ permission to use and distribute the software in accordance with the
+ terms specified in this license.
diff --git a/debian/gitlab-ci.yml b/debian/gitlab-ci.yml
new file mode 100644
index 0000000..67e4816
--- /dev/null
+++ b/debian/gitlab-ci.yml
@@ -0,0 +1 @@
+include: https://salsa.debian.org/postgresql/postgresql-common/raw/master/gitlab/gitlab-ci.yml
diff --git a/debian/libecpg-compat3.install b/debian/libecpg-compat3.install
new file mode 100644
index 0000000..c69d50d
--- /dev/null
+++ b/debian/libecpg-compat3.install
@@ -0,0 +1 @@
+usr/lib/*/libecpg_compat.so.3*
diff --git a/debian/libecpg-compat3.lintian-overrides b/debian/libecpg-compat3.lintian-overrides
new file mode 100644
index 0000000..8338c16
--- /dev/null
+++ b/debian/libecpg-compat3.lintian-overrides
@@ -0,0 +1,2 @@
+# False positive, -D_FORTIFY_SOURCE=2 is present when compiling informix.c
+hardening-no-fortify-functions *usr/lib/*/libecpg_compat.so.*
diff --git a/debian/libecpg-compat3.symbols b/debian/libecpg-compat3.symbols
new file mode 100644
index 0000000..3bd41e0
--- /dev/null
+++ b/debian/libecpg-compat3.symbols
@@ -0,0 +1,44 @@
+libecpg_compat.so.3 libecpg-compat3 #MINVER#
+* Build-Depends-Package: libecpg-dev
+ ECPG_informix_get_var@Base 0
+ ECPG_informix_reset_sqlca@Base 9.0~
+ ECPG_informix_set_var@Base 0
+ byleng@Base 0
+ decadd@Base 0
+ deccmp@Base 0
+ deccopy@Base 0
+ deccvasc@Base 0
+ deccvdbl@Base 0
+ deccvint@Base 0
+ deccvlong@Base 0
+ decdiv@Base 0
+ decmul@Base 0
+ decsub@Base 0
+ dectoasc@Base 0
+ dectodbl@Base 0
+ dectoint@Base 0
+ dectolong@Base 0
+ dtcurrent@Base 0
+ dtcvasc@Base 0
+ dtcvfmtasc@Base 0
+ dtsub@Base 0
+ dttoasc@Base 0
+ dttofmtasc@Base 0
+ intoasc@Base 0
+ ldchar@Base 0
+ rdatestr@Base 0
+ rdayofweek@Base 0
+ rdefmtdate@Base 0
+ rfmtdate@Base 0
+ rfmtlong@Base 0
+ rgetmsg@Base 0
+ risnull@Base 0
+ rjulmdy@Base 0
+ rmdyjul@Base 0
+ rsetnull@Base 0
+ rstrdate@Base 0
+ rtoday@Base 0
+ rtypalign@Base 0
+ rtypmsize@Base 0
+ rtypwidth@Base 0
+ rupshift@Base 0
diff --git a/debian/libecpg-dev.install b/debian/libecpg-dev.install
new file mode 100644
index 0000000..1935a0d
--- /dev/null
+++ b/debian/libecpg-dev.install
@@ -0,0 +1,18 @@
+usr/include/postgresql/ecpg*.h
+usr/include/postgresql/informix/*
+usr/include/postgresql/pgtypes*.h
+usr/include/postgresql/sql3types.h
+usr/include/postgresql/sqlca.h
+usr/include/postgresql/sqlda*.h
+usr/lib/*/libecpg.a
+usr/lib/*/libecpg.so
+usr/lib/*/libecpg_compat.a
+usr/lib/*/libecpg_compat.so
+usr/lib/*/libpgtypes.a
+usr/lib/*/libpgtypes.so
+usr/lib/*/pkgconfig/libecpg.pc
+usr/lib/*/pkgconfig/libecpg_compat.pc
+usr/lib/*/pkgconfig/libpgtypes.pc
+usr/lib/postgresql/*/bin/ecpg usr/bin
+usr/share/locale/*/*/ecpg-*.mo
+usr/share/postgresql/*/man/man1/ecpg.1* /usr/share/man/man1
diff --git a/debian/libecpg6.install b/debian/libecpg6.install
new file mode 100644
index 0000000..8ec1cee
--- /dev/null
+++ b/debian/libecpg6.install
@@ -0,0 +1,2 @@
+usr/lib/*/libecpg.so.6*
+usr/share/locale/*/*/ecpglib*.mo
diff --git a/debian/libecpg6.symbols b/debian/libecpg6.symbols
new file mode 100644
index 0000000..d20881a
--- /dev/null
+++ b/debian/libecpg6.symbols
@@ -0,0 +1,31 @@
+libecpg.so.6 libecpg6 #MINVER#
+* Build-Depends-Package: libecpg-dev
+ ECPGallocate_desc@Base 0
+ ECPGconnect@Base 0
+ ECPGdeallocate@Base 0
+ ECPGdeallocate_all@Base 0
+ ECPGdeallocate_desc@Base 0
+ ECPGdebug@Base 0
+ ECPGdescribe@Base 0
+ ECPGdisconnect@Base 0
+ ECPGdo@Base 0
+ ECPGdo_descriptor@Base 0
+ ECPGfree_auto_mem@Base 0
+ ECPGget_PGconn@Base 8.3.1-2~
+ ECPGget_desc@Base 0
+ ECPGget_desc_header@Base 0
+ ECPGget_sqlca@Base 0
+ ECPGget_var@Base 9.0~
+ ECPGis_noind_null@Base 0
+ ECPGprepare@Base 0
+ ECPGprepared_statement@Base 0
+ ECPGset_desc@Base 0
+ ECPGset_desc_header@Base 0
+ ECPGset_noind_null@Base 0
+ ECPGset_var@Base 9.0~
+ ECPGsetcommit@Base 0
+ ECPGsetconn@Base 0
+ ECPGstatus@Base 0
+ ECPGtrans@Base 0
+ ECPGtransactionStatus@Base 9.0~
+ sqlprint@Base 0
diff --git a/debian/libpgtypes3.install b/debian/libpgtypes3.install
new file mode 100644
index 0000000..decf90a
--- /dev/null
+++ b/debian/libpgtypes3.install
@@ -0,0 +1 @@
+usr/lib/*/libpgtypes.so.3*
diff --git a/debian/libpgtypes3.symbols b/debian/libpgtypes3.symbols
new file mode 100644
index 0000000..a398be3
--- /dev/null
+++ b/debian/libpgtypes3.symbols
@@ -0,0 +1,48 @@
+libpgtypes.so.3 libpgtypes3 #MINVER#
+* Build-Depends-Package: libecpg-dev
+ PGTYPESchar_free@Base 11~beta2
+ PGTYPESdate_dayofweek@Base 0
+ PGTYPESdate_defmt_asc@Base 0
+ PGTYPESdate_fmt_asc@Base 0
+ PGTYPESdate_free@Base 0
+ PGTYPESdate_from_asc@Base 0
+ PGTYPESdate_from_timestamp@Base 0
+ PGTYPESdate_julmdy@Base 0
+ PGTYPESdate_mdyjul@Base 0
+ PGTYPESdate_new@Base 0
+ PGTYPESdate_to_asc@Base 0
+ PGTYPESdate_today@Base 0
+ PGTYPESdecimal_free@Base 0
+ PGTYPESdecimal_new@Base 0
+ PGTYPESinterval_copy@Base 0
+ PGTYPESinterval_free@Base 0
+ PGTYPESinterval_from_asc@Base 0
+ PGTYPESinterval_new@Base 0
+ PGTYPESinterval_to_asc@Base 0
+ PGTYPESnumeric_add@Base 0
+ PGTYPESnumeric_cmp@Base 0
+ PGTYPESnumeric_copy@Base 0
+ PGTYPESnumeric_div@Base 0
+ PGTYPESnumeric_free@Base 0
+ PGTYPESnumeric_from_asc@Base 0
+ PGTYPESnumeric_from_decimal@Base 0
+ PGTYPESnumeric_from_double@Base 0
+ PGTYPESnumeric_from_int@Base 0
+ PGTYPESnumeric_from_long@Base 0
+ PGTYPESnumeric_mul@Base 0
+ PGTYPESnumeric_new@Base 0
+ PGTYPESnumeric_sub@Base 0
+ PGTYPESnumeric_to_asc@Base 0
+ PGTYPESnumeric_to_decimal@Base 0
+ PGTYPESnumeric_to_double@Base 0
+ PGTYPESnumeric_to_int@Base 0
+ PGTYPESnumeric_to_long@Base 0
+ PGTYPEStimestamp_add_interval@Base 0
+ PGTYPEStimestamp_current@Base 0
+ PGTYPEStimestamp_defmt_asc@Base 0
+ PGTYPEStimestamp_defmt_scan@Base 0
+ PGTYPEStimestamp_fmt_asc@Base 0
+ PGTYPEStimestamp_from_asc@Base 0
+ PGTYPEStimestamp_sub@Base 0
+ PGTYPEStimestamp_sub_interval@Base 0
+ PGTYPEStimestamp_to_asc@Base 0
diff --git a/debian/libpq-dev.dirs b/debian/libpq-dev.dirs
new file mode 100644
index 0000000..e772481
--- /dev/null
+++ b/debian/libpq-dev.dirs
@@ -0,0 +1 @@
+usr/bin
diff --git a/debian/libpq-dev.install b/debian/libpq-dev.install
new file mode 100644
index 0000000..734cb6f
--- /dev/null
+++ b/debian/libpq-dev.install
@@ -0,0 +1,11 @@
+usr/include/postgresql/internal/*
+usr/include/postgresql/libpq-events.h
+usr/include/postgresql/libpq-fe.h
+usr/include/postgresql/libpq/libpq-fs.h
+usr/include/postgresql/pg_config*.h
+usr/include/postgresql/postgres_ext.h
+usr/lib/*/libpq.a
+usr/lib/*/libpq.so
+usr/lib/*/pkgconfig/libpq.pc
+# pg_config manpage for both the perl and C versions
+usr/share/postgresql/*/man/man1/pg_config.1* /usr/share/man/man1
diff --git a/debian/libpq5.install b/debian/libpq5.install
new file mode 100644
index 0000000..c9811d7
--- /dev/null
+++ b/debian/libpq5.install
@@ -0,0 +1,2 @@
+usr/lib/*/libpq.so.5*
+usr/share/locale/*/LC_MESSAGES/libpq*.mo
diff --git a/debian/libpq5.symbols b/debian/libpq5.symbols
new file mode 100644
index 0000000..7adfae1
--- /dev/null
+++ b/debian/libpq5.symbols
@@ -0,0 +1,188 @@
+libpq.so.5 libpq5 #MINVER#
+* Build-Depends-Package: libpq-dev
+ PQbackendPID@Base 0
+ PQbinaryTuples@Base 0
+ PQcancel@Base 0
+ PQclear@Base 0
+ PQclientEncoding@Base 0
+ PQcmdStatus@Base 0
+ PQcmdTuples@Base 0
+ PQconndefaults@Base 0
+ PQconnectPoll@Base 0
+ PQconnectStart@Base 0
+ PQconnectStartParams@Base 9.0~
+ PQconnectdb@Base 0
+ PQconnectdbParams@Base 9.0~
+ PQconnectionNeedsPassword@Base 8.3~rc1-1~
+ PQconnectionUsedPassword@Base 8.3~
+ PQconninfo@Base 9.3~
+ PQconninfoFree@Base 0
+ PQconninfoParse@Base 8.4~
+ PQconsumeInput@Base 0
+ PQcopyResult@Base 8.4~
+ PQdb@Base 0
+ PQdefaultSSLKeyPassHook_OpenSSL@Base 13~~
+ PQdescribePortal@Base 0
+ PQdescribePrepared@Base 0
+ PQsendFlushRequest@Base 14~beta3
+ PQdisplayTuples@Base 0
+ PQdsplen@Base 0
+ PQencryptPassword@Base 0
+ PQencryptPasswordConn@Base 10~~
+ PQendcopy@Base 0
+ PQenterPipelineMode@Base 14~~
+ PQenv2encoding@Base 0
+ PQerrorMessage@Base 0
+ PQescapeBytea@Base 0
+ PQescapeByteaConn@Base 0
+ PQescapeIdentifier@Base 9.0~
+ PQescapeLiteral@Base 9.0~
+ PQescapeString@Base 0
+ PQescapeStringConn@Base 0
+ PQexec@Base 0
+ PQexecParams@Base 0
+ PQexecPrepared@Base 0
+ PQexitPipelineMode@Base 14~~
+ PQfformat@Base 0
+ PQfinish@Base 0
+ PQfireResultCreateEvents@Base 8.4~
+ PQflush@Base 0
+ PQfmod@Base 0
+ PQfn@Base 0
+ PQfname@Base 0
+ PQfnumber@Base 0
+ PQfreeCancel@Base 0
+ PQfreeNotify@Base 0
+ PQfreemem@Base 0
+ PQfsize@Base 0
+ PQftable@Base 0
+ PQftablecol@Base 0
+ PQftype@Base 0
+ PQgetCancel@Base 0
+ PQgetCopyData@Base 0
+ PQgetResult@Base 0
+ PQgetSSLKeyPassHook_OpenSSL@Base 13~~
+ PQgetgssctx@Base 12~~
+ PQgetisnull@Base 0
+ PQgetlength@Base 0
+ PQgetline@Base 0
+ PQgetlineAsync@Base 0
+ PQgetssl@Base 0
+ PQgetvalue@Base 0
+ PQgssEncInUse@Base 12~~
+ PQhost@Base 0
+ PQhostaddr@Base 12~~
+ PQinitOpenSSL@Base 8.4~
+ PQinitSSL@Base 0
+ PQinstanceData@Base 8.4~
+ PQisBusy@Base 0
+ PQisnonblocking@Base 0
+ PQisthreadsafe@Base 0
+ PQlibVersion@Base 9.1~
+ PQmakeEmptyPGresult@Base 0
+ PQmblen@Base 0
+ PQmblenBounded@Base 14~beta2
+ PQnfields@Base 0
+ PQnotifies@Base 0
+ PQnparams@Base 0
+ PQntuples@Base 0
+ PQoidStatus@Base 0
+ PQoidValue@Base 0
+ PQoptions@Base 0
+ PQparameterStatus@Base 0
+ PQparamtype@Base 0
+ PQpass@Base 0
+ PQping@Base 9.1~
+ PQpingParams@Base 9.1~
+ PQpipelineStatus@Base 14~~
+ PQpipelineSync@Base 14~~
+ PQport@Base 0
+ PQprepare@Base 0
+ PQprint@Base 0
+ PQprintTuples@Base 0
+ PQprotocolVersion@Base 0
+ PQputCopyData@Base 0
+ PQputCopyEnd@Base 0
+ PQputline@Base 0
+ PQputnbytes@Base 0
+ PQregisterEventProc@Base 8.4~
+ PQregisterThreadLock@Base 0
+ PQrequestCancel@Base 0
+ PQresStatus@Base 0
+ PQreset@Base 0
+ PQresetPoll@Base 0
+ PQresetStart@Base 0
+ PQresultAlloc@Base 8.4~
+ PQresultErrorField@Base 0
+ PQresultErrorMessage@Base 0
+ PQresultInstanceData@Base 8.4~
+ PQresultMemorySize@Base 12~~
+ PQresultSetInstanceData@Base 8.4~
+ PQresultStatus@Base 0
+ PQresultVerboseErrorMessage@Base 9.6~~
+ PQsendDescribePortal@Base 0
+ PQsendDescribePrepared@Base 0
+ PQsendPrepare@Base 0
+ PQsendQuery@Base 0
+ PQsendQueryParams@Base 0
+ PQsendQueryPrepared@Base 0
+ PQserverVersion@Base 0
+ PQsetClientEncoding@Base 0
+ PQsetErrorContextVisibility@Base 9.6~~
+ PQsetErrorVerbosity@Base 0
+ PQsetInstanceData@Base 8.4~
+ PQsetNoticeProcessor@Base 0
+ PQsetNoticeReceiver@Base 0
+ PQsetResultAttrs@Base 8.4~
+ PQsetSSLKeyPassHook_OpenSSL@Base 13~~
+ PQsetSingleRowMode@Base 9.2~beta3
+ PQsetTraceFlags@Base 14~beta2
+ PQsetdbLogin@Base 0
+ PQsetnonblocking@Base 0
+ PQsetvalue@Base 8.4~
+ PQsocket@Base 0
+ PQsslAttribute@Base 9.5~~
+ PQsslAttributeNames@Base 9.5~~
+ PQsslInUse@Base 9.5~~
+ PQsslStruct@Base 9.5~~
+ PQstatus@Base 0
+ PQtrace@Base 0
+ PQtransactionStatus@Base 0
+ PQtty@Base 0
+ PQunescapeBytea@Base 0
+ PQuntrace@Base 0
+ PQuser@Base 0
+ appendBinaryPQExpBuffer@Base 0
+ appendPQExpBuffer@Base 0
+ appendPQExpBufferChar@Base 0
+ appendPQExpBufferStr@Base 0
+ createPQExpBuffer@Base 0
+ destroyPQExpBuffer@Base 0
+ enlargePQExpBuffer@Base 0
+ initPQExpBuffer@Base 0
+ lo_close@Base 0
+ lo_creat@Base 0
+ lo_create@Base 0
+ lo_export@Base 0
+ lo_import@Base 0
+ lo_import_with_oid@Base 8.4~
+ lo_lseek64@Base 9.3~
+ lo_lseek@Base 0
+ lo_open@Base 0
+ lo_read@Base 0
+ lo_tell64@Base 9.3~
+ lo_tell@Base 0
+ lo_truncate64@Base 9.3~
+ lo_truncate@Base 8.3~
+ lo_unlink@Base 0
+ lo_write@Base 0
+ pg_char_to_encoding@Base 0
+ pg_encoding_to_char@Base 0
+ pg_utf_mblen@Base 0
+ pg_valid_server_encoding@Base 0
+ pg_valid_server_encoding_id@Base 8.3~beta1-2~
+ pgresStatus@Base 0
+ pqsignal@Base 0
+ printfPQExpBuffer@Base 0
+ resetPQExpBuffer@Base 0
+ termPQExpBuffer@Base 0
diff --git a/debian/patches/50-per-version-dirs.patch b/debian/patches/50-per-version-dirs.patch
new file mode 100644
index 0000000..7819df3
--- /dev/null
+++ b/debian/patches/50-per-version-dirs.patch
@@ -0,0 +1,69 @@
+Author: Martin Pitt <mpitt@debian.org>
+Description: Use version specific installation directories so that several major versions can be installed in parallel.
+Forwarded: No, Debian specific packaging with postgresql-common
+
+ * Install lib files into /usr/lib/postgresql/<version>/lib/
+ * Install server related header files into /usr/include/postgresql/<version>/server/
+ * Disable PostgreSQL's automagic path mangling and fix libdir for pg_config,
+   so that pg_config in /usr/bin and /usr/lib/postgresql/<version>/bin behave
+   identically.
+
+Bug-Debian: http://bugs.debian.org/462037
+
+--- a/src/Makefile.global.in
++++ b/src/Makefile.global.in
+@@ -119,7 +119,7 @@ libdir := @libdir@
+ pkglibdir = $(libdir)
+ ifeq "$(findstring pgsql, $(pkglibdir))" ""
+ ifeq "$(findstring postgres, $(pkglibdir))" ""
+-override pkglibdir := $(pkglibdir)/postgresql
++override pkglibdir := /usr/lib/postgresql/@PG_MAJORVERSION@/lib
+ endif
+ endif
+ 
+@@ -167,7 +167,7 @@ endif # PGXS
+ 
+ # These derived path variables aren't separately configurable.
+ 
+-includedir_server = $(pkgincludedir)/server
++includedir_server = $(pkgincludedir)/@PG_MAJORVERSION@/server
+ includedir_internal = $(pkgincludedir)/internal
+ pgxsdir = $(pkglibdir)/pgxs
+ bitcodedir = $(pkglibdir)/bitcode
+--- a/src/bin/pg_config/pg_config.c
++++ b/src/bin/pg_config/pg_config.c
+@@ -27,6 +27,8 @@
+ #include "common/config_info.h"
+ #include "port.h"
+ 
++#include "../port/pg_config_paths.h"
++
+ static const char *progname;
+ 
+ /*
+@@ -149,11 +151,7 @@ main(int argc, char **argv)
+ 		}
+ 	}
+ 
+-	if (find_my_exec(argv[0], my_exec_path) < 0)
+-	{
+-		fprintf(stderr, _("%s: could not find own program executable\n"), progname);
+-		exit(1);
+-	}
++	snprintf(my_exec_path, sizeof(my_exec_path), "%s/%s", PGBINDIR, progname);
+ 
+ 	configdata = get_configdata(my_exec_path, &configdata_len);
+ 	/* no arguments -> print everything */
+--- a/src/test/perl/TestLib.pm
++++ b/src/test/perl/TestLib.pm
+@@ -591,6 +591,10 @@ sub check_pg_config
+ 	  or die "could not execute pg_config";
+ 	chomp($stdout);
+ 	$stdout =~ s/\r$//;
++	# Debian's pg_config is not relocatable, manually check for correct location
++	if (-d "../../../build/tmp_install/usr/include/postgresql") {
++		$stdout = "../../../build/tmp_install/usr/include/postgresql";
++	}
+ 
+ 	open my $pg_config_h, '<', "$stdout/pg_config.h" or die "$!";
+ 	my $match = (grep { /^$regexp/ } <$pg_config_h>);
diff --git a/debian/patches/51-default-sockets-in-var.patch b/debian/patches/51-default-sockets-in-var.patch
new file mode 100644
index 0000000..5ea8488
--- /dev/null
+++ b/debian/patches/51-default-sockets-in-var.patch
@@ -0,0 +1,20 @@
+Author: Martin Pitt <mpitt@debian.org>
+Description: Put server Unix sockets into /var/run/postgresql/ by default
+Forwarded: No, Debian specific configuration with postgresql-common
+
+Using /tmp for sockets allows everyone to spoof a PostgreSQL server. Thus use
+/var/run/postgresql/ for "system" clusters which run as 'postgres' (user
+clusters will still use /tmp). Since system cluster are by far the common case,
+set it as default.
+
+--- a/src/include/pg_config_manual.h
++++ b/src/include/pg_config_manual.h
+@@ -201,7 +201,7 @@
+  * support them yet.
+  */
+ #ifndef WIN32
+-#define DEFAULT_PGSOCKET_DIR  "/tmp"
++#define DEFAULT_PGSOCKET_DIR  "/var/run/postgresql"
+ #else
+ #define DEFAULT_PGSOCKET_DIR ""
+ #endif
diff --git a/debian/patches/52-tutorial-README.patch b/debian/patches/52-tutorial-README.patch
new file mode 100644
index 0000000..9eb3263
--- /dev/null
+++ b/debian/patches/52-tutorial-README.patch
@@ -0,0 +1,16 @@
+Author: Martin Pitt <mpitt@debian.org>
+Description: Update tutorial README for required build dependencies.
+Forwarded: No, Debian specific
+
+--- a/src/tutorial/README
++++ b/src/tutorial/README
+@@ -6,8 +6,7 @@ tutorial
+ This directory contains SQL tutorial scripts.  To look at them, first do a
+ 	% make
+ to compile all the scripts and C files for the user-defined functions
+-and types.  (make needs to be GNU make --- it may be named something
+-different on your system, often 'gmake')
++and types. This requires a postgresql-server-dev-* package to be installed.
+ 
+ Then, run psql with the -s (single-step) flag:
+ 	% psql -s
diff --git a/debian/patches/53-pg_service.conf_directory_doc.patch b/debian/patches/53-pg_service.conf_directory_doc.patch
new file mode 100644
index 0000000..584b41c
--- /dev/null
+++ b/debian/patches/53-pg_service.conf_directory_doc.patch
@@ -0,0 +1,19 @@
+Author: Martin Pitt <mpitt@debian.org>
+Description: Update pg_service.conf example to tell the Debian specific file location.
+Forwarded: No, Debian specific
+
+Index: postgresql-9.2-9.2~beta1/src/interfaces/libpq/pg_service.conf.sample
+===================================================================
+--- postgresql-9.2-9.2~beta1.orig/src/interfaces/libpq/pg_service.conf.sample	2011-04-27 23:17:22.000000000 +0200
++++ postgresql-9.2-9.2~beta1/src/interfaces/libpq/pg_service.conf.sample	2011-05-10 11:25:42.151949794 +0200
+@@ -8,8 +8,8 @@
+ # to look up such parameters.  A sample configuration for postgres is
+ # included in this file.  Lines beginning with '#' are comments.
+ #
+-# Copy this to your sysconf directory (typically /usr/local/pgsql/etc) and
+-# rename it pg_service.conf.
++# Copy this to /etc/postgresql-common/ (or select its location with the
++# PGSYSCONFDIR environment variable) and rename it pg_service.conf.
+ #
+ #
+ #[postgres]
diff --git a/debian/patches/54-debian-alternatives-for-external-tools.patch b/debian/patches/54-debian-alternatives-for-external-tools.patch
new file mode 100644
index 0000000..0031989
--- /dev/null
+++ b/debian/patches/54-debian-alternatives-for-external-tools.patch
@@ -0,0 +1,28 @@
+Author: Martin Pitt <mpitt@debian.org>
+Description: Use Debian alternatives for external tools instead of hardcoded programs
+Forwarded: No, Debian specific
+
+--- a/src/bin/psql/settings.h
++++ b/src/bin/psql/settings.h
+@@ -19,8 +19,8 @@
+ #define DEFAULT_EDITOR	"notepad.exe"
+ /* no DEFAULT_EDITOR_LINENUMBER_ARG for Notepad */
+ #else
+-#define DEFAULT_EDITOR	"vi"
+-#define DEFAULT_EDITOR_LINENUMBER_ARG "+"
++#define DEFAULT_EDITOR	"sensible-editor"
++/*#define DEFAULT_EDITOR_LINENUMBER_ARG "+"*/
+ #endif
+ 
+ #define DEFAULT_PROMPT1 "%/%R%x%# "
+--- a/src/include/fe_utils/print.h
++++ b/src/include/fe_utils/print.h
+@@ -20,7 +20,7 @@
+ 
+ /* This is not a particularly great place for this ... */
+ #ifndef __CYGWIN__
+-#define DEFAULT_PAGER "more"
++#define DEFAULT_PAGER "pager"
+ #else
+ #define DEFAULT_PAGER "less"
+ #endif
diff --git a/debian/patches/70-history b/debian/patches/70-history
new file mode 100644
index 0000000..34c8683
--- /dev/null
+++ b/debian/patches/70-history
@@ -0,0 +1,13 @@
+Author: Christoph Berg <myon@debian.org>
+Description: Document Debian location of release notes files.
+Forwarded: No, Debian specific
+
+--- a/HISTORY
++++ b/HISTORY
+@@ -3,3 +3,6 @@
+ 
+ Distribution file sets include release notes for their version and preceding
+ versions.  Visit the file doc/src/sgml/html/release.html in an HTML browser.
++
++On Debian systems, the release notes are contained in the postgresql-doc-*
++packages, located in /usr/share/doc/postgresql-doc-*/html/release.html.
diff --git a/debian/patches/autoconf2.69 b/debian/patches/autoconf2.69
new file mode 100644
index 0000000..009955f
--- /dev/null
+++ b/debian/patches/autoconf2.69
@@ -0,0 +1,7 @@
+--- a/configure.ac
++++ b/configure.ac
+@@ -22,4 +21,0 @@ AC_INIT([PostgreSQL], [14.1], [pgsql-bug
+-m4_if(m4_defn([m4_PACKAGE_VERSION]), [2.69], [], [m4_fatal([Autoconf version 2.69 is required.
+-Untested combinations of 'autoconf' and PostgreSQL versions are not
+-recommended.  You can remove the check from 'configure.ac' but it is then
+-your responsibility whether the result works or not.])])
diff --git a/debian/patches/extension_destdir b/debian/patches/extension_destdir
new file mode 100644
index 0000000..a9d0799
--- /dev/null
+++ b/debian/patches/extension_destdir
@@ -0,0 +1,270 @@
+--- a/src/backend/utils/misc/guc.c
++++ b/src/backend/utils/misc/guc.c
+@@ -599,6 +599,7 @@ char	   *ConfigFileName;
+ char	   *HbaFileName;
+ char	   *IdentFileName;
+ char	   *external_pid_file;
++char	   *extension_destdir;
+ 
+ char	   *pgstat_temp_directory;
+ 
+@@ -4384,6 +4385,17 @@ static struct config_string ConfigureNam
+ 	},
+ 
+ 	{
++		{"extension_destdir", PGC_SUSET, FILE_LOCATIONS,
++			gettext_noop("Path to prepend for extension loading"),
++			gettext_noop("This directory is prepended to paths when loading extensions (control and SQL files), and to the '$libdir' directive when loading modules that back functions. The location is made configurable to allow build-time testing of extensions that do not have been installed to their proper location yet."),
++			GUC_SUPERUSER_ONLY
++		},
++		&extension_destdir,
++		"",
++		NULL, NULL, NULL
++	},
++
++	{
+ 		{"ssl_library", PGC_INTERNAL, PRESET_OPTIONS,
+ 			gettext_noop("Shows the name of the SSL library."),
+ 			NULL,
+--- a/src/backend/commands/extension.c
++++ b/src/backend/commands/extension.c
+@@ -128,6 +128,8 @@ static void ApplyExtensionUpdates(Oid ex
+ 								  bool cascade,
+ 								  bool is_create);
+ static char *read_whole_file(const char *filename, int *length);
++static bool file_exists(const char *name);
++static bool directory_exists(const char *dir);
+ 
+ 
+ /*
+@@ -388,6 +390,16 @@ get_extension_control_filename(const cha
+ 
+ 	get_share_path(my_exec_path, sharepath);
+ 	result = (char *) palloc(MAXPGPATH);
++	/*
++	 * If extension_destdir is set, try to find the file there first
++	 */
++	if (*extension_destdir != '\0')
++	{
++		snprintf(result, MAXPGPATH, "%s%s/extension/%s.control",
++				 extension_destdir, sharepath, extname);
++		if (file_exists(result))
++			return result;
++	}
+ 	snprintf(result, MAXPGPATH, "%s/extension/%s.control",
+ 			 sharepath, extname);
+ 
+@@ -427,6 +439,16 @@ get_extension_aux_control_filename(Exten
+ 	scriptdir = get_extension_script_directory(control);
+ 
+ 	result = (char *) palloc(MAXPGPATH);
++	/*
++	 * If extension_destdir is set, try to find the file there first
++	 */
++	if (*extension_destdir != '\0')
++	{
++		snprintf(result, MAXPGPATH, "%s%s/%s--%s.control",
++				 extension_destdir, scriptdir, control->name, version);
++		if (file_exists(result))
++			return result;
++	}
+ 	snprintf(result, MAXPGPATH, "%s/%s--%s.control",
+ 			 scriptdir, control->name, version);
+ 
+@@ -445,6 +467,23 @@ get_extension_script_filename(ExtensionC
+ 	scriptdir = get_extension_script_directory(control);
+ 
+ 	result = (char *) palloc(MAXPGPATH);
++	/*
++	 * If extension_destdir is set, try to find the file there first
++	 */
++	if (*extension_destdir != '\0')
++	{
++		if (from_version)
++			snprintf(result, MAXPGPATH, "%s%s/%s--%s--%s.sql",
++					 extension_destdir, scriptdir, control->name, from_version, version);
++		else
++			snprintf(result, MAXPGPATH, "%s%s/%s--%s.sql",
++					 extension_destdir, scriptdir, control->name, version);
++		if (file_exists(result))
++		{
++			pfree(scriptdir);
++			return result;
++		}
++	}
+ 	if (from_version)
+ 		snprintf(result, MAXPGPATH, "%s/%s--%s--%s.sql",
+ 				 scriptdir, control->name, from_version, version);
+@@ -1122,6 +1161,59 @@ get_ext_ver_list(ExtensionControlFile *c
+ 	DIR		   *dir;
+ 	struct dirent *de;
+ 
++	/*
++	 * If extension_destdir is set, try to find the files there first
++	 */
++	if (*extension_destdir != '\0')
++	{
++		char		location[MAXPGPATH];
++
++		snprintf(location, MAXPGPATH, "%s%s", extension_destdir,
++				get_extension_script_directory(control));
++		dir = AllocateDir(location);
++		while ((de = ReadDir(dir, location)) != NULL)
++		{
++			char	   *vername;
++			char	   *vername2;
++			ExtensionVersionInfo *evi;
++			ExtensionVersionInfo *evi2;
++
++			/* must be a .sql file ... */
++			if (!is_extension_script_filename(de->d_name))
++				continue;
++
++			/* ... matching extension name followed by separator */
++			if (strncmp(de->d_name, control->name, extnamelen) != 0 ||
++				de->d_name[extnamelen] != '-' ||
++				de->d_name[extnamelen + 1] != '-')
++				continue;
++
++			/* extract version name(s) from 'extname--something.sql' filename */
++			vername = pstrdup(de->d_name + extnamelen + 2);
++			*strrchr(vername, '.') = '\0';
++			vername2 = strstr(vername, "--");
++			if (!vername2)
++			{
++				/* It's an install, not update, script; record its version name */
++				evi = get_ext_ver_info(vername, &evi_list);
++				evi->installable = true;
++				continue;
++			}
++			*vername2 = '\0';		/* terminate first version */
++			vername2 += 2;			/* and point to second */
++
++			/* if there's a third --, it's bogus, ignore it */
++			if (strstr(vername2, "--"))
++				continue;
++
++			/* Create ExtensionVersionInfos and link them together */
++			evi = get_ext_ver_info(vername, &evi_list);
++			evi2 = get_ext_ver_info(vername2, &evi_list);
++			evi->reachable = lappend(evi->reachable, evi2);
++		}
++		FreeDir(dir);
++	}
++
+ 	location = get_extension_script_directory(control);
+ 	dir = AllocateDir(location);
+ 	while ((de = ReadDir(dir, location)) != NULL)
+@@ -3470,3 +3562,32 @@ read_whole_file(const char *filename, in
+ 	buf[*length] = '\0';
+ 	return buf;
+ }
++
++static bool
++file_exists(const char *name)
++{
++	struct stat st;
++
++	AssertArg(name != NULL);
++
++	if (stat(name, &st) == 0)
++		return S_ISDIR(st.st_mode) ? false : true;
++	else if (!(errno == ENOENT || errno == ENOTDIR || errno == EACCES))
++		ereport(ERROR,
++				(errcode_for_file_access(),
++				 errmsg("could not access file \"%s\": %m", name)));
++
++	return false;
++}
++
++static bool
++directory_exists(const char *dir)
++{
++	struct stat st;
++
++	if (stat(dir, &st) != 0)
++		return false;
++	if (S_ISDIR(st.st_mode))
++		return true;
++	return false;
++}
+--- a/src/include/utils/guc.h
++++ b/src/include/utils/guc.h
+@@ -270,6 +270,7 @@ extern PGDLLIMPORT char *ConfigFileName;
+ extern char *HbaFileName;
+ extern char *IdentFileName;
+ extern char *external_pid_file;
++extern char *extension_destdir;
+ 
+ extern PGDLLIMPORT char *application_name;
+ 
+--- a/src/backend/utils/fmgr/dfmgr.c
++++ b/src/backend/utils/fmgr/dfmgr.c
+@@ -34,6 +34,7 @@
+ #include "lib/stringinfo.h"
+ #include "miscadmin.h"
+ #include "storage/shmem.h"
++#include "utils/guc.h"
+ #include "utils/hsearch.h"
+ 
+ 
+@@ -487,7 +488,7 @@ expand_dynamic_library_name(const char *
+ {
+ 	bool		have_slash;
+ 	char	   *new;
+-	char	   *full;
++	char	   *full, *full2;
+ 
+ 	AssertArg(name);
+ 
+@@ -502,6 +503,19 @@ expand_dynamic_library_name(const char *
+ 	else
+ 	{
+ 		full = substitute_libpath_macro(name);
++		/*
++		 * If extension_destdir is set, try to find the file there first
++		 */
++		if (*extension_destdir != '\0')
++		{
++			full2 = psprintf("%s%s", extension_destdir, full);
++			if (file_exists(full2))
++			{
++				pfree(full);
++				return full2;
++			}
++			pfree(full2);
++		}
+ 		if (file_exists(full))
+ 			return full;
+ 		pfree(full);
+@@ -520,6 +534,19 @@ expand_dynamic_library_name(const char *
+ 	{
+ 		full = substitute_libpath_macro(new);
+ 		pfree(new);
++		/*
++		 * If extension_destdir is set, try to find the file there first
++		 */
++		if (*extension_destdir != '\0')
++		{
++			full2 = psprintf("%s%s", extension_destdir, full);
++			if (file_exists(full2))
++			{
++				pfree(full);
++				return full2;
++			}
++			pfree(full2);
++		}
+ 		if (file_exists(full))
+ 			return full;
+ 		pfree(full);
+--- a/src/backend/utils/misc/postgresql.conf.sample
++++ b/src/backend/utils/misc/postgresql.conf.sample
+@@ -725,6 +725,8 @@
+ # - Other Defaults -
+ 
+ #dynamic_library_path = '$libdir'
++#extension_destdir = ''			# prepend path when loading extensions
++					# and shared objects (added by Debian)
+ #gin_fuzzy_search_limit = 0
+ 
+ 
diff --git a/debian/patches/filter-debug-prefix-map b/debian/patches/filter-debug-prefix-map
new file mode 100644
index 0000000..e1b6709
--- /dev/null
+++ b/debian/patches/filter-debug-prefix-map
@@ -0,0 +1,44 @@
+To make the PostgreSQL server packages build reproducibly, we need to remove
+the build path from -fdebug-prefix-map and -ffile-prefix-map in CFLAGS.
+
+* The actual server build still uses the original CFLAGS so the build path is
+  correctly mapped in the object files.
+* The information printed by the pg_config binary and the system view is
+  filtered in src/common/Makefile and the configure script.
+* The build paths stored in Makefile.global are filtered in debian/rules.
+  (abs_top_builddir, abs_top_srcdir, configure_args, CFLAGS)
+* To make PGXS module builds reproducible, pg_buildext copies the environment
+  CFLAGS to COPT where Makefile.global picks them up, using the prefix maps
+  from dpkg-buildflags.
+
+--- a/src/common/Makefile
++++ b/src/common/Makefile
+@@ -33,7 +33,7 @@ STD_CPPFLAGS := $(filter-out -I$(top_src
+ STD_LDFLAGS := $(filter-out -L$(top_builddir)/src/common -L$(top_builddir)/src/port,$(LDFLAGS))
+ override CPPFLAGS += -DVAL_CC="\"$(CC)\""
+ override CPPFLAGS += -DVAL_CPPFLAGS="\"$(STD_CPPFLAGS)\""
+-override CPPFLAGS += -DVAL_CFLAGS="\"$(CFLAGS)\""
++override CPPFLAGS += -DVAL_CFLAGS="\"$(filter-out -fdebug-prefix-map=% -ffile-prefix-map=%,$(CFLAGS))\""
+ override CPPFLAGS += -DVAL_CFLAGS_SL="\"$(CFLAGS_SL)\""
+ override CPPFLAGS += -DVAL_LDFLAGS="\"$(STD_LDFLAGS)\""
+ override CPPFLAGS += -DVAL_LDFLAGS_EX="\"$(LDFLAGS_EX)\""
+--- a/configure.ac
++++ b/configure.ac
+@@ -27,6 +27,7 @@ AC_COPYRIGHT([Copyright (c) 1996-2020, P
+ AC_CONFIG_SRCDIR([src/backend/access/common/heaptuple.c])
+ AC_CONFIG_AUX_DIR(config)
+ AC_PREFIX_DEFAULT(/usr/local/pgsql)
++[ac_configure_args=$(echo "$ac_configure_args" | sed -e "s/ -f\(debug\|file\)-prefix-map=[^' ]*//g")]
+ AC_DEFINE_UNQUOTED(CONFIGURE_ARGS, ["$ac_configure_args"], [Saved arguments from configure])
+ 
+ [PG_MAJORVERSION=`expr "$PACKAGE_VERSION" : '\([0-9][0-9]*\)'`]
+--- a/configure
++++ b/configure
+@@ -2796,6 +2796,7 @@ ac_config_sub="$SHELL $ac_aux_dir/config
+ ac_configure="$SHELL $ac_aux_dir/configure"  # Please don't use this var.
+ 
+ 
++ac_configure_args=$(echo "$ac_configure_args" | sed -e "s/ -f\(debug\|file\)-prefix-map=[^' ]*//g")
+ 
+ 
+ cat >>confdefs.h <<_ACEOF
diff --git a/debian/patches/focal-arm64-outline-atomics b/debian/patches/focal-arm64-outline-atomics
new file mode 100644
index 0000000..7d101f1
--- /dev/null
+++ b/debian/patches/focal-arm64-outline-atomics
@@ -0,0 +1,23 @@
+Enable outline-atomics on arm64.
+
+The flag was added in focal's gcc, but is off by default there. It is enabled
+by default on all later distributions (hirsute, impish, bullseye, bookwork,
+sid).
+
+https://www.postgresql.org/message-id/flat/1635221042457.21654%40amazon.com
+
+This patch can be removed once focal is EOL.
+
+--- a/configure.ac
++++ b/configure.ac
+@@ -538,6 +538,10 @@ if test "$GCC" = yes -a "$ICC" = no; the
+   if test -n "$NOT_THE_CFLAGS"; then
+     CFLAGS="$CFLAGS -Wno-stringop-truncation"
+   fi
++  if test x"$host_cpu" == x"aarch64"; then
++    PGAC_PROG_CC_CFLAGS_OPT([-moutline-atomics])
++    PGAC_PROG_CXX_CFLAGS_OPT([-moutline-atomics])
++  fi
+ elif test "$ICC" = yes; then
+   # Intel's compiler has a bug/misoptimization in checking for
+   # division by NAN (NaN == 0), -mp1 fixes it, so add it to the CFLAGS.
diff --git a/debian/patches/libpgport-pkglibdir b/debian/patches/libpgport-pkglibdir
new file mode 100644
index 0000000..0677f5b
--- /dev/null
+++ b/debian/patches/libpgport-pkglibdir
@@ -0,0 +1,84 @@
+Author: Christoph Berg <myon@debian.org>
+Description: Move libpgport/libpgcommon/libpgfeutils from libdir to pkglibdir
+ This allows client applications to link to version-specific libraries.
+ Used by pg-checksums.
+Forwarded: No, (somewhat) Debian specific
+
+--- a/src/common/Makefile
++++ b/src/common/Makefile
+@@ -68,15 +68,15 @@ all: libpgcommon.a libpgcommon_shlib.a l
+ 
+ # libpgcommon is needed by some contrib
+ install: all installdirs
+-	$(INSTALL_STLIB) libpgcommon.a '$(DESTDIR)$(libdir)/libpgcommon.a'
+-	$(INSTALL_STLIB) libpgcommon_shlib.a '$(DESTDIR)$(libdir)/libpgcommon_shlib.a'
++	$(INSTALL_STLIB) libpgcommon.a '$(DESTDIR)$(pkglibdir)/libpgcommon.a'
++	$(INSTALL_STLIB) libpgcommon_shlib.a '$(DESTDIR)$(pkglibdir)/libpgcommon_shlib.a'
+ 
+ installdirs:
+-	$(MKDIR_P) '$(DESTDIR)$(libdir)'
++	$(MKDIR_P) '$(DESTDIR)$(pkglibdir)'
+ 
+ uninstall:
+-	rm -f '$(DESTDIR)$(libdir)/libpgcommon.a'
+-	rm -f '$(DESTDIR)$(libdir)/libpgcommon_shlib.a'
++	rm -f '$(DESTDIR)$(pkglibdir)/libpgcommon.a'
++	rm -f '$(DESTDIR)$(pkglibdir)/libpgcommon_shlib.a'
+ 
+ libpgcommon.a: $(OBJS_FRONTEND)
+ 	rm -f $@
+--- a/src/fe_utils/Makefile
++++ b/src/fe_utils/Makefile
+@@ -35,13 +35,13 @@ distprep: psqlscan.c
+ 
+ # libpgfeutils could be useful to contrib, so install it
+ install: all installdirs
+-	$(INSTALL_STLIB) libpgfeutils.a '$(DESTDIR)$(libdir)/libpgfeutils.a'
++	$(INSTALL_STLIB) libpgfeutils.a '$(DESTDIR)$(pkglibdir)/libpgfeutils.a'
+ 
+ installdirs:
+-	$(MKDIR_P) '$(DESTDIR)$(libdir)'
++	$(MKDIR_P) '$(DESTDIR)$(pkglibdir)'
+ 
+ uninstall:
+-	rm -f '$(DESTDIR)$(libdir)/libpgfeutils.a'
++	rm -f '$(DESTDIR)$(pkglibdir)/libpgfeutils.a'
+ 
+ clean distclean:
+ 	rm -f libpgfeutils.a $(OBJS) lex.backup
+--- a/src/port/Makefile
++++ b/src/port/Makefile
+@@ -54,15 +54,15 @@ all: libpgport.a libpgport_shlib.a libpg
+ 
+ # libpgport is needed by some contrib
+ install: all installdirs
+-	$(INSTALL_STLIB) libpgport.a '$(DESTDIR)$(libdir)/libpgport.a'
+-	$(INSTALL_STLIB) libpgport_shlib.a '$(DESTDIR)$(libdir)/libpgport_shlib.a'
++	$(INSTALL_STLIB) libpgport.a '$(DESTDIR)$(pkglibdir)/libpgport.a'
++	$(INSTALL_STLIB) libpgport_shlib.a '$(DESTDIR)$(pkglibdir)/libpgport_shlib.a'
+ 
+ installdirs:
+-	$(MKDIR_P) '$(DESTDIR)$(libdir)'
++	$(MKDIR_P) '$(DESTDIR)$(pkglibdir)'
+ 
+ uninstall:
+-	rm -f '$(DESTDIR)$(libdir)/libpgport.a'
+-	rm -f '$(DESTDIR)$(libdir)/libpgport_shlib.a'
++	rm -f '$(DESTDIR)$(pkglibdir)/libpgport.a'
++	rm -f '$(DESTDIR)$(pkglibdir)/libpgport_shlib.a'
+ 
+ libpgport.a: $(OBJS)
+ 	rm -f $@
+--- a/src/Makefile.global.in
++++ b/src/Makefile.global.in
+@@ -549,8 +549,8 @@ libpq = -L$(libpq_builddir) -lpq
+ # on client link lines, since that also appears in $(LIBS).
+ # libpq_pgport_shlib is the same idea, but for use in client shared libraries.
+ ifdef PGXS
+-libpq_pgport = -L$(libdir) -lpgcommon -lpgport $(libpq)
+-libpq_pgport_shlib = -L$(libdir) -lpgcommon_shlib -lpgport_shlib $(libpq)
++libpq_pgport = -L$(pkglibdir) -lpgcommon -lpgport $(libpq)
++libpq_pgport_shlib = -L$(pkglibdir) -lpgcommon_shlib -lpgport_shlib $(libpq)
+ else
+ libpq_pgport = -L$(top_builddir)/src/common -lpgcommon -L$(top_builddir)/src/port -lpgport $(libpq)
+ libpq_pgport_shlib = -L$(top_builddir)/src/common -lpgcommon_shlib -L$(top_builddir)/src/port -lpgport_shlib $(libpq)
diff --git a/debian/patches/series b/debian/patches/series
new file mode 100644
index 0000000..411958b
--- /dev/null
+++ b/debian/patches/series
@@ -0,0 +1,11 @@
+50-per-version-dirs.patch
+51-default-sockets-in-var.patch
+52-tutorial-README.patch
+53-pg_service.conf_directory_doc.patch
+54-debian-alternatives-for-external-tools.patch
+70-history
+filter-debug-prefix-map
+libpgport-pkglibdir
+extension_destdir
+autoconf2.69
+focal-arm64-outline-atomics
diff --git a/debian/po/POTFILES.in b/debian/po/POTFILES.in
new file mode 100644
index 0000000..d67e77d
--- /dev/null
+++ b/debian/po/POTFILES.in
@@ -0,0 +1 @@
+[type: gettext/rfc822deb] postgresql-14.templates
diff --git a/debian/po/de.po b/debian/po/de.po
new file mode 100644
index 0000000..df2bd4d
--- /dev/null
+++ b/debian/po/de.po
@@ -0,0 +1,37 @@
+# SOME DESCRIPTIVE TITLE.
+# Copyright (C) YEAR THE PACKAGE'S COPYRIGHT HOLDER
+# This file is distributed under the same license as the postgresql-11 package.
+# Copyright (C) Helge Kreutzmann <debian@helgefjell.de>, 2019.
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: postgresql-11 11.1-2\n"
+"Report-Msgid-Bugs-To: postgresql-11@packages.debian.org\n"
+"POT-Creation-Date: 2019-01-09 15:22+0100\n"
+"PO-Revision-Date: 2019-01-19 07:33+0100\n"
+"Last-Translator: Helge Kreutzmann <debian@helgefjell.de>\n"
+"Language-Team: German <debian-l10n-german@lists.debian.org>\n"
+"Language: de\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid "Remove PostgreSQL directories when package is purged?"
+msgstr ""
+"PostgreSQL-Verzeichnisse entfernen, wenn das Paket endgültig gelöscht wird?"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid ""
+"Removing the PostgreSQL server package will leave existing database clusters "
+"intact, i.e. their configuration, data, and log directories will not be "
+"removed. On purging the package, the directories can optionally be removed."
+msgstr ""
+"Beim Entfernen der PostgreSQL-Server-Pakete werden existierende Datenbank-"
+"Cluster intakt gelassen, d.h. ihre Konfigurations-, Daten- und "
+"Log-Verzeichnisse werden nicht entfernt. Beim endgültigen Löschen des "
+"Pakets können die Verzeichnisse optional entfernt werden."
diff --git a/debian/po/es.po b/debian/po/es.po
new file mode 100644
index 0000000..d408e65
--- /dev/null
+++ b/debian/po/es.po
@@ -0,0 +1,58 @@
+# postgresql-13 po-debconf translation to Spanish.
+# Copyright (C) 2021 Software in the Public Interest
+# This file is distributed under the same license as the postgresql-13 package.
+#
+# Changes:
+# - Initial translation
+# Jonathan Bustillos <jathan@debian.org>, 2021.
+#
+# Traductores, si no conocen el formato PO, merece la pena leer la
+# documentación de gettext, especialmente las secciones dedicadas a este
+# formato, por ejemplo ejecutando:
+# info -n '(gettext)PO Files'
+# info -n '(gettext)Header Entry'
+#
+# Equipo de traducción al español, por favor lean antes de traducir
+# los siguientes documentos:
+#
+# - El proyecto de traducción de Debian al español
+# http://www.debian.org/intl/spanish/
+# especialmente las notas y normas de traducción en
+# http://www.debian.org/intl/spanish/notas
+#
+# - La guía de traducción de po's de debconf:
+# /usr/share/doc/po-debconf/README-trans
+# o http://www.debian.org/intl/l10n/po-debconf/README-trans
+msgid ""
+msgstr ""
+"Project-Id-Version: PACKAGE VERSION\n"
+"Report-Msgid-Bugs-To: \n"
+"POT-Creation-Date: 2021-03-31 18:37+0000\n"
+"PO-Revision-Date: 2021-04-03 14:25-0600\n"
+"Last-Translator: Jonathan Bustillos <jathan@debian.org>\n"
+"Language-Team: Debian Spanish <debian-l10n-spanish@lists.debian.org>\n"
+"Language: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"Plural-Forms: nplurals=2; plural=(n != 1);\n"
+"X-Generator: Gtranslator 2.91.7\n"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-13.templates:1001
+msgid "Remove PostgreSQL directories when package is purged?"
+msgstr "¿Eliminar los directorios de PostgreSQL cuando se purga el paquete?"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-13.templates:1001
+msgid ""
+"Removing the PostgreSQL server package will leave existing database clusters "
+"intact, i.e. their configuration, data, and log directories will not be "
+"removed. On purging the package, the directories can optionally be removed."
+msgstr ""
+"La eliminación del paquete del servidor PostgreSQL dejará intactos los "
+"clusters de bases de datos existentes, es decir, no se eliminarán sus "
+"directorios de configuración, datos y registro. Al purgar el paquete, los "
+"directorios pueden ser eliminados opcionalmente."
diff --git a/debian/po/fr.po b/debian/po/fr.po
new file mode 100644
index 0000000..cc3c6ee
--- /dev/null
+++ b/debian/po/fr.po
@@ -0,0 +1,39 @@
+# Translation of postgresql debconf templates to French
+# Copyright (C) 2019 Debian French l10n team <debian-l10n-french@lists.debian.org>
+# This file is distributed under the same license as the postgresql-11 package.
+#
+# Jean-Pierre Giraud <jean-pierregiraud@neuf.fr>, 2019.
+msgid ""
+msgstr ""
+"Project-Id-Version: postgresql-11\n"
+"Report-Msgid-Bugs-To: postgresql-11@packages.debian.org\n"
+"POT-Creation-Date: 2019-01-09 15:22+0100\n"
+"PO-Revision-Date: 2019-01-14 14:25+0100\n"
+"Last-Translator: Jean-Pierre Giraud <jean-pierregiraud@neuf.fr>\n"
+"Language-Team: French <debian-l10n-french@lists.debian.org>\n"
+"Language: fr\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"Plural-Forms: nplurals=2; plural=(n > 1);\n"
+"X-Generator: Lokalize 2.0\n"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid "Remove PostgreSQL directories when package is purged?"
+msgstr ""
+"Faut-il supprimer les répertoires de PostgreSQL lors de la purge du paquet ?"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid ""
+"Removing the PostgreSQL server package will leave existing database clusters "
+"intact, i.e. their configuration, data, and log directories will not be "
+"removed. On purging the package, the directories can optionally be removed."
+msgstr ""
+"La suppression du paquet du serveur PostgreSQL laissera les grappes de bases "
+"de données existantes intactes, c'est-à-dire que leurs répertoires de "
+"configuration, de données et de journal ne seront pas supprimés. Lors de la "
+"purge du paquet, les répertoires peuvent être supprimés de façon optionnelle."
diff --git a/debian/po/it.po b/debian/po/it.po
new file mode 100644
index 0000000..d8020b9
--- /dev/null
+++ b/debian/po/it.po
@@ -0,0 +1,37 @@
+# postgresql-14 Italian translation.
+# Copyright (C) 2022 postgresql-14's copyright holder
+# This file is distributed under the same license as the postgresql-14 package.
+# Ceppo <ceppo@oziosi.org>, 2022.
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: postgresql-14\n"
+"Report-Msgid-Bugs-To: \n"
+"POT-Creation-Date: 2022-08-23 19:57+0000\n"
+"PO-Revision-Date: 2022-08-23 00:00+0000\n"
+"Last-Translator: Ceppo <ceppo@oziosi.org>\n"
+"Language-Team: Italian <debian-l10n-italian@lists.debian.org>\n"
+"Language: it\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-14.templates:1001
+msgid "Remove PostgreSQL directories when package is purged?"
+msgstr "Rimuovere le directory di PostgreSQL quando viene eseguito il purge "
+"del pacchetto?"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-14.templates:1001
+msgid ""
+"Removing the PostgreSQL server package will leave existing database clusters "
+"intact, i.e. their configuration, data, and log directories will not be "
+"removed. On purging the package, the directories can optionally be removed."
+msgstr ""
+"La rimozione del pacchetto server di PostgreSQL lascerà intatti i cluster "
+"di database esistenti, cioè i loro dati, configurazione e directory di log "
+"non saranno rimossi. Eseguendo il purge del pacchetto, le directory possono "
+"opzionalmente essere rimosse."
diff --git a/debian/po/nl.po b/debian/po/nl.po
new file mode 100644
index 0000000..11cda87
--- /dev/null
+++ b/debian/po/nl.po
@@ -0,0 +1,40 @@
+# Dutch translation of postgresql-11 debconf templates.
+# Copyright (C) YEAR THE PACKAGE'S COPYRIGHT HOLDER
+# This file is distributed under the same license as the postgresql-11 package.
+# FIRST AUTHOR <EMAIL@ADDRESS>, YEAR.
+# Frans Spiesschaert <Frans.Spiesschaert@yucom.be>, 2019.
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: postgresql-11_11.1-2\n"
+"Report-Msgid-Bugs-To: postgresql-11@packages.debian.org\n"
+"POT-Creation-Date: 2019-01-09 15:22+0100\n"
+"PO-Revision-Date: 2019-01-19 10:43+0100\n"
+"Last-Translator: Frans Spiesschaert <Frans.Spiesschaert@yucom.be>\n"
+"Language-Team: Debian Dutch l10n Team <debian-l10n-dutch@lists.debian.org>\n"
+"Language: nl\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"Plural-Forms: nplurals=2; plural=(n != 1);\n"
+"X-Generator: Gtranslator 2.91.7\n"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid "Remove PostgreSQL directories when package is purged?"
+msgstr ""
+"De PostgreSQL-mappen verwijderen wanneer het pakket gewist (purged) wordt?"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid ""
+"Removing the PostgreSQL server package will leave existing database clusters "
+"intact, i.e. their configuration, data, and log directories will not be "
+"removed. On purging the package, the directories can optionally be removed."
+msgstr ""
+"Bij het verwijderen van het serverpakket van PostgreSQL blijven de bestaande "
+"databaseclusters intact. Dit wil zeggen dat hun configuratie-, gegevens- en "
+"logboekmappen niet verwijderd worden. Bij het wissen (purge) van het pakket, "
+"kunnen de mappen naar keuze verwijderd worden."
diff --git a/debian/po/pt.po b/debian/po/pt.po
new file mode 100644
index 0000000..ee294d1
--- /dev/null
+++ b/debian/po/pt.po
@@ -0,0 +1,39 @@
+# Translation of postgresql-11's debconf messages to European Portuguese
+# Copyright (C) 2019 THE postgresql-11'S COPYRIGHT HOLDER
+# This file is distributed under the same license as the postgresql-11 package.
+#
+# Américo Monteiro <a_monteiro@gmx.com>, 2019.
+msgid ""
+msgstr ""
+"Project-Id-Version: postgresql-11 11.1-2\n"
+"Report-Msgid-Bugs-To: postgresql-11@packages.debian.org\n"
+"POT-Creation-Date: 2019-01-09 15:22+0100\n"
+"PO-Revision-Date: 2019-01-15 00:34+0000\n"
+"Last-Translator: Américo Monteiro <a_monteiro@gmx.com>\n"
+"Language-Team: Portuguese <>\n"
+"Language: pt\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"Plural-Forms: nplurals=2; plural=(n != 1);\n"
+"X-Generator: Lokalize 2.0\n"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid "Remove PostgreSQL directories when package is purged?"
+msgstr "Remover os directórios do PostgreSQL quando o pacote for purgado?"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid ""
+"Removing the PostgreSQL server package will leave existing database clusters "
+"intact, i.e. their configuration, data, and log directories will not be "
+"removed. On purging the package, the directories can optionally be removed."
+msgstr ""
+"Remover o pacote do servidor PostgreSQL irá deixar intactos agrupamentos de "
+"bases de dados existentes, isto é, a sua configuração, dados, e relatórios "
+"são serão removidos. Ao purgar o pacote, estes directórios podem "
+"opcionalmente ser removidos."
+
diff --git a/debian/po/pt_BR.po b/debian/po/pt_BR.po
new file mode 100644
index 0000000..5e746cf
--- /dev/null
+++ b/debian/po/pt_BR.po
@@ -0,0 +1,37 @@
+# Debconf translations for postgresql-11.
+# Copyright (C) 2019 THE postgresql-11'S COPYRIGHT HOLDER
+# This file is distributed under the same license as the postgresql-11 package.
+# Adriano Rafael Gomes <adrianorg@debian.org>, 2019.
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: postgresql-11\n"
+"Report-Msgid-Bugs-To: postgresql-11@packages.debian.org\n"
+"POT-Creation-Date: 2019-01-09 15:22+0100\n"
+"PO-Revision-Date: 2019-01-19 18:06-0200\n"
+"Last-Translator: Adriano Rafael Gomes <adrianorg@debian.org>\n"
+"Language-Team: Brazilian Portuguese <debian-l10n-portuguese@lists.debian."
+"org>\n"
+"Language: pt_BR\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid "Remove PostgreSQL directories when package is purged?"
+msgstr "Remover diretórios do PostgreSQL ao expurgar o pacote?"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid ""
+"Removing the PostgreSQL server package will leave existing database clusters "
+"intact, i.e. their configuration, data, and log directories will not be "
+"removed. On purging the package, the directories can optionally be removed."
+msgstr ""
+"Remover o pacote do servidor PostgreSQL deixará os \"clusters\" de bancos de "
+"dados existentes intactos, ou seja, suas configurações, dados e diretórios "
+"de log não serão removidos. Ao expurgar o pacote, os diretórios podem ser "
+"opcionalmente removidos."
diff --git a/debian/po/ru.po b/debian/po/ru.po
new file mode 100644
index 0000000..9828439
--- /dev/null
+++ b/debian/po/ru.po
@@ -0,0 +1,39 @@
+# Russian translation of debconf template for postgresql-11
+# Copyright (C) YEAR THE PACKAGE'S COPYRIGHT HOLDER
+# This file is distributed under the same license as the postgresql-11 package.
+# Lev Lamberov <dogsleg@debian.org>, 2019
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: postgresql-11\n"
+"Report-Msgid-Bugs-To: postgresql-11@packages.debian.org\n"
+"POT-Creation-Date: 2019-01-09 15:22+0100\n"
+"PO-Revision-Date: 2019-01-27 14:56+0500\n"
+"Language-Team: Debian L10N Russian <debian-l10n-russian@lists.debian.org>\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"X-Generator: Poedit 2.2.1\n"
+"Last-Translator: Lev Lamberov <dogsleg@debian.org>\n"
+"Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n%10>=2 && n"
+"%10<=4 && (n%100<12 || n%100>14) ? 1 : 2);\n"
+"Language: ru\n"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid "Remove PostgreSQL directories when package is purged?"
+msgstr "Удалить каталоги PostgreSQL при вычищении пакета?"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid ""
+"Removing the PostgreSQL server package will leave existing database clusters "
+"intact, i.e. their configuration, data, and log directories will not be "
+"removed. On purging the package, the directories can optionally be removed."
+msgstr ""
+"При удалении серверного пакета PostgreSQL существующие кластеры баз данных "
+"останутся нетронутыми. То есть, их каталоги с настройками, данными и "
+"журналами не будут удалены. При вычистке пакета эти каталоги могут быть при "
+"необходимости удалены."
diff --git a/debian/po/templates.pot b/debian/po/templates.pot
new file mode 100644
index 0000000..8cdb85c
--- /dev/null
+++ b/debian/po/templates.pot
@@ -0,0 +1,33 @@
+# SOME DESCRIPTIVE TITLE.
+# Copyright (C) YEAR THE PACKAGE'S COPYRIGHT HOLDER
+# This file is distributed under the same license as the postgresql-11 package.
+# FIRST AUTHOR <EMAIL@ADDRESS>, YEAR.
+#
+#, fuzzy
+msgid ""
+msgstr ""
+"Project-Id-Version: postgresql-11\n"
+"Report-Msgid-Bugs-To: postgresql-11@packages.debian.org\n"
+"POT-Creation-Date: 2019-01-09 15:22+0100\n"
+"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
+"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
+"Language-Team: LANGUAGE <LL@li.org>\n"
+"Language: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=CHARSET\n"
+"Content-Transfer-Encoding: 8bit\n"
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid "Remove PostgreSQL directories when package is purged?"
+msgstr ""
+
+#. Type: boolean
+#. Description
+#: ../postgresql-11.templates:1001
+msgid ""
+"Removing the PostgreSQL server package will leave existing database clusters "
+"intact, i.e. their configuration, data, and log directories will not be "
+"removed. On purging the package, the directories can optionally be removed."
+msgstr ""
diff --git a/debian/postgresql-14.NEWS b/debian/postgresql-14.NEWS
new file mode 100644
index 0000000..6332afb
--- /dev/null
+++ b/debian/postgresql-14.NEWS
@@ -0,0 +1,7 @@
+postgresql-14 (14.4-1) unstable; urgency=medium
+
+  If [RE]INDEX with the CONCURRENTLY option was used on any PostgreSQL 14
+  database, it is recommended to rebuild the indexes. See the changelog for
+  more details.
+
+ -- Christoph Berg <myon@debian.org>  Tue, 14 Jun 2022 09:49:41 +0200
diff --git a/debian/postgresql-14.install b/debian/postgresql-14.install
new file mode 100755
index 0000000..cbda440
--- /dev/null
+++ b/debian/postgresql-14.install
@@ -0,0 +1,59 @@
+#!/usr/bin/dh-exec
+
+usr/lib/postgresql/*/bin/initdb
+usr/lib/postgresql/*/bin/oid2name
+usr/lib/postgresql/*/bin/pg_archivecleanup
+usr/lib/postgresql/*/bin/pgbench
+usr/lib/postgresql/*/bin/pg_checksums
+usr/lib/postgresql/*/bin/pg_controldata
+usr/lib/postgresql/*/bin/pg_ctl
+usr/lib/postgresql/*/bin/pg_resetwal
+usr/lib/postgresql/*/bin/pg_rewind
+usr/lib/postgresql/*/bin/pg_test_fsync
+usr/lib/postgresql/*/bin/pg_test_timing
+usr/lib/postgresql/*/bin/pg_upgrade
+usr/lib/postgresql/*/bin/pg_waldump
+usr/lib/postgresql/*/bin/postgres
+usr/lib/postgresql/*/bin/postmaster
+usr/lib/postgresql/*/bin/vacuumlo
+[!alpha !hppa !hurd-i386 !ia64 !kfreebsd-amd64 !kfreebsd-i386 !m68k !powerpc !riscv64 !s390x !sh4 !sparc64 !x32] usr/lib/postgresql/*/lib/bitcode
+[!alpha !hppa !hurd-i386 !ia64 !kfreebsd-amd64 !kfreebsd-i386 !m68k !powerpc !riscv64 !s390x !sh4 !sparc64 !x32] usr/lib/postgresql/*/lib/llvmjit_types.bc
+usr/lib/postgresql/*/lib/*.so
+usr/share/locale/*/LC_MESSAGES/initdb-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_archivecleanup-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_checksums-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_controldata-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_ctl-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_resetwal-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_rewind-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_test_fsync-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_test_timing-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_upgrade-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_waldump-*.mo
+usr/share/locale/*/LC_MESSAGES/postgres-*.mo
+usr/share/locale/*/LC_MESSAGES/plpgsql-*.mo
+[linux-any] usr/share/postgresql/*/contrib/sepgsql.sql
+usr/share/postgresql/*/errcodes.txt
+usr/share/postgresql/*/extension/*
+usr/share/postgresql/*/man/man1/initdb.1*
+usr/share/postgresql/*/man/man1/oid2name.1*
+usr/share/postgresql/*/man/man1/pg_archivecleanup.1*
+usr/share/postgresql/*/man/man1/pgbench.1*
+usr/share/postgresql/*/man/man1/pg_checksums.1*
+usr/share/postgresql/*/man/man1/pg_controldata.1*
+usr/share/postgresql/*/man/man1/pg_ctl.1*
+usr/share/postgresql/*/man/man1/pg_resetwal.1*
+usr/share/postgresql/*/man/man1/pg_rewind.1*
+usr/share/postgresql/*/man/man1/pg_test_fsync.1*
+usr/share/postgresql/*/man/man1/pg_test_timing.1*
+usr/share/postgresql/*/man/man1/pg_upgrade.1*
+usr/share/postgresql/*/man/man1/pg_waldump.1*
+usr/share/postgresql/*/man/man1/postgres.1*
+usr/share/postgresql/*/man/man1/postmaster.1*
+usr/share/postgresql/*/man/man1/vacuumlo.1*
+usr/share/postgresql/*/timezonesets/*
+usr/share/postgresql/*/tsearch_data
+usr/share/postgresql/*/*.sql
+usr/share/postgresql/*/*.conf.sample
+usr/share/postgresql/*/postgres.bki
+usr/share/postgresql/*/sql_features.txt
diff --git a/debian/postgresql-14.lintian-overrides b/debian/postgresql-14.lintian-overrides
new file mode 100644
index 0000000..db59083
--- /dev/null
+++ b/debian/postgresql-14.lintian-overrides
@@ -0,0 +1,20 @@
+# We test for /usr/bin/pg_dropcluster, but run it without path
+command-with-path-in-maintainer-script
+
+# The World's Most Advanced Open Source Relational Database
+description-synopsis-starts-with-article
+
+# We ship binaries and libs in subdirs of /usr/lib/postgresql
+executable-in-usr-lib
+repeated-path-segment lib *
+
+# These are PostgreSQL server plugins; some need no external libraries
+hardening-no-fortify-functions [usr/lib/postgresql/*/lib/*]
+library-not-linked-against-libc [usr/lib/postgresql/*/lib/*]
+shared-library-lacks-prerequisites [usr/lib/postgresql/*/lib/*]
+
+# We use debconf in postrm only
+no-debconf-config
+
+# We store the PostgreSQL catalog version in a custom control field
+unknown-field *Postgresql-Catversion
diff --git a/debian/postgresql-14.postinst b/debian/postgresql-14.postinst
new file mode 100644
index 0000000..be69843
--- /dev/null
+++ b/debian/postgresql-14.postinst
@@ -0,0 +1,13 @@
+#!/bin/sh
+
+set -e
+
+VERSION=${DPKG_MAINTSCRIPT_PACKAGE##*-}
+
+if [ "$1" = configure ]; then
+    . /usr/share/postgresql-common/maintscripts-functions
+
+    configure_version $VERSION "$2"
+fi
+
+#DEBHELPER#
diff --git a/debian/postgresql-14.postrm b/debian/postgresql-14.postrm
new file mode 100644
index 0000000..c9f8893
--- /dev/null
+++ b/debian/postgresql-14.postrm
@@ -0,0 +1,80 @@
+#!/bin/sh
+
+set -e
+
+VERSION=${DPKG_MAINTSCRIPT_PACKAGE##*-}
+
+clean_dir() {
+    if [ -d "$1" ] && [ ! -L "$1" ]; then
+        rmdir "$1" >/dev/null 2>/dev/null || true
+    fi
+}
+
+drop_cluster() {
+    # if we still have the postgresql-common package, use it to also shutdown
+    # server, etc.; otherwise just remove the directories
+    if [ -x /usr/bin/pg_dropcluster ]; then
+        pg_dropcluster --stop-server $VERSION "$1"
+    else
+        # remove data directory
+        PGDATALINK="/etc/postgresql/$VERSION/$1/pgdata"
+        if [ -e "$PGDATALINK" ]; then
+            rm -rf $(readlink -f "$PGDATALINK") "$PGDATALINK"
+        else
+            rm -rf "/var/lib/postgresql/$VERSION/$1/"
+        fi
+
+        # remove log file, including rotated ones
+        LOGLINK="/etc/postgresql/$VERSION/$1/log"
+        if [ -e "$LOGLINK" ]; then
+            LOG=$(readlink -f "$LOGLINK")
+            rm -f $LOG* "$LOGLINK"
+        else
+            rm -f /var/log/postgresql/postgresql-$VERSION-"$1".log*
+        fi
+
+        # remove conffiles
+        for f in pg_hba.conf pg_ident.conf postgresql.conf start.conf environment pg_ctl.conf; do
+            rm -f /etc/postgresql/$VERSION/"$1"/$f
+        done
+        # remove empty conf.d directories
+        for d in /etc/postgresql/$VERSION/"$1"/*/; do
+            clean_dir "$d"
+        done
+
+        clean_dir /etc/postgresql/$VERSION/"$1"
+    fi
+}
+
+purge_package () {
+    # ask the user if they want to remove clusters. If debconf is not
+    # available, just remove everything
+    if [ -e /usr/share/debconf/confmodule ]; then
+        db_set $DPKG_MAINTSCRIPT_PACKAGE/postrm_purge_data true
+        db_input high $DPKG_MAINTSCRIPT_PACKAGE/postrm_purge_data || :
+        db_go || :
+        db_get $DPKG_MAINTSCRIPT_PACKAGE/postrm_purge_data || :
+        [ "$RET" = "false" ] && return 0
+    fi
+
+    for c in /etc/postgresql/$VERSION/*; do
+        [ -e "$c/postgresql.conf" ] || continue
+        cluster=$(basename "$c")
+        echo "Dropping cluster $cluster..."
+        drop_cluster "$cluster"
+    done
+
+    clean_dir /etc/postgresql/$VERSION
+    clean_dir /var/lib/postgresql/$VERSION
+    clean_dir /var/log/postgresql/$VERSION
+}
+
+if [ "$1" = purge ] && [ -d "/etc/postgresql/$VERSION" ] && [ "$(ls /etc/postgresql/$VERSION)" ]; then
+    # can't load debconf from a function
+    if [ -e /usr/share/debconf/confmodule ]; then
+        . /usr/share/debconf/confmodule
+    fi
+    purge_package
+fi
+
+#DEBHELPER#
diff --git a/debian/postgresql-14.preinst b/debian/postgresql-14.preinst
new file mode 100644
index 0000000..a1bccbc
--- /dev/null
+++ b/debian/postgresql-14.preinst
@@ -0,0 +1,18 @@
+#!/bin/sh
+
+set -e
+
+MAJOR_VER="${DPKG_MAINTSCRIPT_PACKAGE#postgresql-}"
+CATVERSION="@CATVERSION@" # set by override_dh_installdeb
+
+case $1 in
+    install|upgrade)
+        if [ "$2" ]; then
+            . /usr/share/postgresql-common/maintscripts-functions
+            preinst_check_catversion "$MAJOR_VER" "$CATVERSION"
+        fi ;;
+esac
+
+#DEBHELPER#
+
+exit 0
diff --git a/debian/postgresql-14.prerm b/debian/postgresql-14.prerm
new file mode 100644
index 0000000..828c6fb
--- /dev/null
+++ b/debian/postgresql-14.prerm
@@ -0,0 +1,16 @@
+#!/bin/sh
+
+set -e
+
+VERSION=${DPKG_MAINTSCRIPT_PACKAGE##*-}
+
+#DEBHELPER#
+
+. /usr/share/postgresql-common/maintscripts-functions
+
+stop_version $VERSION
+
+if [ "$1" = remove ]; then
+    remove_version $VERSION
+fi
+
diff --git a/debian/postgresql-14.templates b/debian/postgresql-14.templates
new file mode 100644
index 0000000..d724a4b
--- /dev/null
+++ b/debian/postgresql-14.templates
@@ -0,0 +1,7 @@
+Template: postgresql-14/postrm_purge_data
+Type: boolean
+Default: true
+_Description: Remove PostgreSQL directories when package is purged?
+ Removing the PostgreSQL server package will leave existing database clusters
+ intact, i.e. their configuration, data, and log directories will not be
+ removed. On purging the package, the directories can optionally be removed.
diff --git a/debian/postgresql-client-14.install b/debian/postgresql-client-14.install
new file mode 100644
index 0000000..098585b
--- /dev/null
+++ b/debian/postgresql-client-14.install
@@ -0,0 +1,45 @@
+usr/lib/postgresql/*/bin/clusterdb
+usr/lib/postgresql/*/bin/createdb
+usr/lib/postgresql/*/bin/createuser
+usr/lib/postgresql/*/bin/dropdb
+usr/lib/postgresql/*/bin/dropuser
+usr/lib/postgresql/*/bin/pg_amcheck
+usr/lib/postgresql/*/bin/pg_basebackup
+usr/lib/postgresql/*/bin/pg_config
+usr/lib/postgresql/*/bin/pg_dump
+usr/lib/postgresql/*/bin/pg_dumpall
+usr/lib/postgresql/*/bin/pg_isready
+usr/lib/postgresql/*/bin/pg_receivewal
+usr/lib/postgresql/*/bin/pg_recvlogical
+usr/lib/postgresql/*/bin/pg_restore
+usr/lib/postgresql/*/bin/pg_verifybackup
+usr/lib/postgresql/*/bin/psql
+usr/lib/postgresql/*/bin/reindexdb
+usr/lib/postgresql/*/bin/vacuumdb
+usr/lib/postgresql/*/lib/pgxs/*
+usr/share/locale/*/LC_MESSAGES/pg_amcheck-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_basebackup-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_config-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_dump-*.mo
+usr/share/locale/*/LC_MESSAGES/pg_verifybackup-*.mo
+usr/share/locale/*/LC_MESSAGES/pgscripts-*.mo
+usr/share/locale/*/LC_MESSAGES/psql-*.mo
+usr/share/postgresql/*/man/man1/clusterdb.1*
+usr/share/postgresql/*/man/man1/createdb.1*
+usr/share/postgresql/*/man/man1/createuser.1*
+usr/share/postgresql/*/man/man1/dropdb.1*
+usr/share/postgresql/*/man/man1/dropuser.1*
+usr/share/postgresql/*/man/man1/pg_amcheck.1*
+usr/share/postgresql/*/man/man1/pg_basebackup.1*
+usr/share/postgresql/*/man/man1/pg_dump.1*
+usr/share/postgresql/*/man/man1/pg_dumpall.1*
+usr/share/postgresql/*/man/man1/pg_isready.1*
+usr/share/postgresql/*/man/man1/pg_receivewal.1*
+usr/share/postgresql/*/man/man1/pg_recvlogical.1*
+usr/share/postgresql/*/man/man1/pg_restore.1*
+usr/share/postgresql/*/man/man1/pg_verifybackup.1*
+usr/share/postgresql/*/man/man1/psql.1*
+usr/share/postgresql/*/man/man1/reindexdb.1*
+usr/share/postgresql/*/man/man1/vacuumdb.1*
+usr/share/postgresql/*/man/man7/
+usr/share/postgresql/*/psqlrc.sample
diff --git a/debian/postgresql-client-14.lintian-overrides b/debian/postgresql-client-14.lintian-overrides
new file mode 100644
index 0000000..a3cef5b
--- /dev/null
+++ b/debian/postgresql-client-14.lintian-overrides
@@ -0,0 +1,3 @@
+# We ship binaries and libs in subdirs of /usr/lib/postgresql
+executable-in-usr-lib
+repeated-path-segment lib *
diff --git a/debian/postgresql-client-14.postinst b/debian/postgresql-client-14.postinst
new file mode 100644
index 0000000..a5cf251
--- /dev/null
+++ b/debian/postgresql-client-14.postinst
@@ -0,0 +1,13 @@
+#!/bin/sh
+
+set -e
+
+VERSION=${DPKG_MAINTSCRIPT_PACKAGE##*-}
+
+. /usr/share/postgresql-common/maintscripts-functions
+
+if [ "$1" = configure ]; then
+    configure_client_version $VERSION "$2"
+fi
+
+#DEBHELPER#
diff --git a/debian/postgresql-client-14.prerm b/debian/postgresql-client-14.prerm
new file mode 100644
index 0000000..14c2188
--- /dev/null
+++ b/debian/postgresql-client-14.prerm
@@ -0,0 +1,12 @@
+#!/bin/sh
+
+set -e
+
+VERSION=${DPKG_MAINTSCRIPT_PACKAGE##*-}
+
+#DEBHELPER#
+
+if [ "$1" = remove ]; then
+    . /usr/share/postgresql-common/maintscripts-functions
+    remove_client_version $VERSION
+fi
diff --git a/debian/postgresql-doc-14.doc-base b/debian/postgresql-doc-14.doc-base
new file mode 100644
index 0000000..192924e
--- /dev/null
+++ b/debian/postgresql-doc-14.doc-base
@@ -0,0 +1,18 @@
+Document: postgresql-14
+Title: PostgreSQL 14 Documentation
+Author: The PostgreSQL Global Development Group
+Abstract: The documentation for the PostgreSQL database management system,
+ version 14. PostgreSQL is a powerful, open source object-relational database
+ system. It is fully ACID compliant, has full support for foreign keys, joins,
+ views, triggers, and stored procedures (in multiple languages). It includes
+ most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR,
+ DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large
+ objects, including pictures, sounds, or video. It has native programming
+ interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others,
+ and exceptional documentation.
+Section: Data Management
+
+Format: HTML
+Index: /usr/share/doc/postgresql-doc-14/html/index.html
+Files: /usr/share/doc/postgresql-doc-14/html/*
+
diff --git a/debian/postgresql-doc-14.install b/debian/postgresql-doc-14.install
new file mode 100644
index 0000000..a41ef19
--- /dev/null
+++ b/debian/postgresql-doc-14.install
@@ -0,0 +1,2 @@
+usr/share/doc/postgresql-doc-*
+usr/share/postgresql/*/man/man3/
diff --git a/debian/postgresql-doc-14.postinst b/debian/postgresql-doc-14.postinst
new file mode 100644
index 0000000..58b2fee
--- /dev/null
+++ b/debian/postgresql-doc-14.postinst
@@ -0,0 +1,29 @@
+#!/bin/sh
+
+set -e
+
+VERSION=${DPKG_MAINTSCRIPT_PACKAGE##*-}
+
+# arguments: version master package [package]
+__link_manpages() {
+    MANS=$(unset GREP_OPTIONS; dpkg -L $3 $4 $5 2>/dev/null|egrep '/man/.*\.[1-9](\.gz)?$' | grep -v "$2") || true
+    [ -n "$MANS" ] || return 0
+
+    SLAVES=$(for i in $MANS; do TARGET=$(echo $i | sed "s/postgresql\/$1\///"); echo -n " --slave $TARGET $(basename $i) $i"; done)
+
+    section=$(echo "$2" | sed -e 's/.*\.\(.*\)\..*/man\1/')
+    update-alternatives --install /usr/share/man/$section/$2 \
+        $2 /usr/share/postgresql/$1/man/$section/$2 \
+        $(echo "$1" | tr -cd 0-9) $SLAVES
+}
+
+if [ "$1" = configure ]; then
+    if [ -f /usr/share/postgresql-common/maintscripts-functions ]; then
+        . /usr/share/postgresql-common/maintscripts-functions
+        configure_doc_version $VERSION "$2"
+    else
+        __link_manpages $VERSION SPI_connect.3.gz "postgresql-doc-$VERSION"
+    fi
+fi
+
+#DEBHELPER#
diff --git a/debian/postgresql-doc-14.prerm b/debian/postgresql-doc-14.prerm
new file mode 100644
index 0000000..9b72239
--- /dev/null
+++ b/debian/postgresql-doc-14.prerm
@@ -0,0 +1,17 @@
+#!/bin/sh
+
+set -e
+
+VERSION=${DPKG_MAINTSCRIPT_PACKAGE##*-}
+
+if [ "$1" = remove ]; then
+    if [ -f /usr/share/postgresql-common/maintscripts-functions ]; then
+        . /usr/share/postgresql-common/maintscripts-functions
+        remove_doc_version $VERSION
+    else
+        update-alternatives --remove SPI_connect.3.gz \
+            /usr/share/postgresql/$VERSION/man/man3/SPI_connect.3.gz
+    fi
+fi
+
+#DEBHELPER#
diff --git a/debian/postgresql-plperl-14.install b/debian/postgresql-plperl-14.install
new file mode 100755
index 0000000..9a9c99c
--- /dev/null
+++ b/debian/postgresql-plperl-14.install
@@ -0,0 +1,6 @@
+#!/usr/bin/dh-exec
+
+usr/lib/postgresql/*/lib/*plperl*.so
+[!alpha !hppa !hurd-i386 !ia64 !kfreebsd-amd64 !kfreebsd-i386 !m68k !powerpc !riscv64 !s390x !sh4 !sparc64 !x32] usr/lib/postgresql/*/lib/bitcode/*plperl*
+usr/share/locale/*/*/plperl-*.mo
+usr/share/postgresql/*/extension/*plperl*
diff --git a/debian/postgresql-plperl-14.lintian-overrides b/debian/postgresql-plperl-14.lintian-overrides
new file mode 120000
index 0000000..6e36803
--- /dev/null
+++ b/debian/postgresql-plperl-14.lintian-overrides
@@ -0,0 +1 @@
+postgresql-14.lintian-overrides
\ No newline at end of file
diff --git a/debian/postgresql-plpython3-14.install b/debian/postgresql-plpython3-14.install
new file mode 100755
index 0000000..d079cdc
--- /dev/null
+++ b/debian/postgresql-plpython3-14.install
@@ -0,0 +1,6 @@
+#!/usr/bin/dh-exec
+
+usr/lib/postgresql/*/lib/*plpython3*.so
+[!alpha !hppa !hurd-i386 !ia64 !kfreebsd-amd64 !kfreebsd-i386 !m68k !powerpc !riscv64 !s390x !sh4 !sparc64 !x32] usr/lib/postgresql/*/lib/bitcode/*plpython3*
+usr/share/locale/*/*/plpython-*.mo
+usr/share/postgresql/*/extension/*plpython3*
diff --git a/debian/postgresql-plpython3-14.lintian-overrides b/debian/postgresql-plpython3-14.lintian-overrides
new file mode 120000
index 0000000..6e36803
--- /dev/null
+++ b/debian/postgresql-plpython3-14.lintian-overrides
@@ -0,0 +1 @@
+postgresql-14.lintian-overrides
\ No newline at end of file
diff --git a/debian/postgresql-pltcl-14.install b/debian/postgresql-pltcl-14.install
new file mode 100644
index 0000000..f56fc0f
--- /dev/null
+++ b/debian/postgresql-pltcl-14.install
@@ -0,0 +1,3 @@
+usr/lib/postgresql/*/lib/pltcl.so
+usr/share/locale/*/*/pltcl-*.mo
+usr/share/postgresql/*/extension/pltcl*
diff --git a/debian/postgresql-pltcl-14.lintian-overrides b/debian/postgresql-pltcl-14.lintian-overrides
new file mode 120000
index 0000000..6e36803
--- /dev/null
+++ b/debian/postgresql-pltcl-14.lintian-overrides
@@ -0,0 +1 @@
+postgresql-14.lintian-overrides
\ No newline at end of file
diff --git a/debian/postgresql-server-dev-14.install b/debian/postgresql-server-dev-14.install
new file mode 100644
index 0000000..4c84b49
--- /dev/null
+++ b/debian/postgresql-server-dev-14.install
@@ -0,0 +1,2 @@
+usr/include/postgresql/*/server
+usr/lib/postgresql/*/lib/libpg*.a
diff --git a/debian/postgresql-server-dev-14.lintian-overrides b/debian/postgresql-server-dev-14.lintian-overrides
new file mode 120000
index 0000000..6e36803
--- /dev/null
+++ b/debian/postgresql-server-dev-14.lintian-overrides
@@ -0,0 +1 @@
+postgresql-14.lintian-overrides
\ No newline at end of file
diff --git a/debian/rules b/debian/rules
new file mode 100755
index 0000000..d2c3223
--- /dev/null
+++ b/debian/rules
@@ -0,0 +1,6 @@
+#!/usr/bin/make -f
+
+MAJOR_VER := 14
+EXCLUDE_PACKAGES := -N libpq-dev -N libpq5 -N libecpg6 -N libecpg-dev -N libecpg-compat3 -N libpgtypes3
+
+include /usr/share/postgresql-common/server/postgresql.mk
diff --git a/debian/source/format b/debian/source/format
new file mode 100644
index 0000000..163aaf8
--- /dev/null
+++ b/debian/source/format
@@ -0,0 +1 @@
+3.0 (quilt)
diff --git a/debian/source/lintian-overrides b/debian/source/lintian-overrides
new file mode 100644
index 0000000..a244735
--- /dev/null
+++ b/debian/source/lintian-overrides
@@ -0,0 +1,4 @@
+# pregenerated docs contain some tables rendered on a single line
+source: source-is-missing [doc/src/sgml/html/*]
+# same for these, plus including some regression output files
+source: very-long-line-length-in-source-file *
diff --git a/debian/tests/Makefile.regress b/debian/tests/Makefile.regress
new file mode 100644
index 0000000..f01a80a
--- /dev/null
+++ b/debian/tests/Makefile.regress
@@ -0,0 +1,5 @@
+MODULE_big = regress
+OBJS = regress.o
+PG_CONFIG = pg_config
+PGXS = $(shell $(PG_CONFIG) --pgxs)
+include $(PGXS)
diff --git a/debian/tests/control b/debian/tests/control
new file mode 100644
index 0000000..c7406c2
--- /dev/null
+++ b/debian/tests/control
@@ -0,0 +1,20 @@
+Tests: run-testsuite
+Depends:
+ build-essential,
+ debhelper,
+ fakeroot,
+ hunspell-en-us,
+ iproute2,
+ locales-all,
+ logrotate,
+ netcat-openbsd,
+ perl,
+ procps,
+ @,
+Restrictions: needs-root
+
+Tests: installcheck
+Depends:
+ build-essential,
+ @,
+Restrictions: allow-stderr
diff --git a/debian/tests/installcheck b/debian/tests/installcheck
new file mode 100755
index 0000000..08e5055
--- /dev/null
+++ b/debian/tests/installcheck
@@ -0,0 +1,42 @@
+#!/bin/sh
+
+set -eux
+
+SOURCE=$(dpkg-parsechangelog -SSource)
+MAJOR=${SOURCE#*-}
+top_srcdir=$PWD
+
+cd src/test/regress
+
+# compile regress.so
+make -f $top_srcdir/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/$MAJOR/bin/pg_config with_llvm=no
+
+# tell regression files that regress.so is not installed
+sed -i -e "s:@libdir@/regress:$PWD/regress:" input/*.source output/*.source
+
+# when root, execute testsuite as user postgres since it insists on wiping the tablespace directory
+if [ $(id -u) = 0 ]; then
+  SU="su postgres"
+else
+  SU="sh"
+fi
+
+$SU <<EOF
+set -eux
+
+# create tablespace and results directories
+OUTPUT=\$(mktemp -d /tmp/regress.XXXXXX)
+trap "rm -rf \$OUTPUT" EXIT
+
+# run the regression tests
+if ! pg_virtualenv -v $MAJOR \
+  /usr/lib/postgresql/$MAJOR/lib/pgxs/src/test/regress/pg_regress \
+    --schedule=parallel_schedule \
+    --make-testtablespace-dir \
+    --outputdir=\$OUTPUT \
+    --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf
+  then
+    head -100 \$OUTPUT/regression.diffs
+    exit 1
+fi
+EOF
diff --git a/debian/tests/run-testsuite b/debian/tests/run-testsuite
new file mode 100755
index 0000000..30d5aac
--- /dev/null
+++ b/debian/tests/run-testsuite
@@ -0,0 +1,5 @@
+#!/bin/sh
+set -e
+
+cd /usr/share/postgresql-common
+./testsuite -v 14
diff --git a/debian/watch b/debian/watch
new file mode 100644
index 0000000..671e370
--- /dev/null
+++ b/debian/watch
@@ -0,0 +1,4 @@
+version=3
+opts=uversionmangle=s/alpha/~alpha/;s/beta/~beta/;s/rc/~rc/ \
+https://ftp.postgresql.org/pub/source/v(14.*)/postgresql-(14.*).tar.bz2
+