Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: bash

What does “psql: /usr/pgsql-11/lib/libpq.so.5: no version information available (required by psql)” actually mean?

By adminPosted on March 1, 2023

Question : I have a question regarding following output: [nikola@192 ~] $ sudo su – postgres [postgres@192 ~] $ psql […]

Save output of a Mongo Command to a Variable bash script

By adminPosted on October 9, 2022

Question : I have been writing a script to find and kill slow mongodb queries, how can I store output […]

How to pass environment variables to a sql file from bash shell (PostgreSQL)

By adminPosted on June 12, 2022

Question : I need to be able to pass environment variables, from a bash shell executing a .sql file using […]

Postgres how do return a message if no results for SELECT query

By adminPosted on March 18, 2022

Question : Have been trying to work out how to return a message if the result is empty. I am […]

How to return values from psql to bash with custom session settings

By adminPosted on November 12, 2021

Question : I need to set the datestyle to “dd/mm/yyyy” before calling a procedure and getting it’s return value back […]

Merging one SQL database into another

By adminPosted on July 23, 2021

Question : Currently in my CI I’m completely wiping production db with development db. That was fine for testing but […]

execute mysqlshell from within a bash script? is it possible?

By adminPosted on January 20, 2021

Question : I am writing a backup script for a database and want to use mysqlshell util.dumpSchemas() utility. But how […]

Recent Posts

  • How to pass a parameter into a subquery in a join statement [closed]
  • Replicate a database with a subset of data offered by custom queries [closed]
  • Are there any benefits in certain ordering of columns when defining indexes
  • Logins aren’t syncing across Availability Groups
  • Finding same values and updating rankings
  • Servers running on Microsoft Windows instead output carriage
  • Master ip has changed in postgresql replication
  • optimize design for a table with 50 columns [closed]
  • SQLServer In-Memory database and log file size unexpected increase
  • Is it worth to optimize queries with EarlyTermination Timeout?
  • Is there way to get transaction commit timestamp in Postgres?
  • MySQL/PHP Returning Blank Error Message [closed]
  • Mysql might have too many indexes
  • Database replication with ability to revert to previous states
  • Linked server to Oracle doesn’t use filters. Are there any performance changes in different versions of SQL Server?
  • Enable query store for all databases
  • SQL Server 2012 Enforce Password Policy [closed]
  • Maintenance in MYSQL when innodb_file_per_table disabled
  • SQL Server stored procedure producing data related to months between two dates [duplicate]
  • Efficient way to store multi choice in a column with few options

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding