ChanServ changed the topic of #freedesktop to: https://www.freedesktop.org infrastructure and online services || for questions about freedesktop.org projects, please see each project's contact || for discussions about specifications, please use https://gitlab.freedesktop.org/xdg or xdg@lists.freedesktop.org
scrumplex_ has joined #freedesktop
scrumplex has quit [Ping timeout: 480 seconds]
georgc has joined #freedesktop
gchini has quit [Ping timeout: 480 seconds]
haaninjo has quit [Quit: Ex-Chat]
snetry has joined #freedesktop
sentry has quit [Ping timeout: 480 seconds]
scrumplex_ has quit [Quit: Quassel - Signing Off]
scrumplex has joined #freedesktop
aswar002_ has joined #freedesktop
aswar002 has quit [Ping timeout: 480 seconds]
Dougthedog[m] has joined #freedesktop
Dougthedog[m] has left #freedesktop [#freedesktop]
alarumbe has quit [Remote host closed the connection]
ximion has quit [Remote host closed the connection]
sima has joined #freedesktop
sima has quit [Ping timeout: 480 seconds]
AbleBacon has quit [Read error: Connection reset by peer]
jsa1 has joined #freedesktop
scrumplex has quit [Quit: Quassel - Signing Off]
scrumplex has joined #freedesktop
sentry has joined #freedesktop
snetry has quit [Ping timeout: 480 seconds]
haaninjo has joined #freedesktop
haaninjo has quit [Quit: Ex-Chat]
haaninjo has joined #freedesktop
scrumplex has quit [Quit: Quassel - Signing Off]
scrumplex has joined #freedesktop
noodlez1232 has quit [Ping timeout: 480 seconds]
noodlez1232 has joined #freedesktop
sima has joined #freedesktop
<robclark>
patchwork login seems to be broken
ximion has joined #freedesktop
mrpops2ko has quit [Ping timeout: 480 seconds]
sima has quit [Ping timeout: 480 seconds]
JanC has quit [Read error: Connection reset by peer]
haaninjo has quit [Quit: Ex-Chat]
JanC has joined #freedesktop
haaninjo has joined #freedesktop
mrpops2ko has joined #freedesktop
scrumplex has quit [Quit: Quassel - Signing Off]
scrumplex has joined #freedesktop
olivial has quit [Read error: Connection reset by peer]
olivial has joined #freedesktop
<mupuf>
robclark: works for me
<robclark>
works for me now.. actually now I'm logged in from a previous session.. odd
sima has joined #freedesktop
JanC has quit [Remote host closed the connection]
JanC has joined #freedesktop
olivial has quit [Read error: Connection reset by peer]
olivial has joined #freedesktop
sima has quit [Ping timeout: 480 seconds]
AbleBacon has joined #freedesktop
<emersion>
so hm
<emersion>
i'
<emersion>
ve looked into migrating mailman3 from sqlite to postgres and it's quite painful…
mrpops2ko has quit []
<daniels>
emersion: oh?
sima has joined #freedesktop
<emersion>
mailman core doesn't use django so it's just not supported
<emersion>
apparently one can fiddle with pgloader but some manual fixups seem to be required
<emersion>
another option is to use the REST API to dump/restore each object individually, but that's lossy
mrpops2ko has joined #freedesktop
mrpops2ko has quit []
<karolherbst>
emersion: ... what if you dump the db as sql statements and just hope for the best importing it into postgres?
<emersion>
this def won't work, the data types and sql commands aren't compatible
<karolherbst>
it sounds like it should work tho
<karolherbst>
well
<karolherbst>
in theory
<karolherbst>
with minor fixups
<Mithrandir>
in theory, theory and practice are equal. In practice, they're not.
<karolherbst>
or well.. pgloader sounds like more suited for it
<emersion>
there's not even a guarantee that the database layouts are the same on sqlite and psql
<emersion>
it's two separate codepaths
<karolherbst>
impressive
<karolherbst>
do they write their queries by hand as well?
mrpops2ko has joined #freedesktop
mrpops2ko has quit []
keithp has quit [Quit: ZNC 1.8.2+deb3.1+deb12u1 - https://znc.in]
keithp has joined #freedesktop
cascardo has quit [Ping timeout: 480 seconds]
cascardo has joined #freedesktop
* Consolatis
sets sender to Robert'); DROP TABLE Students;--
alanc has quit [Remote host closed the connection]
alanc has joined #freedesktop
Xe has quit [Quit: WeeChat 4.6.3]
strugee has quit [Remote host closed the connection]
<DragoonAethis>
There are a few places where they do, but it's mostly SQLAlchemy, so it's not that bad
<DragoonAethis>
You could probably get away with installing a fresh Postgres setup to get the schema, constraints, etc, and asking pgloader to truncate the target tables, reset sequences, data only