How to find the error log location in PostgreSQL on Windows or Linux environments

In this article, we will see How to find the error log location in PostgreSQL on Windows or Linux environments.

We can get the error log location by running the command log_directory command in psql shell. Continue reading How to find the error log location in PostgreSQL on Windows or Linux environments

How to install PostgreSQL and pgAdmin on windows 11

In this article, we will see how to install PostgreSQL and pgAdmin on windows 11 step by step.

Steps to install PostgreSQL and pgAdmin on Windows 11

1. Go to PostgreSQL Download Page
Continue reading How to install PostgreSQL and pgAdmin on windows 11

How to execute sql or script file in PostgreSQL on Windows and Linux

In this article, you will learn how to execute sql or script file in PostgreSQL on Windows and Linux step by step.

Create and Execute script in POstgreSQL on Linux Environment:

On Linux, We can execute scripts files in two ways:

1. From Linux shell
2. From psql shell

Execute PostgreSQL sql script from Linux shell:
Continue reading How to execute sql or script file in PostgreSQL on Windows and Linux

psql: could not connect to server: Connection refused

In this article, we will the solution for below error.

psql: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

psql could not connect to server Connection refused
Continue reading psql: could not connect to server: Connection refused

psql: FATAL: the database system is starting up

In this article, we will the solution for below error.

psql: FATAL: the database system is starting up

psql FATAL the database system is starting up

Continue reading psql: FATAL: the database system is starting up