public inbox for [email protected]  
help / color / mirror / Atom feed
Adding packages fro WAL-G and Odyssey
9+ messages / 4 participants
[nested] [flat]

* Adding packages fro WAL-G and Odyssey
@ 2021-02-19 06:26 Andrey Borodin <[email protected]>
  2021-02-19 21:38 ` Re: Adding packages fro WAL-G and Odyssey Christoph Berg <[email protected]>
  0 siblings, 1 reply; 9+ messages in thread

From: Andrey Borodin @ 2021-02-19 06:26 UTC (permalink / raw)
  To: pgsql-pkg-debian

Hi!

I'm maintaining backup tool WAL-G, connection pooler Odyssey and some other PG-related tools.
I want to make these tools available via PGDG apt repository.
Where should I start? I've read some wiki pages [0] but did not figure out what to do...

We already build deb packages for internal distribution, but I think process may be different in this case.

Also, I'd like to do the same for Yum repository, but I think I should start from Apt.

Thanks!

Best regards, Andrey Borodin.

[0] https://wiki.postgresql.org/wiki/Apt




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Adding packages fro WAL-G and Odyssey
  2021-02-19 06:26 Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
@ 2021-02-19 21:38 ` Christoph Berg <[email protected]>
  2021-02-20 09:40   ` Re: Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
  0 siblings, 1 reply; 9+ messages in thread

From: Christoph Berg @ 2021-02-19 21:38 UTC (permalink / raw)
  To: Andrey Borodin <[email protected]>; +Cc: pgsql-pkg-debian

Re: Andrey Borodin
> Hi!
> 
> I'm maintaining backup tool WAL-G, connection pooler Odyssey and some other PG-related tools.
> I want to make these tools available via PGDG apt repository.
> Where should I start? I've read some wiki pages [0] but did not figure out what to do...
> 
> We already build deb packages for internal distribution, but I think process may be different in this case.

Hi Andrey,

we'd need a proper debian/ directory for these, either in the upstream
repo or in a separate one.

Does any of these link to PG as an extension or are they "normal"
programs that do not depend on the PG major version?

Christoph





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Adding packages fro WAL-G and Odyssey
  2021-02-19 06:26 Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
  2021-02-19 21:38 ` Re: Adding packages fro WAL-G and Odyssey Christoph Berg <[email protected]>
@ 2021-02-20 09:40   ` Andrey Borodin <[email protected]>
  2021-03-29 23:05     ` Re: Adding packages fro WAL-G and Odyssey Devrim Gündüz <[email protected]>
  2021-07-05 16:25     ` Re: Adding packages fro WAL-G and Odyssey Christoph Berg <[email protected]>
  0 siblings, 2 replies; 9+ messages in thread

From: Andrey Borodin @ 2021-02-20 09:40 UTC (permalink / raw)
  To: Christoph Berg <[email protected]>; +Cc: pgsql-pkg-debian

Thanks Christoph!

> 20 февр. 2021 г., в 02:38, Christoph Berg <[email protected]> написал(а):
> 
> 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.


Attachments:

  [application/octet-stream] wal-g-debian-fodler.sh (1.4K, 2-wal-g-debian-fodler.sh)
  download

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Adding packages fro WAL-G and Odyssey
  2021-02-19 06:26 Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
  2021-02-19 21:38 ` Re: Adding packages fro WAL-G and Odyssey Christoph Berg <[email protected]>
  2021-02-20 09:40   ` Re: Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
@ 2021-03-29 23:05     ` Devrim Gündüz <[email protected]>
  2021-03-31 12:32       ` Re: Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
  1 sibling, 1 reply; 9+ messages in thread

From: Devrim Gündüz @ 2021-03-29 23:05 UTC (permalink / raw)
  To: Andrey Borodin <[email protected]>; Christoph Berg <[email protected]>; +Cc: pgsql-pkg-debian


Hi Andrey,

On Sat, 2021-02-20 at 14:40 +0500, Andrey Borodin wrote:

> > 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.

I took if I can RPMify Odyssey. Unless I'm missing something, there is
no other way than running make local_run to run it as a daemon -- which
I don't think is doable for any kind of packaging system.

So, what I if install build/sources/odyssey binary under /usr/bin, cp
oddysey.conf to /etc/odyssey.conf and run it via systemctl? Is this
sufficient ?

Regards,

-- 
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


Attachments:

  [application/pgp-signature] signature.asc (833B, 2-signature.asc)
  download

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Adding packages fro WAL-G and Odyssey
  2021-02-19 06:26 Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
  2021-02-19 21:38 ` Re: Adding packages fro WAL-G and Odyssey Christoph Berg <[email protected]>
  2021-02-20 09:40   ` Re: Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
  2021-03-29 23:05     ` Re: Adding packages fro WAL-G and Odyssey Devrim Gündüz <[email protected]>
@ 2021-03-31 12:32       ` Andrey Borodin <[email protected]>
  0 siblings, 0 replies; 9+ messages in thread

From: Andrey Borodin @ 2021-03-31 12:32 UTC (permalink / raw)
  To: Devrim Gündüz <[email protected]>; +Cc: Christoph Berg <[email protected]>; pgsql-pkg-debian

Devrim, thank you for looking into this!

> 30 марта 2021 г., в 02:05, Devrim Gündüz <[email protected]> написал(а):
> On Sat, 2021-02-20 at 14:40 +0500, Andrey Borodin wrote:
> 
>>> 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.
> 
> I took if I can RPMify Odyssey. Unless I'm missing something, there is
> no other way than running make local_run to run it as a daemon -- which
> I don't think is doable for any kind of packaging system.
> 
> So, what I if install build/sources/odyssey binary under /usr/bin, cp
> oddysey.conf to /etc/odyssey.conf and run it via systemctl? Is this
> sufficient ?


I think this should work. There is a setting "daemonize", I think it must be on to start properly in this setup.

Thank you!

Best regards, Andrey Borodin.




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Adding packages fro WAL-G and Odyssey
  2021-02-19 06:26 Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
  2021-02-19 21:38 ` Re: Adding packages fro WAL-G and Odyssey Christoph Berg <[email protected]>
  2021-02-20 09:40   ` Re: Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
@ 2021-07-05 16:25     ` Christoph Berg <[email protected]>
  2021-12-06 07:09       ` Re: Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
  1 sibling, 1 reply; 9+ messages in thread

From: Christoph Berg @ 2021-07-05 16:25 UTC (permalink / raw)
  To: Andrey Borodin <[email protected]>; +Cc: pgsql-pkg-debian

Re: Andrey Borodin
> > 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

Hi,

that directory would need to be /debian, not somewhere deeper in the
tree. (Interestingly, you already have a /debian, just with less
files.)

> 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.

FPA usually doesn't produce "proper" packages with a curated
debian/changelog (no throwing away of old entries, and sensible log
messages) and the other bits.

debian/rules shouldn't try to build a -dbg package these days

debian/control shouldn't depend on postgresql-server-dev-13 but on
postgresql-server-dev-all if you really need server headers instead of
just the client ones.

The Description needs more content

Standards-Version is outdated

Consider using debhelper-compat (= 13) instead of debian/compat 9

Consider providing a systemd .service file along the init script


Christoph





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Adding packages fro WAL-G and Odyssey
  2021-02-19 06:26 Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
  2021-02-19 21:38 ` Re: Adding packages fro WAL-G and Odyssey Christoph Berg <[email protected]>
  2021-02-20 09:40   ` Re: Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
  2021-07-05 16:25     ` Re: Adding packages fro WAL-G and Odyssey Christoph Berg <[email protected]>
@ 2021-12-06 07:09       ` Andrey Borodin <[email protected]>
  0 siblings, 0 replies; 9+ messages in thread

From: Andrey Borodin @ 2021-12-06 07:09 UTC (permalink / raw)
  To: Christoph Berg <[email protected]>; +Cc: pgsql-pkg-debian



> 5 июля 2021 г., в 21:25, Christoph Berg <[email protected]> написал(а):
> 
> Re: Andrey Borodin
>>> 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
> 
> Hi,
> 
> that directory would need to be /debian, not somewhere deeper in the
> tree. (Interestingly, you already have a /debian, just with less
> files.)
> 
>> 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.
> 
> FPA usually doesn't produce "proper" packages with a curated
> debian/changelog (no throwing away of old entries, and sensible log
> messages) and the other bits.
> 
> debian/rules shouldn't try to build a -dbg package these days
> 
> debian/control shouldn't depend on postgresql-server-dev-13 but on
> postgresql-server-dev-all if you really need server headers instead of
> just the client ones.
> 
> The Description needs more content
> 
> Standards-Version is outdated
> 
> Consider using debhelper-compat (= 13) instead of debian/compat 9
> 
> Consider providing a systemd .service file along the init script

Thanks, Christoph!
We have updated /debian stuff in Odyssey. Can you please take a look again?
https://github.com/yandex/odyssey/pull/372/files

Best regards, Andrey Borodin.





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Adding packages fro WAL-G and Odyssey
@ 2025-12-14 05:06 Roman Khapov <[email protected]>
  2025-12-14 05:11 ` Re: Adding packages fro WAL-G and Odyssey Roman Khapov <[email protected]>
  0 siblings, 1 reply; 9+ messages in thread

From: Roman Khapov @ 2025-12-14 05:06 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]; [email protected]


> Thanks, Christoph!
> We have updated /debian stuff in Odyssey. Can you please take a look again?
> https://github.com/yandex/odyssey/pull/372/files
> 
> Best regards, Andrey Borodin.

Hi everyone! I want to revive this conversation

Im currently working on new versions of Odyssey [0], and we have debian [1]
(and partly rpm) packaging support.
What is needed to be done, for that package can be added to PGDG apt repository?

Thanks!

[0] https://github.com/yandex/odyssey
[1] https://github.com/yandex/odyssey/tree/master/debian

--
Best regards,
Roman Khapov




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Adding packages fro WAL-G and Odyssey
  2025-12-14 05:06 Re: Adding packages fro WAL-G and Odyssey Roman Khapov <[email protected]>
@ 2025-12-14 05:11 ` Roman Khapov <[email protected]>
  0 siblings, 0 replies; 9+ messages in thread

From: Roman Khapov @ 2025-12-14 05:11 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]; [email protected]

Oh, seems like my mail app added ‘Re’ to subject and this is now a new thread..

The original thread was in [0]

[0] https://www.postgresql.org/message-id/flat/5FDAF3A4-4C0D-47F5-821F-20CFD578B3C6%40yandex-team.ru

> On 14 Dec 2025, at 10:06, Roman Khapov <[email protected]> wrote:
> 
> 
>> Thanks, Christoph!
>> We have updated /debian stuff in Odyssey. Can you please take a look again?
>> https://github.com/yandex/odyssey/pull/372/files
>> 
>> Best regards, Andrey Borodin.
> 
> Hi everyone! I want to revive this conversation
> 
> Im currently working on new versions of Odyssey [0], and we have debian [1]
> (and partly rpm) packaging support.
> What is needed to be done, for that package can be added to PGDG apt repository?
> 
> Thanks!
> 
> [0] https://github.com/yandex/odyssey
> [1] https://github.com/yandex/odyssey/tree/master/debian
> 
> --
> Best regards,
> Roman Khapov
> 







^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2025-12-14 05:11 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-02-19 06:26 Adding packages fro WAL-G and Odyssey Andrey Borodin <[email protected]>
2021-02-19 21:38 ` Christoph Berg <[email protected]>
2021-02-20 09:40   ` Andrey Borodin <[email protected]>
2021-03-29 23:05     ` Devrim Gündüz <[email protected]>
2021-03-31 12:32       ` Andrey Borodin <[email protected]>
2021-07-05 16:25     ` Christoph Berg <[email protected]>
2021-12-06 07:09       ` Andrey Borodin <[email protected]>
2025-12-14 05:06 Re: Adding packages fro WAL-G and Odyssey Roman Khapov <[email protected]>
2025-12-14 05:11 ` Roman Khapov <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox