Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lDOlC-0007yz-W3 for pgsql-pkg-debian@arkaria.postgresql.org; Sat, 20 Feb 2021 09:41:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lDOkf-0007CH-SY for pgsql-pkg-debian@arkaria.postgresql.org; Sat, 20 Feb 2021 09:40:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lDOkf-0007C9-K2 for pgsql-pkg-debian@lists.postgresql.org; Sat, 20 Feb 2021 09:40:37 +0000 Received: from forwardcorp1o.mail.yandex.net ([95.108.205.193]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lDOkX-00038a-LZ for pgsql-pkg-debian@postgresql.org; Sat, 20 Feb 2021 09:40:36 +0000 Received: from sas1-ec30c78b6c5b.qloud-c.yandex.net (sas1-ec30c78b6c5b.qloud-c.yandex.net [IPv6:2a02:6b8:c14:2704:0:640:ec30:c78b]) by forwardcorp1o.mail.yandex.net (Yandex) with ESMTP id 262382E1590; Sat, 20 Feb 2021 12:40:26 +0300 (MSK) Received: from sas1-c2bc061771d1.qloud-c.yandex.net (sas1-c2bc061771d1.qloud-c.yandex.net [2a02:6b8:c08:8c0e:0:640:c2bc:617]) by sas1-ec30c78b6c5b.qloud-c.yandex.net (mxbackcorp/Yandex) with ESMTP id o6lQqlx6ng-ePxuwFVM; Sat, 20 Feb 2021 12:40:26 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex-team.ru; s=default; t=1613814026; bh=o2PSYnO5bfPzyqiZlGEyXbYtsLHF2mNWYZjJn4XIljM=; h=To:References:Date:Subject:Cc:Message-Id:From:In-Reply-To; b=r5aiKhvcHnQFVA0LPAT/YaVK9gA3Q0JLKvoBwuGJEMltPJZgcq0B7jyu+ZsiFeABw 9ZOhWI/ABAUc6NNdd/5paG3HNBspx5YW5/vDOP2e28x2ckY5jFkQ2VtCrWQZ232TZu 0n/dHJx390IUwty9/SkmPDAEdTzyFtIx1TiQPtEE= Authentication-Results: sas1-ec30c78b6c5b.qloud-c.yandex.net; dkim=pass header.i=@yandex-team.ru Received: from dynamic-ekb.dhcp.yndx.net (dynamic-ekb.dhcp.yndx.net [2a02:6b8:0:2807:8054:9d08:b490:9b8b]) by sas1-c2bc061771d1.qloud-c.yandex.net (smtpcorp/Yandex) with ESMTPSA id rCflgSpu4r-ePoqHBm5; Sat, 20 Feb 2021 12:40:25 +0300 (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client certificate not present) From: Andrey Borodin Message-Id: <54DCFC65-56DE-43AE-8219-B9D19B5AA311@yandex-team.ru> Content-Type: multipart/mixed; boundary="Apple-Mail=_B77C3890-4C04-40D7-89C4-BF113F25E4F7" Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.4\)) Subject: Re: Adding packages fro WAL-G and Odyssey Date: Sat, 20 Feb 2021 14:40:24 +0500 In-Reply-To: Cc: pgsql-pkg-debian@postgresql.org To: Christoph Berg References: <5FDAF3A4-4C0D-47F5-821F-20CFD578B3C6@yandex-team.ru> X-Mailer: Apple Mail (2.3608.120.23.2.4) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_B77C3890-4C04-40D7-89C4-BF113F25E4F7 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Thanks Christoph! > 20 =D1=84=D0=B5=D0=B2=D1=80. 2021 =D0=B3., =D0=B2 02:38, Christoph = Berg =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):= >=20 > we'd need a proper debian/ directory for these, either in the upstream > repo or in a separate one. Odyssey had debian/ dir = https://github.com/yandex/odyssey/tree/master/scripts/debian WAL-G is simply one Go binary. = https://github.com/wal-g/wal-g/tree/master/cmd/pg Though it's a separate Go binary for each DB: PG, MySQL, MSSQL, MongoDB = etc. But I think it's better to start from PG anyway. We used to build this binary and create almost empty debian/ dir with a = script (FPA). We can commit this dir it it's better to have it in source = tree. > Does any of these link to PG as an extension or are they "normal" > programs that do not depend on the PG major version? They are normal. Kind of. I'm planning to release Odyssey 1.2 soon, so I'd start from Odyssey, I = think. Probably, we would be happy to share some extensions too. But I think = they have somewhat smaller priority for me. https://github.com/munakoiso/logerrors https://github.com/x4m/pg_tm_aux https://github.com/dev1ant/repl_mon https://github.com/dsarafan/pg_dirty_hands Thanks! Best regards, Andrey Borodin. --Apple-Mail=_B77C3890-4C04-40D7-89C4-BF113F25E4F7 Content-Disposition: attachment; filename=wal-g-debian-fodler.sh Content-Type: application/octet-stream; x-unix-mode=0644; name="wal-g-debian-fodler.sh" Content-Transfer-Encoding: 7bit timeout 600 go get -u github.com/golang/dep/cmd/dep cd src/github.com/wal-g/wal-g timeout 600 make deps timeout 600 make pg_build mkdir main/pg/debian cat > main/pg/debian/changelog< $(date +'%a, %d %b %Y %H:%M:%S %z') EOH cat > main/pg/debian/control<<'EOH' Source: wal-g Section: net Priority: optional Maintainer: Andrey Borodin Build-Depends: debhelper (>= 9.0.0) Standards-Version: 3.9.5 Vcs-Git: git://github.com/wal-g/wal-g.git Vcs-Browser: https://github.com/wal-g/wal-g Package: wal-g Architecture: any Depends: adduser, ${shlibs:Depends}, ${misc:Depends} Description: Continuous archiving for Postgres with S3 support Full documentation: https://github.com/wal-g/wal-g EOH cat > main/pg/debian/rules<<'EOH' #!/usr/bin/make -f # -*- makefile -*- # Uncomment this to turn on verbose mode. #export DH_VERBOSE=1 export DH_OPTIONS export DH_GOPKG := github.com/wal-g/wal-g override_dh_builddeb: dh_builddeb -- -z9 -Zxz -Snone override_dh_auto_install: dh_auto_install %: dh $@ --parallel EOH cat > main/pg/debian/compat< main/pg/Makefile<<'EOH' prefix = /usr all: install: install -D wal-g $(DESTDIR)$(prefix)/bin/wal-g clean: distclean: clean uninstall: -rm -rf $(DESTDIR)$(prefix)/bin/wal-g .PHONY: all install clean distclean uninstall EOH --Apple-Mail=_B77C3890-4C04-40D7-89C4-BF113F25E4F7--