Fatal Error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails.
Problem: Sometimes, we get the following error when trying to make a connection in Rails. FATAL ERROR: Peer authentication failed for us...
-
Sometimes we need to remove special characters from string or columns value. Suppose, we developed an ETL tool that inserting records on ...
-
If you are a DBA and you are working on a data-dictionary for a project so that you can keep track of schema changes and so on, then this ... -
Many scenarios come in query writing, we have to check particular VIEW exists in the database or not. There are many approaches to che...
-
There are several ways to check the table exist in the particular schema , some solutions are described below. First, I'll create...
-
Problem: Suppose we have a source directory where more than one tab-delimited files exist, and we need to move files in archive folder ... -
Question 1: What is .Net core? Answer: .NET Core is an open-source, general-purpose development platform maintained by Microsoft and ...
-
This issue comes much time when we are using PostgreSQL with Node.js, Error: Cannot find module 'bcrypt' in nodejs application, and...
-
We can use $add an operator to add days in ISODate in MongoDB, $add is the Arithmetic Aggregation Operator, which adds number and date in ...
-
Problem: Suppose you are creating an application using Java and for the backend you are using PostgreSQL, sometimes we face the error as... -
My first task was to import CSV data to PostgreSQL after finishing the schema/table design. It was very challenging for me because I was new...