supix

The problem

In some cases, it is possible that PostgreSQL tables get corrupted. This can happen in case of hardware failures (e.g. hard disk drives with write-back cache enabled, RAID controllers with faulty/worn out battery backup, etc.), as clearly reported in this wiki page. Furthermore, it can happen in case of incorrect setup, as well.

One of the symptoms of such corruptions is the following message:

ERROR: missing chunk number 0 for toast value 123456 in pg_toast_45678

This almost surely indicates that a corrupted chunk is present within a table file. But there is a good way to get rid of it.

supix

using MongoDB.Bson;
using MongoDB.Bson.Serialization;
using MongoDB.Bson.Serialization.Conventions;
using MongoDB.Bson.Serialization.IdGenerators;
using MongoDB.Bson.Serialization.Serializers;
using MongoDB.Driver;

namespace Persistence.MongoDB
{
    internal class DbContext

supix

using Microsoft.AspNetCore.Http;

internal class GetLoggedUser : IGetLoggedUser
    {
        private readonly IHttpContextAccessor httpContextAccessor;

        public GetLoggedUser(IHttpContextAccessor httpContextAccessor)
        {
            this.httpContextAccessor = httpContextAccessor ?? throw new ArgumentNullException(nameof(httpContextAccessor));
        }

supix

    /// <summary>
		///   Computes checksum validity on an Italian Fiscal Code
		/// </summary>
		/// <param name="fiscalCode">The Fiscal Code to be checked</param>
		/// <returns>Checksum is valid</returns>
		/// <remarks>Checksum routines are at https://en.wikipedia.org/wiki/Italian_fiscal_code_card</remarks>
    /// <remarks>Used regular expression is at http://blog.marketto.it/2016/01/regex-validazione-codice-fiscale-con-omocodia/</remarks>
		private bool IsFiscalCodeOk(string fiscalCode)
		{
      const string regex = @"/^(?:[B-DF-HJ-NP-TV-Z](?:[AEIOU]{2}|[AEIOU]X)|[AEIOU]{2}X|[B-DF-HJ-NP-TV-Z]{2}[A-Z]){2}[\dLMNP-V]{2}(?:[A-EHLMPR-T](?:[04LQ][1-9MNP-V]|[1256LMRS][\dLMNP-V])|[DHPS][37PT][0L]|[ACELMRT][37PT][01LM])(?:[A-MZ][1-9MNP-V][\dLMNP-V]{2}|[A-M][0L](?:[\dLMNP-V][1-9MNP-V]|[1-9MNP-V][0L]))[A-Z]$/i";

supix

---
  
- name: gather kernel version
  hosts: all
  vars:
    filename: /tmp/kernelv.txt
    dst_folder: /tmp/hosts
  tasks:

    - name: delete the centralized file

supix

---

- name: Check if a string is found through grep
  hosts: all
  vars:
    filename: /tmp/rc.txt
    dst_folder: /tmp/hosts
  tasks:

    - name: delete the centralized file

supix

yum updateinfo list cves

supix

Free development resources

• Online sequence diagram editor - https://www.websequencediagrams.com/
• Online diagram editor - https://app.diagrams.net/
• Online JWT editor - https://jwt.io
• Online GUI designer - https://mockflow.com
• Online REST api tester - https://reqres.in/
• Markdown editor - https://jbt.github.io/markdown-editor/
• Markdown cheatsheet - https://github.com/adam-p/markdown-here/wiki/Markdown-Cheatsheet
• Strongly-typed models and serializers generator from JSON - https://app.quicktype.io

supix

psql -U postgres

create database myNewDB;
create user myNewDB_web;
create user myNewDB_owner;

ALTER USER myNewDB_web WITH PASSWORD 'pwd';
ALTER USER myNewDB_owner WITH PASSWORD 'pwd';

psql -U postgres -d myNewDB

supix

use myDbName

// drop users
db.dropUser("ro_user");
db.dropUser("rw_user");
db.dropUser("owner_user");

// read-only user
db.createUser({
  user: "ro_user",