How to auto login in PostgreSQL from a shell?

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 command’s arguments, they will be used. .pgpass ( for psql client ) test1.net:5432:testdb1:testuser1:testpass1 test2.net:5432:testdb2:testuser2:testpass2

October 18, 2019 · 1 min · 64 words · Akhil Jalagam

adminer setup script

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 sudo wget "http://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php sudo ln -s /usr/share/adminer/latest.php /usr/share/adminer/adminer.php echo "Alias /adminer.php /usr/share/adminer/adminer.php" | sudo tee /etc/apache2/conf-available/adminer.conf sudo a2enconf adminer.conf # restart apache/httpd

September 20, 2019 · 1 min · 73 words · Akhil Jalagam

mysqld – Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `memcache` at row

Add --max_allowed_packet=512M to your mysqldump command. Or add max_allowed_packet=512M to [mysqldump] the section of your my.cnf Note: it will not work if it is not under the [mysqldump] section…

September 17, 2019 · 1 min · 29 words · Akhil Jalagam