Skip to content
Friday, May 27, 2022

DBA Notes

DBA Notes
  • AWS
  • Oracle
  • Postgres
  • Linux
  • Docker
  • MySQL
DBA Notes

Categories

  • AWS (2)
    • EC2 (1)
  • Docker (7)
  • General (2)
  • Linux (7)
  • MySQL (3)
  • notepad++ (2)
  • Oracle (19)
  • Postgres (53)
    • Index (9)
      • Bloom (1)
      • BRIN (1)
      • BTree (1)
      • GIN (1)
      • GIST (1)
      • Hash (1)
      • RUM (1)
      • SP-Gist (1)
    • pgpool (1)
  • SQL (8)
  • WSL (2)

Month: September 2021

notepad++

python script for HTML tags in Notepad++

Bulent Soylu September 29, 2021 No Comments htmlnotepad++python

if you have PythonScript plugin, you could do something like I’ve done for automating markdown: make a script for each type of tag that you’d…

View More python script for HTML tags in Notepad++
General Linux

RHEL 8 / CentOS 8 firewall commands

Bulent Soylu September 27, 2021 No Comments centos8firewalllinuxrhel8

systemctl status firewalld systemctl stop firewalld systemctl disable firewalld systemctl start firewalld systemctl enable firewalld

View More RHEL 8 / CentOS 8 firewall commands
AWS Postgres

Connect to AWS EC2 postgres

Bulent Soylu September 25, 2021 No Comments awspostgres

If you can’t connect to aws ec2 instance: vi /var/lib/pgsql/12/data/postgresql.conf listen_addresses = ‘*’

View More Connect to AWS EC2 postgres
AWS EC2 Linux

Enable root Access for Linux Instances

Bulent Soylu September 25, 2021 No Comments awsec2root

AWS doesn’t grant root access by default to EC2 instances. This is an important security best practise. Users are supposed to open a ssh connection…

View More Enable root Access for Linux Instances
Log in

postgres (44)index (10)linux (6)docker (6)oracle (5)tuples (4)vacuum (3)aws (2)notepad++ (2)wsl (2)vim (2)SQL (2)CTE (2)access methods (2)sequential scan (2)concurrency (2)mvcc (2)isolation (2)performance (2)tuple (2)

Recent Posts

  • Export Import statistics with dbms_stats in Oracle
  • Oracle Version Numbers
  • Find password for database link (<= 11.2.0.2)!
  • How to check progress of a long running statistics gathering job
  • Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS

Archives

  • March 2022 (10)
  • February 2022 (2)
  • January 2022 (6)
  • December 2021 (3)
  • November 2021 (7)
  • October 2021 (51)
  • September 2021 (4)

[s2Member-Security-Badge v="2" /]

DBA Notes | Designed by: Theme Freesia | WordPress | © Copyright All right reserved