How to start PostgreSQL on Windows
- 0
-
Tired of reading? Press play to listen instead. N/B. Might not work on some articles
Ready
To start PostgreSQL on Windows, you can follow these steps:
- Open the PostgreSQL installation directory. By default, it is installed in “C:\Program Files\PostgreSQL{version}”.
- Navigate to the “bin” subdirectory.
- Double-click on the “pg_ctl.exe” file to open the PostgreSQL control panel.
- Select the PostgreSQL service you want to start from the drop-down menu.
- Click on the “Start” button to start the service.
Alternatively, you can start PostgreSQL from the command line:
-
Open the command prompt.
-
Navigate to the “bin” subdirectory of the PostgreSQL installation directory.
-
Type the following command to start the PostgreSQL service:
pg_ctl.exe start -D "C:\Program Files\PostgreSQL\{version}\data"
Replace “{version}” with the version number of PostgreSQL you have installed.
Press Enter.
After starting PostgreSQL, you can connect to it using a PostgreSQL client such as psql, pgAdmin, or any other client of your choice.
Credits: Thedbadmin
Was this answer helpful?
Related Articles
How to export users from cpanel phpmyadmin
Step 1: Export Users from cpanel
You can Export users from one site to another site by...
Why the PostgreSQL Service does not start?
If the database/server connection is not able to open there are certain steps to follow in order...
Connecting to Advanced Server with the pgAdmin 4 client
pgAdmin 4 provides an interactive graphical interface that you can use to manage your database...
Install PostgreSQL Database For Windows
To use Postgre in your machine, you need to install:
Postgre Database Server
A graphical tool...
Import a SQL File in MySQL
Importing SQL files into MySQL is a common task for developers and database administrators. The...
