-
How to Create API in Node.js with PostgreSQL
Hello, in this article we will try to answer question how to create api in Node.js with PostgreSQL? Programming is not my vertical expertise, i will try my best to demonstrate. How to create API in Node.js with Postgresql You need to download and install Node.js runtime first. If you are planning an enterprise or…
-
How to Create Database in Postgresql in Linux Terminal?
Hello! In this article we will talk about how to create a database in PostgreSQL in the Linux terminal. Psql is a terminal client we can use to manipulate database objects. For more information you can check Postgresql documentation for CREATE DATABASE statement. How to Create Database in Postgresql in Linux Terminal? First of all…
-
How to Check Active Sessions in PostgreSQL?
Hello! In this article we will cover how to check active sessions in PostgreSQL topic. What is a Session? A session is a connection. When you connect to your database using psql command line it is a session, or using dbeaver it is a session. Pooled Connection Sources I would like to put a separate…
-
How to Check DB Locks in Postgres
Hello! I was afraid of locks when I started to manage databases. It affects the performance and reliability of the database. In this article, I will cover how to check db locks in PostgreSQL topic. How to Check DB Locks in Postgres? Locks are indirect indicators of database health. Locks don’t point out a database…
-
How to Connect Laravel to PostgreSQL
Hello! PHP is one the most popular programming languages, and Laravel is the most popular PHP framework. In this article i will show you how to connect laravel to PostgreSQL. Google search statistics shows how to connect to PostgreSQL using Laravel is a very common question. Laravel is a very popular PHP framework, that includes…
-
How to Check Running Queries in Postgres?
Hello! Monitoring running queries is important for monitoring performance issues and bottlenecks in the database. In this article we will talk about how to check running queries in Postgres and help you to understand pg_stat_activity catalog view. Keeping PostgreSQL database performance over a line is a database administrators primary job. Finding and understanding low performing…
-
Postgres Migrate Database to new Server
Hello! Migrating a database between servers is a very common question. In this article we will talk about postgres migrate database to new server topic. Answer of this question depends on the size, load and critically of the database. Database migration is a very important topic. There are a lot of parameters effecting migration method,…
-
How to Create Role Postgres?
I understand the importance of providing detailed information on creating roles in Postgres to help those who may be familiar with other database engines. Let’s talk abour how to create role Postgres in this article. When it comes to database management systems, the concept of a “role” in Postgres can indeed be confusing for individuals…
-
How to Create View PostgreSQL?
Hello! Views are great for reporting purposes or refining access to sensitive data. In this article we will discuss how to create view PostgreSQL topic. Creating views in PostgreSQL can significantly enhance the manageability and security of your database by providing a virtual table representing a result set of a stored query. This feature is…
-
How to Check Which Version of Postgres is Running?
Hello! Today we will talk about how to check which version of Postgres is running? Checking PostgreSQL version is the first step of inspecting an environment, to understand characteristics, defects and buggy features. I have done many health checks for Db2, WebSphere, FileNet before, always, learning the version of running product was the first step.…