| BML-S | Help Login

Last entries

    20240418.1515

  1. postgres|postgresql > must be owner of type - [s]

    SELECT typname, typowner::regrole, n.* FROM pg_type t LEFT JOIN pg_namespace n on t.typnamespace = n.oid

    2. 20240418.1121

  2. postgres > how to find which records or tables are locked on Postgresql - [s]

    select pid, usename, pg_blocking_pids(pid) as blocked_by, query as blocked_query from pg_stat_activity where cardinality(pg_blocking_pids(pid)) > 0;

    3. 20240418.0849

  3. postgres - VACUUM FREEZE vs. VACUUM FULL - [s]

    4. 20240411.1501

  4. linux|centos7 > yum install createrepo - [s]

    [root@node-nxrm2 yum.repos.d]# cat appstream.repo [appstream] name=CentOS Linux $releasever - AppStream #mirrorlist=http://#mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=AppStream&infra=$infra #baseurl=http://vault.centos.org/$contentdir/$releasever/AppStream/$basearch/os/ baseurl=http://vault.centos.org/centos/7.6.1810/os/x86_64/ gpgcheck=1 enabled=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial

    5. 20240411.1450

  5. linux|CentOS > Cannot prepare internal mirrorlist: No URLs in mirrorlist - [s]

    sed -i 's/mirrorlist/#mirrorlist/g' /etc/yum.repos.d/CentOS-Linux-* sed -i 's|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g' /etc/yum.repos.d/CentOS-Linux-*

    6. 20240405.1104

  6. bash|wget > How To Find Broken Links (404: Not Found.) - [s]

    wget --spider -r -nd -nv -l3 -w1 -t1 -e robots=off -o help.example.com.log https://help.example.com/en/

[s] public (6)