DBATag
ActivePublic
Watch Project

Members

This project does not have any members.
View All

Watchers

This project does not have any watchers.
View All

Details

Description

Need advice about database design or query optimization? Add this tag.

This is a project-as-a-tag.

Recent Activity
View All

Yesterday

dereckson added a cover image to T2230: Evaluate Barman for PostgreSQL backups.

Sat, Feb 14, 12:52 · Servers, DBA, Product evaluation, Backups

dereckson triaged T2230: Evaluate Barman for PostgreSQL backups as Normal priority.

Sat, Feb 14, 12:52 · Servers, DBA, Product evaluation, Backups

Sat, Feb 7

dereckson moved T2213: Ensure fbsql still compile with C23 standard from Backlog to Dev on the good-first-issue board.

Sat, Feb 7, 12:57 · good-first-issue, C, DBA, IRC, Dæghrefn

dereckson moved T2213: Ensure fbsql still compile with C23 standard from Working on to Debt on the Dæghrefn board.

Sat, Feb 7, 12:57 · good-first-issue, C, DBA, IRC, Dæghrefn

dereckson moved T2213: Ensure fbsql still compile with C23 standard from Backlog to General bug & features on the C board.

Sat, Feb 7, 12:57 · good-first-issue, C, DBA, IRC, Dæghrefn

dereckson updated the task description for T2213: Ensure fbsql still compile with C23 standard.

Sat, Feb 7, 12:57 · good-first-issue, C, DBA, IRC, Dæghrefn

dereckson placed T2213: Ensure fbsql still compile with C23 standard up for grabs.

The extension now compiles, links and works fine with D3910 and D3911.

Sat, Feb 7, 12:54 · good-first-issue, C, DBA, IRC, Dæghrefn

dereckson added a revision to T2213: Ensure fbsql still compile with C23 standard: D3910: Avoid const char** to char** now invalid pointer convert.

Sat, Feb 7, 12:27 · good-first-issue, C, DBA, IRC, Dæghrefn

dereckson renamed T2213: Ensure fbsql still compile with C23 standard from Ensure fbsql still compile for TCL 8.6.17 to Ensure fbsql still compile with C23 standard.

Sat, Feb 7, 12:23 · good-first-issue, C, DBA, IRC, Dæghrefn

dereckson added a comment to T2213: Ensure fbsql still compile with C23 standard.

Submitted the fbsql.c and compilation log to Claude Sonnet 4.5

Sat, Feb 7, 12:22 · good-first-issue, C, DBA, IRC, Dæghrefn

dereckson moved T2213: Ensure fbsql still compile with C23 standard from Backlog to Services / Features on the DBA board.

Sat, Feb 7, 11:40 · good-first-issue, C, DBA, IRC, Dæghrefn

dereckson moved T2213: Ensure fbsql still compile with C23 standard from Backlog to Eggdrop dev on the IRC board.

Sat, Feb 7, 11:40 · good-first-issue, C, DBA, IRC, Dæghrefn

dereckson moved T2213: Ensure fbsql still compile with C23 standard from Backlog to Working on on the Dæghrefn board.

Sat, Feb 7, 11:40 · good-first-issue, C, DBA, IRC, Dæghrefn

dereckson triaged T2213: Ensure fbsql still compile with C23 standard as High priority.

Sat, Feb 7, 11:40 · good-first-issue, C, DBA, IRC, Dæghrefn

Nov 28 2025

ptdradmin closed T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql as Resolved.

Mounting the ZFS datasets mysql-innodb-data and mysql-innodb-logs outside of /var/db/mysql, then deploying them to db-B-001: operation completed and functional.

Nov 28 2025, 12:55 · good-first-issue, DBA, Servers

Nov 25 2025

dereckson added a comment to T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql.

Deployed on WindRiver.

Nov 25 2025, 10:06 · good-first-issue, DBA, Servers

Nov 24 2025

ptdradmin added a comment to T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql.

Avancement sur T2074

Nov 24 2025, 15:46 · good-first-issue, DBA, Servers

dereckson added a revision to T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql: D3890: Mount MySQL root ZFS dataset as /var/db/mysql/data.

Nov 24 2025, 14:30 · good-first-issue, DBA, Servers

dereckson moved T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql from Backlog to Working on on the Servers board.

Nov 24 2025, 14:07 · good-first-issue, DBA, Servers

dereckson assigned T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql to ptdradmin.

Nov 24 2025, 14:07 · good-first-issue, DBA, Servers

Nov 11 2025

dereckson moved T2186: Upgrade to PostgreSQL 17 from Working on to Next on the Operations sprints (Echoes in the Void) board.

Nov 11 2025, 16:07 · DBA, Servers, Operations sprints (Echoes in the Void)

dereckson updated the task description for T2186: Upgrade to PostgreSQL 17.

Nov 11 2025, 16:07 · DBA, Servers, Operations sprints (Echoes in the Void)

dereckson updated the task description for T2186: Upgrade to PostgreSQL 17.

Nov 11 2025, 16:07 · DBA, Servers, Operations sprints (Echoes in the Void)

dereckson lowered the priority of T2186: Upgrade to PostgreSQL 17 from Unbreak Now! to High.

Deployed for WindRiver, server now runs on 17.6.

Nov 11 2025, 16:06 · DBA, Servers, Operations sprints (Echoes in the Void)

dereckson added a revision to T2186: Upgrade to PostgreSQL 17: D3874: Upgrade PostgreSQL version to 17.

Nov 11 2025, 13:53 · DBA, Servers, Operations sprints (Echoes in the Void)

dereckson moved T2186: Upgrade to PostgreSQL 17 from Next to Working on on the Operations sprints (Echoes in the Void) board.

Nov 11 2025, 13:50 · DBA, Servers, Operations sprints (Echoes in the Void)

dereckson claimed T2186: Upgrade to PostgreSQL 17.

Taking this, we've PostgreSQL deinstalled on WindRiver; as we're on a UNIX system, it still runs without any issue as long as it doesn't need to load dynamically a library, accepts connection, serves traffic but software isn't there anymore.

Nov 11 2025, 13:50 · DBA, Servers, Operations sprints (Echoes in the Void)

dereckson closed T2185: Create PostgreSQL database on WindRiver to test keruald Keruald Database as Resolved.

Nov 11 2025, 02:43 · Servers, DBA, Keruald

dereckson added a revision to T2185: Create PostgreSQL database on WindRiver to test keruald Keruald Database: D3872: Create PostgreSQL database for Keruald tests.

Nov 11 2025, 02:37 · Servers, DBA, Keruald

dereckson added a comment to T2187: Create a separate PostgreSQL log.

In T2185#33876, @dereckson wrote:

Each test run produces this:

Nov 11 02:29:33 windriver postgres[63389]: [19-1] 2025-11-11 02:29:33.804 UTC [63389] ERROR:  relation "nonexisting" does not exist at character 13
Nov 11 02:29:33 windriver postgres[63389]: [19-2] 2025-11-11 02:29:33.804 UTC [63389] STATEMENT:  DELETE FROM nonexisting
Nov 11 02:29:34 windriver postgres[63402]: [19-1] 2025-11-11 02:29:34.181 UTC [63402] ERROR:  relation "nonexisting" does not exist at character 15
Nov 11 02:29:34 windriver postgres[63402]: [19-2] 2025-11-11 02:29:34.181 UTC [63402] STATEMENT:  SELECT * FROM nonexisting
Nov 11 02:29:34 windriver postgres[63403]: [19-1] 2025-11-11 02:29:34.209 UTC [63403] ERROR:  relation "nonexisting" does not exist at character 15
Nov 11 02:29:34 windriver postgres[63403]: [19-2] 2025-11-11 02:29:34.209 UTC [63403] STATEMENT:  SELECT * FROM nonexisting
Nov 11 02:29:34 windriver postgres[63408]: [19-1] 2025-11-11 02:29:34.357 UTC [63408] ERROR:  relation "not_existing_table" does not exist
Nov 11 02:29:34 windriver postgres[63408]: [19-2] 2025-11-11 02:29:34.357 UTC [63408] STATEMENT:  TRUNCATE not_existing_table
Nov 11 02:29:34 windriver postgres[63409]: [19-1] 2025-11-11 02:29:34.385 UTC [63409] ERROR:  relation "not_existing" does not exist
Nov 11 02:29:34 windriver postgres[63409]: [19-2] 2025-11-11 02:29:34.385 UTC [63409] STATEMENT:  TRUNCATE not_existing
Nov 11 02:29:34 windriver postgres[63416]: [19-1] 2025-11-11 02:29:34.591 UTC [63416] FATAL:  password authentication failed for user "notexisting"
Nov 11 02:29:34 windriver postgres[63416]: [19-2] 2025-11-11 02:29:34.591 UTC [63416] DETAIL:  Role "notexisting" does not exist.
Nov 11 02:29:34 windriver postgres[63416]: [19-3]       Connection matched pg_hba.conf line 22: "host    all             all             127.0.0.1/32            scram-sha-256"

I guess we could avoid to post PostgreSQL logs directly in /var/log/messages.

Nov 11 2025, 02:33 · DBA, Servers, Salt, Operations sprints (Echoes in the Void)

dereckson triaged T2187: Create a separate PostgreSQL log as Normal priority.

Nov 11 2025, 02:33 · DBA, Servers, Salt, Operations sprints (Echoes in the Void)

dereckson added a comment to T2185: Create PostgreSQL database on WindRiver to test keruald Keruald Database.

Each test run produces this:

Nov 11 2025, 02:30 · Servers, DBA, Keruald

dereckson added projects to T2186: Upgrade to PostgreSQL 17: Servers, DBA.

Nov 11 2025, 02:13 · DBA, Servers, Operations sprints (Echoes in the Void)

dereckson added a comment to T2185: Create PostgreSQL database on WindRiver to test keruald Keruald Database.

Actually, we use the same database name than for MariaDB / MySQl:

Nov 11 2025, 01:47 · Servers, DBA, Keruald

dereckson triaged T2185: Create PostgreSQL database on WindRiver to test keruald Keruald Database as Normal priority.

Nov 11 2025, 01:41 · Servers, DBA, Keruald

Oct 12 2025

dereckson closed T2140: Migrate Wolfplex wiki tables on a dedicated database as Resolved.

Oct 12 2025, 15:36 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson added a comment to T2140: Migrate Wolfplex wiki tables on a dedicated database.

Write is working.

Oct 12 2025, 15:36 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson added a comment to T2140: Migrate Wolfplex wiki tables on a dedicated database.

Wiki is now using wolfplex_wiki database.

Oct 12 2025, 15:27 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson added a revision to T2140: Migrate Wolfplex wiki tables on a dedicated database: D3746: Revert "Lock Wolfplex wiki in read-only mode".

Oct 12 2025, 15:26 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson added a revision to T2140: Migrate Wolfplex wiki tables on a dedicated database: D3745: Switch Wolfplex wiki to wolfplex_wiki dedicated database.

Oct 12 2025, 15:24 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson added a comment to T2140: Migrate Wolfplex wiki tables on a dedicated database.

Import to wolfplex_wiki database done.

Oct 12 2025, 15:18 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson added a revision to T2140: Migrate Wolfplex wiki tables on a dedicated database: D3744: Create wolfplex_wiki database.

Oct 12 2025, 14:48 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson added a comment to T2140: Migrate Wolfplex wiki tables on a dedicated database.

Wolfplex wiki is in read-only mode.

Oct 12 2025, 14:44 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson added a revision to T2140: Migrate Wolfplex wiki tables on a dedicated database: D3743: Lock Wolfplex wiki in read-only mode.

Oct 12 2025, 14:14 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson added a revision to T2140: Migrate Wolfplex wiki tables on a dedicated database: D3742: Allow to set a wiki in read-only mode.

Oct 12 2025, 14:11 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson added a revision to T2140: Migrate Wolfplex wiki tables on a dedicated database: D3741: Introduce Option class with Some and None types.

Oct 12 2025, 13:44 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson triaged T2140: Migrate Wolfplex wiki tables on a dedicated database as Normal priority.

Oct 12 2025, 10:40 · DBA, Wolfplex migration, Mediawiki SaaS

dereckson moved T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql from Backlog to Servers on the DBA board.

Oct 12 2025, 10:40 · good-first-issue, DBA, Servers

dereckson moved T1847: Set up PostgreSQL database from Backlog to Queries on the DBA board.

Oct 12 2025, 10:39 · DBA, ServPulse

dereckson moved T2140: Migrate Wolfplex wiki tables on a dedicated database from Backlog to Queries on the DBA board.

Oct 12 2025, 10:39 · DBA, Wolfplex migration, Mediawiki SaaS