2022-08-15T00:24:08  *** teepee_ is now known as teepee
2022-08-15T09:10:10  <pjessen> acidsys: bmwiedemann: ticket #115289
2022-08-15T09:11:20  <bmwiedemann[m]> I am off duty until Thu
2022-08-15T09:12:49  <pjessen> bmwiedemann[m]: no prob, it isn't urgent.
2022-08-15T09:25:35  *** teepee_ is now known as teepee
2022-08-15T15:20:47  *** teepee_ is now known as teepee
2022-08-15T15:34:58  *** teepee_ is now known as teepee
2022-08-15T17:22:50  <SasiOlin[m]> hmm, I can't get matrix machine to connect to pgbouncer
2022-08-15T17:23:44  <SasiOlin[m]> I am currently connecting to 192.168.47.27, but I would like to duplicate that database to the other machine and use pgbouncer to use them
2022-08-15T17:40:01  <cboltz> IIRC (I'm not a pgbouncer expert) you need to allow each and every connection in the pgbouncer config
2022-08-15T17:54:38  <SasiOlin[m]> I think it's accepted looking at the config
2022-08-15T18:17:27  <cboltz> does postgresql accept connections for this user/db from the pgbouncer IP?
2022-08-15T19:13:35  <SasiOlin[m]> the login fails, so I assume that's the issue
2022-08-15T19:25:24  <SasiOlin[m]> psql: error: connection to server at "192.168.47.4", port 5432 failed: FATAL:  unexpected response from login query
2022-08-15T19:25:24  <SasiOlin[m]> connection to server at "192.168.47.4", port 5432 failed: FATAL:  unexpected response from login query
2022-08-15T19:26:01  <SasiOlin[m]> this only happens with the `matrix` database, the other databases from this host, with the same username and password, work just fine
2022-08-15T19:29:31  <cboltz> hmm, if   salt/profile/postgresql/files/postgresql/pg_hba.conf   is still current (I didn't check on the server), it should be allowed - at least all matrix-related databases are allowed from the same set of IPs
2022-08-15T19:34:17  <SasiOlin[m]> yeah, I also did try switching to host from hostssl, didn't make a difference
2022-08-15T19:34:31  <SasiOlin[m]> er, vice versa
2022-08-15T19:35:06  <SasiOlin[m]> so I assume the problem is with one of the mirrordb backends not having a copy?
2022-08-15T19:35:15  <SasiOlin[m]> maybe?
2022-08-15T19:36:43  <SasiOlin[m]> no, both machines have a matrix db
2022-08-15T19:39:49  <acidsys> I am not sure about openSUSE pgbouncer, but in ours we have to add a pgbouncer SQL schema to new databases
2022-08-15T19:39:58  <acidsys> maybe that info is helpful.. maybe not
2022-08-15T19:41:46  <SasiOlin[m]> oh you may be right about that
2022-08-15T19:42:03  <SasiOlin[m]> let me get on irc for a sec while I kill synapse
2022-08-15T19:42:42  <lcp> I need to migrate the database so it's the same on both machines first
2022-08-15T19:42:55  <cboltz> just checked   testhighstate   - _of course_ pg_hba.conf differs from what we have in salt, and _of course_ the files on mirrordb1 and mirrordb2 differ :-/
2022-08-15T19:43:40  * cboltz wonders if we should configure salt in a way that  file.managed  automatically does  chattr +i
2022-08-15T19:53:28  <lcp> hm, I don't think removing and recreating this database is an option
2022-08-15T20:21:05  <lcp> actually I kinda have to do that anyway
2022-08-15T20:21:26  <lcp> let's quickly dump it and recreate the db I guess
2022-08-15T20:45:46  <lcp> "quickly" ended up with running out of space twice
2022-08-15T21:11:36  <lcp> oof, we are at 20gb dump size this far, that's quite a bit of text
2022-08-15T21:11:58  <cboltz> nice[tm]
2022-08-15T21:20:42  <lcp> it's still not done dumping, this will take a while I think
2022-08-15T21:20:51  <lcp> I may need to do that some other time maybe
2022-08-15T23:23:39  *** teepee_ is now known as teepee