# community-identities.yaml — manual identity coalescing
#
# Phase 1.3 of the community methodology rollout. This file declares
# operator-curated person/identity merges that the relational
# community.persons/person_aliases tables cannot infer reliably (e.g.
# accent-folded variants, name-order swaps for JP authors, multiple
# email domains for the same human across employer changes).
#
# The companion script scripts/0038-yaml-to-mentat.sh parses this file
# and emits mentat upserts. Re-running is safe because every emission is
# keyed on a :db.unique/identity attribute.
#
# See data/community-identities-README.md for full format docs and the
# "I made a mistake" recovery procedure.
#
# Format per entry:
#
#   - canonical: "<display name to render on /community>"
#     emails:                # cardinality/many; first one is the
#       - <primary>@<host>   # :person/canonical-email key
#       - <other>@<host>
#     aliases:               # human-display variants of the name
#       - "ASCII variant"    # (will be created as :identity/raw-name
#       - "Accented Variant" # entries with :identity/source = :manual)
#     notes: "free text"     # optional
#     tier: "Core Team"      # optional; one of "Core Team",
#                            # "Major Contributors", "Significant
#                            # Contributors". When set, the
#                            # :person/tier datom is written; otherwise
#                            # the daily etl-pgorg-tiers.sh scrape is
#                            # authoritative.
#     employer: "EDB"        # optional; sets :person/employer override
#
# Phase 1 seed — kept intentionally short so the operator can verify
# each block by hand. The 246 community.persons.needs_review=TRUE rows
# are NOT seeded here; they remain a follow-up curation task.

# ---- Core Team (9 people, verified against postgresql.org/community/contributors/) ----

- canonical: "Tom Lane"
  emails:
    - tgl@sss.pgh.pa.us
  aliases:
    - "Tom Lane"
  notes: "PostgreSQL Core Team; Crunchy Data"
  tier: "Core Team"
  employer: "Crunchy Data"

- canonical: "Peter Eisentraut"
  emails:
    - peter@eisentraut.org
    - peter_e@gmx.net
    - peter.eisentraut@2ndquadrant.com
    - peter.eisentraut@enterprisedb.com
    - peter_e@gmx.de
  aliases:
    - "Peter Eisentraut"
  tier: "Core Team"
  employer: "EDB"

- canonical: "Andres Freund"
  emails:
    - andres@anarazel.de
    - andres@freund.de
    - andres@andres@anarazel.de
  aliases:
    - "Andres Freund"
  tier: "Core Team"
  employer: "Microsoft"

- canonical: "Bruce Momjian"
  emails:
    - bruce@momjian.us
  aliases:
    - "Bruce Momjian"
  tier: "Core Team"
  employer: "EDB"

- canonical: "Robert Haas"
  emails:
    - rhaas@postgresql.org
    - robertmhaas@gmail.com
  aliases:
    - "Robert Haas"
  tier: "Major Contributors"
  employer: "Databricks"

- canonical: "Magnus Hagander"
  emails:
    - magnus@hagander.net
  aliases:
    - "Magnus Hagander"
  tier: "Core Team"
  employer: "Redpill Linpro"

- canonical: "Joe Conway"
  emails:
    - mail@joeconway.com
  aliases:
    - "Joe Conway"
  tier: "Core Team"
  employer: "Amazon/AWS"
  notes: "Leads the AWS PostgreSQL Contributor Team. Left Crunchy Data ~2021/2022; employer corrected 2026-10-02 (was stale 'Crunchy Data')."

- canonical: "Andrew Dunstan"
  emails:
    - andrew@dunslane.net
    - andrew.dunstan@enterprisedb.com
    - andrew@pgexperts.com
    - andrew.dunstan@2ndquadrant.com
  aliases:
    - "Andrew Dunstan"
  tier: "Core Team"
  employer: "EDB"

- canonical: "Stephen Frost"
  emails:
    - sfrost@snowman.net
  aliases:
    - "Stephen Frost"
  tier: "Core Team"
  employer: "Crunchy Data"

- canonical: "Jonathan Katz"
  emails:
    - jkatz@postgresql.org
    - jonathan.katz@aws.com
    - jonathan@postgresql.org
    - jonathan.katz@excoventures.com
  aliases:
    - "Jonathan S. Katz"
    - "Jonathan Katz"
  tier: "Core Team"
  employer: "Databricks"
- canonical: "Nathan Bossart"
  emails:
    - bossartn@amazon.com
    - nathandbossart@gmail.com
    - nathan@postgresql.org
  aliases:
    - "Nathan Bossart"
    - "Bossart, Nathan"
  tier: "Major Contributors"
  employer: "Amazon/AWS"

# ---- Dual-encoding / name-order cases (explicit identity merges) ----

- canonical: "Álvaro Herrera"
  emails:
    - alvherre@alvh.no-ip.org
    - alvherre@2ndquadrant.com
    - alvherre@kurilemu.de
    - alvherre@enterprisedb.com
  aliases:
    - "Alvaro Herrera"
    - "Álvaro Herrera"
    - "Alvaro Herrera Munoz"
  notes: "ASCII vs accented form merge — collapses two community.persons rows into one"
  tier: "Major Contributors"
  employer: "EDB"

- canonical: "Masao Fujii"
  emails:
    - masao.fujii@gmail.com
    - masao.fujii@oss.nttdata.com
    - masao.fujii@nttdata.com
    - fujii@postgresql.org
  aliases:
    - "Fujii Masao"
    - "Masao Fujii"
    - "MASAO FUJII"
  notes: "JP family-name-first vs Western-order merge"
  tier: "Major Contributors"
  employer: "NTT"

- canonical: "Hou Zhijie"
  emails:
    - houzj.fnst@cn.fujitsu.com
    - houzj.fnst@fujitsu.com
  aliases:
    - "Hou Zhijie"
    - "houzj.fnst"
    - "Zhijie Hou"
  notes: "JP/CN family-name-first vs Western-order merge; multiple Fujitsu domains"
  tier: "Major Contributors"
  employer: "Fujitsu"

- canonical: "Heikki Linnakangas"
  emails:
    - hlinnaka@iki.fi
    - heikki.linnakangas@iki.fi
    - heikki.linnakangas@enterprisedb.com
    - hlinnakangas@vmware.com
  aliases:
    - "Heikki Linnakangas"
  tier: "Major Contributors"
  employer: "Neon"

- canonical: "Michael Paquier"
  emails:
    - michael@paquier.xyz
    - michael.paquier@gmail.com
    - michael@otacoo.com
  aliases:
    - "Michael Paquier"
    - "michael@paquier.xyz"
  tier: "Major Contributors"
  employer: "Amazon/AWS"

# ---- Operator + a few other folks who appear with multiple addresses
# in the public archives. Anyone is welcome to file a community-correction
# template issue if their entry is missing or wrong. ----

- canonical: "Greg Burd"
  emails:
    - greg@burd.me
    - gregburd@amazon.com
    - gregburd@gmail.com
    - greg.burd@gmail.com
    - gburd@amazon.com
    - wiki:gregburd@wiki.postgresql.org
  aliases:
    - "Greg Burd"
    - "Gregory Burd"
    - "Gregburd"
    - "Burd, Greg"
  notes: "Operator. Personal address greg@burd.me is canonical; AWS work address is gregburd@amazon.com. Wiki account uses the wiki: prefix from postgresql.org/wiki MediaWiki."
  employer: "Amazon/AWS"

- canonical: "Tristan Partin"
  emails:
    - tristan@partin.io
    - tristan@neon.tech
  employer: "Amazon/AWS"

- canonical: "Tatsuo Ishii"
  emails:
    - ishii@postgresql.org
    - ishii@sraoss.co.jp
    - ishii at sraoss.co.jp
    - noreply+tatsuo-ishii@github.com
- canonical: "Amit Kapila"
  emails:
    - amit.kapila16@gmail.com
    - akapila@postgresql.org

- canonical: "Daniel Gustafsson"
  emails:
    - daniel@yesql.se
    - dgustafsson@postgresql.org
    - daniel@hobbit.se
    - daniel@yesql.sea
- canonical: "Masahiko Sawada"
  emails:
    - sawada.mshk@gmail.com
    - msawada@postgresql.org
    - masahiko.sawada@2ndquadrant.com
    - masahiko.sawada@enterprisedb.com

- canonical: "Laurenz Albe"
  emails:
    - laurenz.albe@cybertec.at
    - laurenz@users.noreply.github.com
    - laurenz.albe@wien.gv.at
- canonical: "Andy Fan"
  emails:
    - zhihuifan1213@163.com
    - zhihui.fan1213@gmail.com

- canonical: "Simon Riggs"
  emails:
    - simon@2ndquadrant.com
    - simon.riggs@enterprisedb.com
    - simon@2ndqudrant.com

- canonical: "Peter Geoghegan"
  emails:
    - pg@bowt.ie
    - pg@heroku.com
    - peter.geoghegan86@gmail.com
  employer: "Amazon/AWS"

- canonical: "Christoph Berg"
  emails:
    - myon@debian.org
    - cb@df7cb.de
    - christoph.berg@credativ.de

- canonical: "Thomas Munro"
  emails:
    - thomas.munro@gmail.com
    - tmunro@postgresql.org
    - thomas.munro@enterprisedb.com
    - tmunro@gmail.com

- canonical: "Jeff Davis"
  emails:
    - pgsql@j-davis.com
    - jdavis@postgresql.org
    - jeff@j-davis.com

- canonical: "Peter Smith"
  emails:
    - smithpb2250@gmail.com
    - peter.b.smith@fujitsu.com

- canonical: "Kyotaro Horiguchi"
  emails:
    - horikyota.ntt@gmail.com
    - horikyoga.ntt@gmail.com
    - horikyotajntt@gmail.com
    - horiguchi.kyotaro@lab.ntt.co.jp
- canonical: "David Rowley"
  emails:
    - dgrowleyml@gmail.com
    - drowley@postgresql.org
    - david.rowley@2ndquadrant.com
    - dgrowley@gmail.com
    - drowleyml@gmail.com
    - <dgrowleyml@gmail.com

- canonical: "Takuma Hoshiai"
  emails:
    - takuma.hoshiai@gmail.com
    - hoshiai@sraoss.co.jp

- canonical: "Andrey Borodin"
  emails:
    - x4mmm@yandex-team.ru
    - amborodin86@gmail.com
    - amborodin@acm.org

- canonical: "Jelte Fennema-Nio"
  emails:
    - postgres@jeltef.nl
    - me@jeltef.nl
    - jelte.fennema@microsoft.com
    - github-tech@jeltef.nl

- canonical: "Justin Pryzby"
  emails:
    - pryzby@telsasoft.com
    - pryzbyj@telsasoft.com
    - justin@telsasoft.com

- canonical: "Jim Nasby"
  emails:
    - jim.nasby@bluetreble.com
    - jim.nasby@gmail.com
    - jnasby@upgrade.com

- canonical: "Chao Li"
  emails:
    - li.evan.chao@gmail.com
    - lic@highgo.com
    - 1356863904@qq.com

- canonical: "Alexander Korotkov"
  emails:
    - aekorotkov@gmail.com
    - akorotkov@postgresql.org
    - a.korotkov@postgrespro.ru

- canonical: "Petr Jelinek"
  emails:
    - petr@2ndquadrant.com
    - petr.jelinek@2ndquadrant.com
    - pjmodos@pjmodos.net
    - petr.jelinek@skype.net
    - petr.jelinek@enterprisedb.com
- canonical: "Richard Guo"
  emails:
    - guofenglinux@gmail.com
    - rguo@postgresql.org

- canonical: "Neil Conway"
  emails:
    - neilc@samurai.com
    - neil.conway@gmail.com

- canonical: "Dilip Kumar"
  emails:
    - dilipbalaut@gmail.com
    - dilip.kumar@enterprisedb.com

- canonical: "Amit Langote"
  emails:
    - amitlangote09@gmail.com
    - langote_amit_f8@lab.ntt.co.jp
    - amitlan@postgresql.org

- canonical: "Dave Cramer"
  emails:
    - davecramer@gmail.com
    - davec@fastcrypt.com
    - dave.cramer@credativ.ca
    - davec@daves-macbook-air.local
    - davecramer@postgres.rocks
  employer: "Amazon/AWS"
  notes: "Consolidated 2026-10-02: davecramer@postgres.rocks was a separate local-part-named person record; folded in. AWS (Joe Conway's team)."

- canonical: "John Naylor"
  emails:
    - johncnaylorls@gmail.com
    - john.naylor@postgresql.org
    - john.naylor@enterprisedb.com
    - jcnaylor@gmail.com
    - john.naylor@2ndquadrant.com

- canonical: "Craig Ringer"
  emails:
    - craig@2ndquadrant.com
    - ringerc@ringerc.id.au
    - craig.ringer@enterprisedb.com
    - craig.ringer@2ndquadrant.com

- canonical: "Hiroshi Inoue"
  emails:
    - inoue@tpf.co.jp
    - h-inoue@dream.email.ne.jp
    - inoue@tpf.co.p
    - hinoue205@gmail.com

- canonical: "Julien Rouhaud"
  emails:
    - rjuju123@gmail.com
    - julien.rouhaud@dalibo.com
    - julien.rouhaud@free.fr

- canonical: "Greg Sabino Mullane"
  emails:
    - greg@turnstep.com
    - htamfids@gmail.com

- canonical: "Kris Jurka"
  emails:
    - books@ejurka.com
    - jurka@ejurka.com

- canonical: "Sami Imseih"
  emails:
    - samimseih@gmail.com
    - simseih@amazon.com
    - sanmimseih@gmail.com
    - samimseih.pg@gmail.com
  employer: "Amazon/AWS"
  notes: "Consolidated 2026-10-01: samimseih.pg@gmail.com (the .pg list-posting variant) was a separate person record; folded into this canonical identity along with the simseih@amazon.com AWS address and the sanmimseih@gmail.com typo variant."

- canonical: "Aleksander Alekseev"
  emails:
    - aleksander@timescale.com
    - aleksander@tigerdata.com
    - a.alekseev@postgrespro.ru

- canonical: "Ashutosh Bapat"
  emails:
    - ashutosh.bapat.oss@gmail.com
    - ashutosh.bapat@enterprisedb.com
    - ashutosh.bapat@2ndquadrant.com

- canonical: "Jacob Champion"
  emails:
    - jacob.champion@enterprisedb.com
    - jchampion@timescale.com
    - jchampion@postgresql.org
    - pchampion@vmware.com

- canonical: "Tomas Vondra"
  emails:
    - tomas.vondra@enterprisedb.com
    - tomas@vondra.me
    - tomas.vondra@2ndquadrant.com
    - tomas.vondra@postgresql.org

- canonical: "Mark Dilger"
  emails:
    - mark.dilger@enterprisedb.com
    - hornschnorter@gmail.com

- canonical: "Bharath Rupireddy"
  emails:
    - bharath.rupireddyforpostgres@gmail.com
    - bharath.rupireddy@enterprisedb.com

- canonical: "David Steele"
  emails:
    - david@pgmasters.net
    - david@pgbackrest.org

- canonical: "Konstantin Knizhnik"
  emails:
    - knizhnik@garret.ru
    - k.knizhnik@postgrespro.ru

- canonical: "Atsushi Torikoshi"
  emails:
    - torikoshia@oss.nttdata.com
    - atorik@gmail.com

- canonical: "Alena Rybakina"
  emails:
    - a.rybakina@postgrespro.ru
    - lena.ribackina@yandex.ru

- canonical: "Guillaume Lelarge"
  emails:
    - guillaume@lelarge.info
    - guillaume.lelarge@dalibo.com
    - guillaume at lelarge.info

- canonical: "Matthias van de Meent"
  emails:
    - boekewurm+postgres@gmail.com
    - matthias.vandemeent@cofano.nl
    - noreply+mmeent@github.com
    - boekewurm@gmail.com

- canonical: "Georgios Kokolatos"
  emails:
    - gkokolatos@protonmail.com
    - gkokolatos@pm.me

- canonical: "Euler Taveira"
  emails:
    - euler@eulerto.com
    - euler@timbira.com.br
    - euler.taveira@enterprisedb.com
    - euler.taveira@2ndquadrant.com

- canonical: "Lev Kokotov"
  emails:
    - levkk@users.noreply.github.com
    - lev.kokotov@gmail.com

- canonical: "Etsuro Fujita"
  emails:
    - fujita.etsuro@lab.ntt.co.jp
    - etsuro.fujita@gmail.com
    - efujita@postgresql.org

- canonical: "Zsolt Parragi"
  emails:
    - zsolt.parragi@percona.com
    - zsolt.parragi@cybertec.at

- canonical: "Vik Fearing"
  emails:
    - vik@postgresfriends.org
    - vik.fearing@2ndquadrant.com

- canonical: "Amul Sul"
  emails:
    - sulamul@gmail.com
    - amul.sul@enterprisedb.com

- canonical: "Muhammad Usama"
  emails:
    - m.usama@gmail.com
    - m.usama@highgo.ca
    - muhammad.usama@percona.com
    - muhammad.usama@enterprisedb.com

- canonical: "iceback"
  emails:
    - robjsargent@gmail.com
    - noreply+iceback@github.com

- canonical: "Matheus Alcantara"
  emails:
    - matheusssilv97@gmail.com
    - mths.dev@pm.me

- canonical: "Rahila Syed"
  emails:
    - rahilasyed90@gmail.com
    - rahilasyed.90@gmail.com

- canonical: "sergiyvamz"
  emails:
    - 75754709+sergiyvamz@users.noreply.github.com
    - noreply+sergiyvamz@github.com
    - svvoshch@amazon.com

- canonical: "Hiroshi Saito"
  emails:
    - hiroshi@winpg.jp
    - z-saito@guitar.ocn.ne.jp

- canonical: "Michael Banck"
  emails:
    - michael.banck@credativ.de
    - mbanck@gmx.net
    - mbanck@debian.org

- canonical: "Jakub Wartak"
  emails:
    - jakub.wartak@enterprisedb.com
    - jakub.wartak@tomtom.com

- canonical: "Andrew Gierth"
  emails:
    - andrew@tao11.riddles.org.uk
    - rhodiumtoad@postgresql.org

- canonical: "Taiki Koshino"
  emails:
    - koshino@sraoss.co.jp
    - koshino@postgresql.org

- canonical: "Pavan Deolasee"
  emails:
    - pavan.deolasee@gmail.com
    - pavan.deolasee@2ndquadrant.com

- canonical: "Chapman Flack"
  emails:
    - chap@anastigmatix.net
    - jcflack@acm.org

- canonical: "Zhang Mingli"
  emails:
    - zmlpostgres@gmail.com
    - avamingli@gmail.com

- canonical: "Karl O. Pinc"
  emails:
    - kop@karlpinc.com
    - kop@meme.com

- canonical: "Shubham Khanna"
  emails:
    - khannashubham1197@gmail.com
    - shubham.khanna@fujitsu.com

- canonical: "Sehrope Sarkuni"
  emails:
    - sehrope@jackdb.com
    - sehrop@jackdb.com

- canonical: "Toshihiro Kitagawa"
  emails:
    - kitagawa at sraoss.co.jp
    - kitagawa@sraoss.co.jp

- canonical: "Ilia Evdokimov"
  emails:
    - ilya.evdokimov@tantorlabs.com
    - ilya.evdokimov@tantorlabs.ru

- canonical: "Ian Barwick"
  emails:
    - ian@2ndquadrant.com
    - ian.barwick@2ndquadrant.com

- canonical: "Surya Poondla"
  emails:
    - suryapoondla4@gmail.com
    - s_poondla@apple.com

- canonical: "Oleg Bartunov"
  emails:
    - obartunov@gmail.com
    - obartunov@postgrespro.ru

- canonical: "Alexander Pyhalov"
  emails:
    - a.pyhalov@postgrespro.ru
    - a.yhalov@postgrespro.ru

- canonical: "Masahiro Ikeda"
  emails:
    - ikedamsh@oss.nttdata.com
    - masahiro.ikeda@nttdata.com

- canonical: "Shinya Kato"
  emails:
    - shinya11.kato@gmail.com
    - shinya11.kato@oss.nttdata.com

- canonical: "Itagaki Takahiro"
  emails:
    - itagaki.takahiro@gmail.com
    - itagaki.takahiro@oss.ntt.co.jp

- canonical: "AlexElin"
  emails:
    - noreply+alexelin@github.com
    - alexey.elin@list.ru

- canonical: "Anton A. Melnikov"
  emails:
    - a.melnikov@postgrespro.ru
    - aamelnikov@inbox.ru

- canonical: "crystall-bitquill"
  emails:
    - 97126568+crystall-bitquill@users.noreply.github.com
    - crystall@bitquilltech.com

- canonical: "Nikolay Samokhvalov"
  emails:
    - samokhvalov@gmail.com
    - nik@postgres.ai
    - github2@samokhvalov.com

- canonical: "Vasuki M"
  emails:
    - vasukianand0119@gmail.com
    - vasukim1992002@gmail.com

- canonical: "Sergiyv"
  emails:
    - sergiyv@bitquilltech.com
    - 69876824+sergiyv-bitquill@users.noreply.github.com

- canonical: "Julien Tachoires"
  emails:
    - julmon@gmail.com
    - julien@tachoires.me

- canonical: "David Christensen"
  emails:
    - david.christensen@crunchydata.com
    - david+pg@pgguru.net
    - david@pgguru.net

- canonical: "Maciek Sakrejda"
  emails:
    - m.sakrejda@gmail.com
    - maciek@pganalyze.com
    - maciek@heroku.com

- canonical: "Mats Kindahl"
  emails:
    - mats@timescale.com
    - mats.kindahl@gmail.com

- canonical: "Ronan Dunklau"
  emails:
    - ronan.dunklau@aiven.io
    - ronan@dunklau.fr

- canonical: "Rafia Sabih"
  emails:
    - rafia.pghackers@gmail.com
    - rafia.sabih@enterprisedb.com

- canonical: "Jeremy Whiting"
  emails:
    - jwhiting@redhat.com
    - whitingjr@hotmail.com
    - jeremy.whiting@hushmail.com

- canonical: "Hunaid Sohail"
  emails:
    - hunaidpgml@gmail.com
    - 76044242+hunaid2000@users.noreply.github.com

- canonical: "Viktor Holmberg"
  emails:
    - v@viktorh.net
    - viktor.holmberg@aiven.io

- canonical: "Adrian Kloskowski"
  emails:
    - noreply+adrklos@github.com
    - adrian.kloskowski@heimdalldata.com
    - 59052690+adrklos@users.noreply.github.com

- canonical: "Benoit Wiart"
  emails:
    - noreply+benbenw@github.com
    - benoit.wiart@gmail.com

- canonical: "tminglei"
  emails:
    - noreply+tminglei@github.com
    - tmlneu@gmail.com
    - tminglei@linux-n32j.site

- canonical: "Arne Roland"
  emails:
    - arne.roland@malkut.net
    - a.roland@index.de

- canonical: "Masaya Kawamoto"
  emails:
    - kawamoto@sraoss.co.jp
    - masaya.0328.k@gmail.com
    - kawamoto.sraoss.co.jp

- canonical: "odubaj"
  emails:
    - noreply+odubaj@github.com
    - 44674278+odubaj@users.noreply.github.com

- canonical: "Steven Niu"
  emails:
    - niushiji@gmail.com
    - niushiji@highgo.com

- canonical: "Tatsuro Yamada"
  emails:
    - yamatattsu@gmail.com
    - tatsuro.yamada.tf@nttcom.co.jp
    - tatsuro.yamada@ntt.com
    - yamada.tatsuro@lab.ntt.co.jp

- canonical: "Cédric Villemain"
  emails:
    - cedric.villemain+pgsql@abcsql.com
    - cedric.villemain@data-bene.io
    - cedric@2ndquadrant.fr

- canonical: "Markus Karg"
  emails:
    - markus@headcrashing.eu
    - karg@quipsy.de

- canonical: "hyunkshinft"
  emails:
    - noreply+hyunkshinft@github.com
    - 49164320+hyunkshinft@users.noreply.github.com

- canonical: "joyc-bq"
  emails:
    - 95259163+joyc-bq@users.noreply.github.com
    - joyc@bitquilltech.com

- canonical: "eperez"
  emails:
    - noreply+eperez@github.com
    - edpeur@gmail.com

- canonical: "bd-infor"
  emails:
    - noreply+bd-infor@github.com
    - bd-infor@users.noreply.github.com

- canonical: "maffe"
  emails:
    - noreply+maffe@github.com
    - maffe@users.noreply.github.com

- canonical: "pbillen"
  emails:
    - noreply+pbillen@github.com
    - 33231406+pbillen@users.noreply.github.com

- canonical: "pip25"
  emails:
    - noreply+pip25@github.com
    - pip25@users.noreply.github.com

- canonical: "Al Bundy"
  emails:
    - noreply+albundy33@github.com
    - therealhawk@freenet.de

- canonical: "Stepan Neretin"
  emails:
    - sncfmgg@gmail.com
    - slpmcf@gmail.com

- canonical: "Jeevan Ladhe"
  emails:
    - jeevanladhe.os@gmail.com
    - jeevan.ladhe@enterprisedb.com

- canonical: "Anastasia Lubennikova"
  emails:
    - a.lubennikova@postgrespro.ru
    - lubennikovaav@gmail.com

- canonical: "Cody Cutrer"
  emails:
    - cody@instructure.com
    - cody@cutrer.us

- canonical: "Hamid Akhtar"
  emails:
    - hamid.akhtar@percona.com
    - hamid.akhtar@gmail.com

- canonical: "Valentine Gogichashvili"
  emails:
    - valgog@gmail.com
    - vgogichashvili@vgogichashvili-ubuntu

- canonical: "bpd0018"
  emails:
    - noreply+bpd0018@github.com
    - bpd0018@gmail.com
    - 17967090+bpd0018@users.noreply.github.com

- canonical: "sz-liva"
  emails:
    - noreply+sz-liva@github.com
    - 33718672+sz-liva@users.noreply.github.com

- canonical: "cchantep"
  emails:
    - noreply+cchantep@github.com
    - chantepie@altern.org

- canonical: "Serega Morph"
  emails:
    - noreply+seregamorph@github.com
    - serega.morph@gmail.com

- canonical: "Kim Bisgaard"
  emails:
    - noreply+kimbisgaarddmi@github.com
    - 37800626+kimbisgaarddmi@users.noreply.github.com

- canonical: "rtrier"
  emails:
    - noreply+rtrier@github.com
    - 42410362+rtrier@users.noreply.github.com

- canonical: "costa100"
  emails:
    - noreply+costa100@github.com
    - costa.basil@gmail.com

- canonical: "Victor Wagner"
  emails:
    - vitus@cryptocom.ru
    - vitus@wagner.pp.ru

- canonical: "mkoncek"
  emails:
    - noreply+mkoncek@github.com
    - 29146829+mkoncek@users.noreply.github.com

- canonical: "Sophia Chu"
  emails:
    - 112967780+sophia-bq@users.noreply.github.com
    - chusophx@amazon.com

- canonical: "trtrmitya"
  emails:
    - noreply+trtrmitya@github.com
    - trtrmitya@gmail.com

- canonical: "Maksim Milyutin"
  emails:
    - milyutinma@gmail.com
    - maksim.milyutin@tantorlabs.ru

- canonical: "Daisuke Higuchi"
  emails:
    - higuchi.daisuke11@gmail.com
    - higudai@amazon.com
    - noreply+higuchi-daisuke@github.com
- canonical: "Matthew Hsu"
  emails:
    - 75754631+hsuamz@users.noreply.github.com
    - 40806528+matthewh-bq@users.noreply.github.com
    - hsmatthe@amazon.com

- canonical: "Evgeniy Gorbanev"
  emails:
    - gorbanyoves@basealt.ru
    - gorbanev.es@gmail.com

- canonical: "Marcus Mueller"
  emails:
    - noreply+marcmuel@github.com
    - marcus.mueller@schwarz-infosysteme.de

- canonical: "markmaker"
  emails:
    - noreply+markmaker@github.com
    - mark@makr.zone

- canonical: "Antonio Petrelli"
  emails:
    - noreply+apetrelli@github.com
    - antonio.petrelli@gmail.com

- canonical: "Sven Klemm"
  emails:
    - sven@timescale.com
    - sven@tigerdata.com

- canonical: "Abhishek Kumar"
  emails:
    - noreply+abhishek-kumar09@github.com
    - abhimait1909@gmail.com

- canonical: "Adrian Grucza"
  emails:
    - 46910040+apgrucza@users.noreply.github.com
    - adrian.grucza@iress.com

- canonical: "Joel Rabinovitch"
  emails:
    - noreply+joelrabinovitch@github.com
    - joel.rabinovitch@tecsys.com

- canonical: "rnveach"
  emails:
    - noreply+rnveach@github.com
    - rveach02@gmail.com

- canonical: "slmsbrhgn"
  emails:
    - noreply+slmsbrhgn@github.com
    - slmsbrhgn@gmail.com

- canonical: "Erik Nordström"
  emails:
    - erik@timescale.com
    - erik@tigerdata.com

- canonical: "azraino"
  emails:
    - noreply+azraino@github.com
    - azraino@users.noreply.github.com

- canonical: "Sergey Zhuravlev"
  emails:
    - noreply+zhurs@github.com
    - sergey.zhuravlev@gmail.com

- canonical: "nicolas-f"
  emails:
    - noreply+nicolas-f@github.com
    - github@nettrader.fr

- canonical: "Kevin Patel"
  emails:
    - noreply+kevin222004@github.com
    - kevinpatel222004@gmail.com

- canonical: "Amit Khandekar"
  emails:
    - amitdkhan.pg@gmail.com
    - amit.khandekar@enterprisedb.com

- canonical: "Arya Bukhin"
  emails:
    - noreply+aryabukhin@github.com
    - aryabukhin@gmail.com

- canonical: "Alex Malt"
  emails:
    - noreply+maltalex@github.com
    - alex@bit48.net

- canonical: "mjschwaiger"
  emails:
    - noreply+mjschwaiger@github.com
    - mjschwaiger@gmail.com

- canonical: "Sasasu"
  emails:
    - noreply+sasasu@github.com
    - i@sasa.su

- canonical: "mmm444"
  emails:
    - noreply+mmm444@github.com
    - michal.rydlo@gmail.com

- canonical: "Jajal Vipul"
  emails:
    - noreply+jajalvipul@github.com
    - jajalvipul@gmail.com

- canonical: "Marco Nenciarini"
  emails:
    - marco.nenciarini@2ndquadrant.it
    - marco.nenciarini@enterprisedb.com

- canonical: "sly461"
  emails:
    - noreply+sly461@github.com
    - 32794108+sly461@users.noreply.github.com

- canonical: "IvyDev0"
  emails:
    - noreply+ivydev0@github.com
    - yiyid@andrew.cmu.edu

- canonical: "goeland86"
  emails:
    - noreply+goeland86@github.com
    - goeland86@gmail.com

- canonical: "alurie"
  emails:
    - noreply+alurie@github.com
    - luriebiz@gmail.com

- canonical: "bazzargh"
  emails:
    - noreply+bazzargh@github.com
    - brian.ewins@gmail.com

- canonical: "Mike Goodman"
  emails:
    - msgoodman@users.noreply.github.com
    - msgoodman90@gmail.com

- canonical: "Paul Guo"
  emails:
    - paulguo@gmail.com
    - guopa@vmware.com

- canonical: "plan3d"
  emails:
    - 76825073+plan3d@users.noreply.github.com
    - noreply+plan3d@github.com

- canonical: "dosimeta"
  emails:
    - noreply+dosimeta@github.com
    - dosimeta@gmail.com

- canonical: "Lukas Eder"
  emails:
    - lukas.eder@gmail.com
    - lukas.eder@datageekery.com

- canonical: "Ashwin Agrawal"
  emails:
    - ashwinstar@gmail.com
    - aagrawal@pivotal.io

- canonical: "Sergey Nuyanzin"
  emails:
    - snuyanzin@gmail.com
    - sergey.nuyanzin@aiven.io

- canonical: "bjanczak"
  emails:
    - noreply+bjanczak@github.com
    - bartlomiej.janczak@gmail.com

- canonical: "crwr45"
  emails:
    - noreply+crwr45@github.com
    - 34647635+crwr45@users.noreply.github.com
    - charlie.wheelerrobinson@gmail.com

- canonical: "Shaopeng Gu"
  emails:
    - 93494304+frank-gu-81@users.noreply.github.com
    - gushaopengfrank@gmail.com

- canonical: "mjanczykowski"
  emails:
    - noreply+mjanczykowski@github.com
    - mjanczykowski@users.noreply.github.com

- canonical: "r33s3n6"
  emails:
    - r33s3n6@gmail.com
    - noreply+r33s3n6@github.com

- canonical: "Alexander Kuzmenkov"
  emails:
    - akuzmenkov@tigerdata.com
    - a.kuzmenkov@postgrespro.ru

- canonical: "kazachka"
  emails:
    - noreply+kazachka@github.com
    - kazachka@mail.ua

- canonical: "Kevin Wooten"
  emails:
    - kdubb@me.com
    - kevin@wooten.com

- canonical: "TomonariKatsumata"
  emails:
    - noreply+tomonarikatsumata@github.com
    - katsumata@localhost.localdomain

- canonical: "Goooler"
  emails:
    - noreply+goooler@github.com
    - wangzongler@gmail.com

- canonical: "halset"
  emails:
    - noreply+halset@github.com
    - halset@ecc.no

- canonical: "Sophiah Ho"
  emails:
    - sophiah.ho@precisely.com
    - 182134868+sophiahho@users.noreply.github.com

- canonical: "Mahmoud Bahaa"
  emails:
    - mahmoud.bahaa@incorta.com
    - mahmoud.bahaa.eg@gmail.com

- canonical: "Lőrinc Pap"
  emails:
    - lorinc@gradle.com
    - pap.lorinc@gmail.com

- canonical: "damienb-opt"
  emails:
    - noreply+damienb-opt@github.com
    - 36661255+damienb-opt@users.noreply.github.com

- canonical: "Paul Martinez"
  emails:
    - hellopfm@gmail.com
    - paulmtz@google.com

- canonical: "paulo-kluh"
  emails:
    - noreply+paulo-kluh@github.com
    - 80355988+paulo-kluh@users.noreply.github.com

- canonical: "Josh Soref"
  emails:
    - 2119212+jsoref@users.noreply.github.com
    - jsoref@gmail.com

- canonical: "djydewang"
  emails:
    - noreply+djydewang@github.com
    - djydewang@gmail.com

- canonical: "Sergey Ignatov"
  emails:
    - sergey.ignatov@jetbrains.com
    - ignatovs@gmail.com

- canonical: "SheerazMajeedM"
  emails:
    - sheerazmajeed01@gmail.com
    - noreply+sheerazmajeedm@github.com

- canonical: "JCzogalla"
  emails:
    - noreply+jczogalla@github.com
    - 35594017+jczogalla@users.noreply.github.com

- canonical: "epgrubmair"
  emails:
    - noreply+epgrubmair@github.com
    - grubmair@emarsys.com

- canonical: "ivlo11"
  emails:
    - ivlo11@gmail.com
    - noreply+ivlo11@github.com

- canonical: "itchyny"
  emails:
    - noreply+itchyny@github.com
    - itchyny@hatena.ne.jp

- canonical: "Tom Dunstan"
  emails:
    - github@tomd.cc
    - tomdcc@users.noreply.github.com

- canonical: "vharseko"
  emails:
    - noreply+vharseko@github.com
    - vharseko@openam.org.ru

- canonical: "xpoinsard"
  emails:
    - noreply+xpoinsard@github.com
    - xpoinsard@users.noreply.github.com

- canonical: "Yuzuko Hosoya"
  emails:
    - yuzukohosoya@gmail.com
    - hosoya.yuzuko@lab.ntt.co.jp

- canonical: "dh-cloud"
  emails:
    - noreply+dh-cloud@github.com
    - 60729713+dh-cloud@users.noreply.github.com

- canonical: "Alexey Kondratov"
  emails:
    - a.kondratov@postgrespro.ru
    - kondratov.aleksey@gmail.com

- canonical: "David Rader"
  emails:
    - drader@amazon.com
    - david.rader@gmail.com
    - noreply+draderaws@github.com
    - 41007433+draderaws@users.noreply.github.com
  employer: "Databricks"

- canonical: "Davide Angelocola"
  emails:
    - davide.angelocola@gmail.com
    - dfa1@users.noreply.github.com

- canonical: "ItaiFonio"
  emails:
    - noreply+itaifonio@github.com
    - itai.fonio@sap.com

- canonical: "Toddy69"
  emails:
    - 3174167+toddy69@users.noreply.github.com
    - noreply+toddy69@github.com

- canonical: "Tom Aizenberg"
  emails:
    - tom.aizenberg@imc.com
    - tom.aizenberg@gmail.com

- canonical: "iobnc"
  emails:
    - noreply+iobnc@github.com
    - alexyur88@mail.ru

- canonical: "matteosilv"
  emails:
    - noreply+matteosilv@github.com
    - matteosilv@gmail.com

- canonical: "Declan Murphy"
  emails:
    - declan.murphy@zalando.ie
    - declan.murphy@flightclub.io

- canonical: "kaiwangchen"
  emails:
    - kaiwang.chen@gmail.com
    - noreply+kaiwangchen@github.com

- canonical: "david-whs"
  emails:
    - 116106321+david-whs@users.noreply.github.com
    - noreply+david-whs@github.com

- canonical: "N-Coder"
  emails:
    - nfink95@gmail.com
    - noreply+n-coder@github.com

- canonical: "Myo Wai Thant"
  emails:
    - 40167572+myowaithant9@users.noreply.github.com
    - myo.waithant@fujitsu.com

- canonical: "Zhenlei Huang"
  emails:
    - zlei.huang@gmail.com
    - 3699228+gmshake@users.noreply.github.com

- canonical: "kili668"
  emails:
    - noreply+kili668@github.com
    - 64861394+kili668@users.noreply.github.com

- canonical: "Chengxi Sun"
  emails:
    - sunchengxi@highgo.com
    - chengxisun92@gmail.com

- canonical: "Kingter Wang"
  emails:
    - tew@vmware.com
    - kingter@gmail.com

- canonical: "Simon Greatrix"
  emails:
    - simon.greatrix@eeze.com
    - simon@pippsford.com
    - noreply+simon-greatrix@github.com
- canonical: "Eduardo Souza"
  emails:
    - eduardo.souza@digitro.com
    - eduardomatosouza@gmail.com

- canonical: "Sven Diedrichsen"
  emails:
    - sdiedrichsen@yahoo.de
    - sven.diedrichsen@gmail.com

- canonical: "San Nguyen"
  emails:
    - 22189661+sandangel@users.noreply.github.com
    - vinhsannguyen91@gmail.com

- canonical: "Árpád Magosányi"
  emails:
    - m4gw4s@gmail.com
    - mag@magwas.rulez.org

- canonical: "reibitto"
  emails:
    - noreply+reibitto@github.com
    - reibitto@users.noreply.github.com
- canonical: "Bertrand Drouvot"
  emails:
    - bertranddrouvot.pg@gmail.com
    - bdrouvot@amazon.com
  employer: "Amazon/AWS"
- canonical: "Aya Iwata"
  emails:
    - iwata.aya@fujitsu.com
    - iwata.aya@jp.fujitsu.com
- canonical: "Sho Kato"
  emails:
    - kato-sho@fujitsu.com
    - noreply+kato-sho@github.com
- canonical: "Shenhao Wang"
  emails:
    - wangsh.fnst@fujitsu.com
    - wangsh.fnst@cn.fujitsu.com
- canonical: "Cary Huang"
  emails:
    - cary.huang@highgo.ca
    - hcary328@gmail.com
- canonical: "Bo Peng"
  emails:
    - pengbo@sraoss.co.jp
    - pengbo@localhost.localdomain
- canonical: "Devrim Gündüz"
  emails:
    - devrim@gunduz.org
    - devrim at gunduz.org
- canonical: "Florin Asavoaie"
  emails:
    - florin.asavoaie@gmail.com
    - florinasavoaie@users.noreply.github.com
- canonical: "Michail Nikolaev"
  emails:
    - michail.nikolaev@gmail.com
    - noreply+michail-nikolaev@github.com
- canonical: "Imran Zaheer"
  emails:
    - imran.zhir@gmail.com
    - izaheer612@gmail.com
- canonical: "Michael"
  emails:
    - noreply+michael-o@github.com
    - michaelzg@users.noreply.github.com
- canonical: "Xeroman.K"
  emails:
    - xeroman.k@gmail.com
    - xeroman.k@coinone.com
- canonical: "Sodekim"
  emails:
    - noreply+sodekim@github.com
    - 70255432+sodekim@users.noreply.github.com
- canonical: "Frode Carlsen"
  emails:
    - noreply+frode-carlsen@github.com
    - frode.odde.carlsen@nav.no
- canonical: "Rob Bygrave"
  emails:
    - robin.bygrave@gmail.com
    - noreply+rob-bygrave@github.com
- canonical: "Michele Mancioppi"
  emails:
    - noreply+michele-mancioppi@github.com
    - michele.mancioppi@sap.com
- canonical: "Christian Schlichtherle"
  emails:
    - christian@schlichtherle.de
    - noreply+christian-schlichtherle@github.com
- canonical: "Naeem Akhter"
  emails:
    - noreply+naeem-akhter@github.com
    - akhternaeem@gmail.com
- canonical: "Aaron Congo"
  emails:
    - aaronc@bitquilltech.com
    - aaron.congo@improving.com
- canonical: "Vyom Yadav"
  emails:
    - noreply+vyom-yadav@github.com
    - 73882557+vyom-yadav@users.noreply.github.com

# ---- Added 2026-07-11 (operator-provided name->email mapping; all community members) ----

- canonical: "Dave Page"
  emails:
    - dpage@pgadmin.org
  aliases:
    - "Dave Page"

- canonical: "Melanie Plageman"
  emails:
    - melanieplageman@gmail.com
  aliases:
    - "Melanie Plageman"

- canonical: "Noah Misch"
  emails:
    - noah@leadboat.com
    - nm.everywhere@gmail.com
  aliases:
    - "Noah Misch"

- canonical: "Chirag Dave"
  emails:
    - chirag.dave@gmail.com
  aliases:
    - "Chirag Dave"

- canonical: "Mark Wong"
  emails:
    - markwkm@gmail.com
  aliases:
    - "Mark Wong"

- canonical: "Mila Zhou"
  emails:
    - miaolaizhou@gmail.com
  aliases:
    - "Mila Zhou"

- canonical: "Nazneen Jafri"
  emails:
    - nazjafri@amazon.com
  aliases:
    - "Nazneen Jafri"

- canonical: "Robert Treat"
  emails:
    - rob@xzilla.net
  aliases:
    - "Robert Treat"

- canonical: "Scott Mead"
  emails:
    - scott.mead@databricks.com
  aliases:
    - "Scott Mead"

- canonical: "Shayon Sanyal"
  emails:
    - shayons@amazon.com
  aliases:
    - "Shayon Sanyal"

- canonical: "Yogesh Sharma"
  emails:
    - yogesh.sharma@catprosystems.com
  aliases:
    - "Yogesh Sharma"

# ---- Buildfarm owners whose canonical name was the email local-part ----
# These persons existed only via buildfarm registration, so their
# canonical_name defaulted to the owner_email local-part (the scraper's
# fallback). The real names below come from their From-header display names
# on list mail (and, where present, commit author names). Keyed on the
# existing canonical email so 0038 updates the same person entity rather
# than creating a new one. (Discovered 2026-10-01 while auditing animal
# ownership accuracy.)

- canonical: "Mikael Kjellström"
  emails:
    - mikael.kjellstrom@gmail.com
  aliases:
    - "Mikael Kjellström"
    - "mikael.kjellstrom"
  notes: "Buildfarm owner (conchuela, grison, loach, morepork, schnauzer, sidewinder); name from list-mail From header."

- canonical: "Filipe Rosset"
  emails:
    - rosset.filipe@gmail.com
  aliases:
    - "Filipe Rosset"
    - "rosset.filipe"
  notes: "Buildfarm owner (caiman, midge, tayra, timberworm); name from list-mail From header."

- canonical: "Todd Cook"
  emails:
    - cookt@blackduck.com
  aliases:
    - "Todd Cook"
    - "cookt"
  notes: "Buildfarm owner (bumblebee, skimmer); name from commit author + From header."

- canonical: "Jonathan Gonzalez V."
  emails:
    - jonathan@abdiel.eu
  aliases:
    - "Jonathan Gonzalez V."
    - "jonathan"
  notes: "Buildfarm owner (paca, partridge, porpoise); name from commit author + From header."

- canonical: "CSPUG"
  emails:
    - info@cspug.cz
  aliases:
    - "CSPUG"
    - "info"
  notes: "Czech PostgreSQL Users Group; runs buildfarm animals avocet, hippopotamus, jay, trilobite under a group ops address."