Interview questions in PostgreSQL

Below are some of PostgreSQL interview questions

  • How to install PostgreSQL using source code ?
  • What is the architecture of PostgreSQL ?
  • What is clog buffer and how it is useful ?
  • How to restore if you lost a data file ?
  • How to clone a database in PostgreSQL ?
  • How to configure streaming replication ?
  • How to do Point in time recovery in PostgreSQL ?
  • Due to some mistake if a teamember done a wrong update, how you will recover it ?
  • How you monitor PostgreSQL databases ?
  • What is the backup stratagy you are using ?
  • What is MVCC ?
  • What is vacuuming in PostgreSQL ?
  • If a query was running less time yesterday, Suddenly it is taking too much time now. How will you troubleshoot ?
  • Do you know how to configure SSL in PostgreSQL ?
  • What are the major memory related parameters in PostgreSQL ?
  • Do you have any idea about tools like pgbadger , pgpool ?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s