sqlite_fdw icon indicating copy to clipboard operation
sqlite_fdw copied to clipboard

.deb source code package construction support

Open mkgrgis opened this issue 10 months ago • 10 comments

PGDG apt support group propose me to try adding debian directory with content according official instruction to the repository. After some iterations we will can provide metadata for source code package, which will a base for a group of .deb packages, constructed on PGDG package factory for different processor architectures and PostgreSQL versions, with and without GIS support. Are pgspider team ready to review my PR about PGDG .deb support like @devrimgunduz support private rpm package construction process for the FDW? There is accepted by PGDG and Debian team example of metadata files for other PostgreSQL extension.

mkgrgis avatar Jan 29 '25 19:01 mkgrgis

@mkgrgis Thank you for your proposal. But I'm sorry, this feature is low priority for us and we don't have enough time and knowledge to review it.

t-kataym avatar Feb 06 '25 02:02 t-kataym

But I'm sorry, this feature is low priority for us and we don't have enough time and knowledge to review it.

@t-kataym , what if all metadata from PR will be confirmed by official PostgreSQL development group (PGDG) maintainers? Our repo will be only full automated C code source for automated binary packaging for Debian and Ubuntu. All processes (with except for metadata updates) will be executed on official salsa servers of PGDG. I am also have no time for deep study of deb packages compilation, but maintainers explains me we need only metadata updating and some consultations.

Here is a PGDG draft after discussing with PGDG members: https://salsa.debian.org/bradfordboyle/sqlite-fdw

mkgrgis avatar Feb 06 '25 04:02 mkgrgis

@t-kataym , PGDG need official e-mail of code maintainer for including to standard .deb metadata. What should I answered?

mkgrgis avatar Feb 26 '25 13:02 mkgrgis

I think there are 2 ways of thinking about e-mail. One is a mail address of source code maintainer as you said, another is .deb package maintainer. Which is suitable?

t-kataym avatar Feb 28 '25 07:02 t-kataym

I think there are 2 ways of thinking about e-mail. One is a mail address of source code maintainer as you said, another is .deb package maintainer. Which is suitable?

I think for changelog should be a mail address of source code maintainer, but for general metadata we need .deb package maintainer mail address.

mkgrgis avatar Feb 28 '25 07:02 mkgrgis

for general metadata we need .deb package maintainer mail address.

Do you need this now?

t-kataym avatar Feb 28 '25 08:02 t-kataym

Do you need this now?

I think, yes.

This is a fragment from a review letter of Bradford Boyle, PGDG package member:

  1. d/control
  • The Maintainer field should be set to the package maintainer's name and email address [7] [7]: https://www.debian.org/doc/debian-policy/ch-controlfields.html#maintainer

debian/control is a well-documented file of general metadata. Also see https://www.debian.org/doc/debian-policy/ch-binary.html#s-maintainer

mkgrgis avatar Feb 28 '25 08:02 mkgrgis

I think your address is suitable in this case because PGSpider team does not maintain this repository .

t-kataym avatar Feb 28 '25 08:02 t-kataym

I think your address is suitable in this case because PGSpider team does not maintain this repository .

No problems, @t-kataym ! After special PR https://salsa.debian.org/bradfordboyle/sqlite-fdw will be precise copy of this repository. First Bradford Boyle should confirm debian metadata draft.

mkgrgis avatar Feb 28 '25 08:02 mkgrgis

There is yet compiled provided .deb packages https://pigsty.io/ext/fdw/sqlite_fdw/

mkgrgis avatar May 14 '25 06:05 mkgrgis