Skip to content
Nadeem Asrar's Database Journal
Tips, tricks and opinions on database technology and industry trends!
  • Home
  • About Me
  • Books to Read
  • Contact Me
  • My Blog

Category: Database Administration

PostgreSQL – 2 Simple ways to tell if you are on a streaming replica or a master db?

August 29, 2019 Nadeem Asrar 1 Comment

Issue the pg_lscluster command against the cluster of concern, if it is a replica and not a master, under “status”…

Continue Reading →

Posted in: Database Administration, Database Management, PostgreSQL Filed under: Nadeem Asrar, PostgreSQL, Streaming Replication

pg_basebackup erroring with SSL SYSCALL error

July 25, 2019 Nadeem Asrar Leave a comment

Continue Reading →

Posted in: Database Administration, PostgreSQL, Replication Filed under: pg_basebackup

Execute PostgreSQL commands from Bash

March 17, 2019 Nadeem Asrar Leave a comment

Continue Reading →

Posted in: Database Administration, Linux, PostgreSQL, Unix Filed under: bash, Nadeem Asrar, PostgreSQL

Technical screening interview questions for a DBA

January 16, 2019 Nadeem Asrar Leave a comment

Below are some DBA Technical Screening questions.  Most of the ones listed below are applicable to MySQL DBAs: Question 1:  How many masters can a replication slave database host…

Continue Reading →

Posted in: Career, Database Administration, Database Management, DBA, MySQL, Nadeem Asrar, Uncategorized Filed under: Career, Database Administration, DBA, Interview, Job, Jobs, Screening

Import/Export CSV files in PostgreSQL

December 3, 2018 Nadeem Asrar Leave a comment

The PostgreSQL COPY command can be used to both import from and export to a CSV file. IMPORT: Import CSV…

Continue Reading →

Posted in: Database Administration, Database Management, export, import, PostgreSQL, SQL Filed under: CSV, Export, howto, Import, Nadeem Asrar, PostgreSQL

SQL Commands for setting up MySQL Replication With SSL Encryption

December 1, 2018 Nadeem Asrar Leave a comment

What are the SQL commands to run when setting up SSL replication between master and slave database hosts?  Well, assuming the following: …

Continue Reading →

Posted in: Database Administration, how-to, MySQL, Replication, Security, SSL Filed under: howto, MySQL, Replication setup, SSL

Translating basic commands between mysql vs psql

November 29, 2018 Nadeem Asrar Leave a comment

          mysql … to … psql       Several years back when I was learning PostgreSQL and I…

Continue Reading →

Posted in: Database Administration, MySQL, PostgreSQL, SQL Filed under: MySQL, Nadeem Asrar, PostgreSQL

Recent Posts

  • Different Database Backup Methods
  • Redshift DBA Interview…
  • PostgreSQL – 2 Simple ways to tell if you are on a streaming replica or a master db?

Recent Comments

  • Frank Litvinik on Redshift DBA Interview…
  • Greggupdar on PostgreSQL – 2 Simple ways to tell if you are on a streaming replica or a master db?
  • Nicolas Segundo on Commands to help troubleshoot Redshift SQL Query Performance

Archives

  • November 2019
  • October 2019
  • August 2019
  • July 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
Copyright © 2021 Nadeem Asrar's Database Journal