How to auto login in PostgreSQL from a shell?

Published: October 18, 2019 / Updated: July 15, 2021 Akhil Jalagam Beginners, Database, DevOps, Howto, Linux

When you run MySQL commands MySQL, mysqlcheck, mysqdump and psql, psqldump etc; they will pick username & password from this file if you do not provide them as argument (-u and -p). It can save you time.

Of course, if you specify username and password explicitly as part of the … Read more

Related posts:

  1. adminer setup script
  2. How to install, configure, create user and database with permissions – PostgreSQL
  3. mysqld – Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `memcache` at row
  4. How to auto login in MySQL from a shell?

How to install, configure, create user and database with permissions – PostgreSQL

Published: October 15, 2019 / Updated: April 20, 2020 Akhil Jalagam Beginners, Database, DevOps, Howto, Linux
postgresql

PostgreSQL: The World’s Most Advanced Open Source Relational Database

PostgreSQL is arguably the most advance and powerful opensource enterprise class relational database system. It is the object relational database system and provides the most standard compliant system for the Database designers. It provides the complete support for reliable transactions that … Read more

Related posts:

  1. How to auto login in PostgreSQL from a shell?
  2. adminer setup script
  3. How to install, configure, create user and database with permissions – MySQL
  4. Restricting Access with HTTP Basic Authentication in Apache and Nginx

adminer setup script

Published: September 20, 2019 / Updated: September 20, 2019 Akhil Jalagam Database, DevOps, Howto, Linux

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consists of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch, and MongoDB.

install script

sudo mkdir /usr/share/adminer
… Read more

Related posts:

  1. How to auto login in PostgreSQL from a shell?
  2. mysqld – Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `memcache` at row
  3. How to install, configure, create user and database with permissions – PostgreSQL
  4. How to install, configure, create user and database with permissions – MySQL