How to Manually Install or Reinstall PostgreSQL 8.4 (Windows)

How to Manually Install or Reinstall PostgreSQL 8.4 (Windows)

If postgresql is installed, check its version:

If PostgreSQL is still installed on your computer, go Start -> Programs and look for PostgreSQL (version) where (version) is the major version of PostgreSQL installed on your computer.
If PostgreSQL is no longer installed on your computer, open My Computer and browse to your Program Files/PostgreSQL directory. There will be a sub-directory listed which is either 8.3 or 8.4 depending on the version installed.

PostgreSQL requires complete administrative privileges to install and run properly.

You can install PostgreSQL on usesr account; however, you must right-click -> Run as Administrator whenever launching a PostgreSQL related function.

Uninstalling old PostgreSQL

Deleting the PostgreSQL Service Account

All Windows Versions
At the Windows command prompt type:

net user postgres /delete

Deleting the PostgreSQL Directory

If you wish to preserve your existing database then please skip this step. This step should only be performed if you are going to be installing a new database or want to delete your existing database.

Open "My Computer" and browse to your "C:/Program Files" directory. Locate the directory named - PostgreSQL and right-click -> Delete.

Download the Installer from PostgreSQL.org

When installing PostgreSQL for PokerTracker 4, always download and install the latest version of PostgreSQL 8.4. (the latest version is 8.4.1)

Open your web browser and go to the PostgreSQL download website at http://www.enterprisedb.com/products-services-training/pgdownload.

Under the Installer Version 8.4.x click the "Windows" button to begin the download.

Install:

The PostgreSQL Setup Wizard

Double-click the downloaded postgresql-8.4.1-windows.exe file that was downloaded to your computer to begin the installer then click the Next button to proceed.

The second screen named Installation Options is the step where you can choose the location to install PostgreSQL.

If this is a new PostgreSQL installation, you will be prompted to select the data directory.

The next screen named Password is for you to create a PostgreSQL database password.

Enter the default password 'dbpass' twice.

The next screen named allows you to change Port that PostgreSQL will use. Do not change this value unless if you are an advanced user and know exactly what you are doing.

Leave the default options selected then click Next > to continue.

checking the correctness of the installation

Go to services.msc

Under the Processes tab, at the very bottom, make sure that Show processes from all users is checked.

Make sure that you see several processes named postgres.exe. If you see this then PostgreSQL is installed properly

Most popular PostgreSQL GUIs in 2022

pgAdmin

pgAdmin is the most popular PostgreSQL GUI. It is purpose built for Postgres and supports all its features and operations. pgAdmin is open source and also supports Postgres derivative databases such as EDB Postgres Advanced Server. You can test it live here.

pgAdmin supported platforms

You can install pgAdmin on

Linux
macOS
Windows
And then access it locally or over internet via your navigator.

Pros

You can run pgAdmin as a web application, on your computer or on any server, meaning you can use pgAdmin to access and manage distributed Postgres databases, from anywhere.
pgAdmin allows you to create, read and edit all PostgreSQL objects
You can easily rearrange its UI
pgAdmin offers advanced server monitoring capabilities
Cons

pgAdmin isn't as straight forward to install on your desktop as other postgres clients

pgAdmin is rather heavy and not easy to onboard
pgAdmin is more suited for administrating your PostgreSQL than developing on it
pgAdmin pricing: pgAdmin is free and open source

DBeaver

DBeaver is a widely used multi database GUI tool, particularly popular among postgreSQL developers. Just like pgAdmin, it's open source. In addition to postgreSQL, it supports MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, and more.

DBeaver supported platforms

Linux
macOS
Windows
Pros

DBeaver is super easy to install as a desktop application, and to connect to your PostgreSQL database
DBeaver offers a visual query builder to create advanced SQL queries without advanced (or any) knowledge of SQL
It comes with strong data access, search, visualization and edition capabilities
DBeaver also offers a fake data generator to populate your database and test it and the applications built on it
Cons

DBeaver runs locally requires a lot of computer resources, which leads to a performance crash

DBeaver pricing: It has a free open source edition as well as a corporate edition. The standard license for the enterprise edition can be purchased for $ 199 or a subscription for $ 19 per month. The free version is good enough for most businesses as many DBeaver users will tell you that the free edition is better than pgAdmin.

OmniDB

OmniDB is a browser-based app to access and manage various databases such as Oracle and MySQL. And of course, it can act as your PostgreSQL client.

OmniDB supported platforms

Linux
macOS
Windows
Pros

OmniDB supports plugins, so developers can add functionalities to their PostgreSQL GUI
It can be accessed by multiple users from several computers, making it a good option to collaborate on your PostgreSQL databases
OmniDB offers intuitive data editing features such as ability to copy and paste blocks
Good SQL editing with a customisable SQL editor featuring syntax highlight and code completion
Cons

Light documentation especially on the usage of the tool
OmniDB is more complex than a Postico or TablePlus but less advanced than a DataGrip or Navicat. It's a good free option but maybe less complete than DBeaver, which has a better documentation and a seemingly larger community.
OmniDB pricing: free and open source

DataGrip

DataGrip is a multi database IDE to install locally, that can act as your Postgres GUI and much more. It is developed by JetBrains who are known for their numerous dev tools. On top of Postgres, it supports MySQL, Oracle Database, Redshift, MariaDB, Cassandra, MongoDB and more.

DataGrip supported platforms

Linux
macOS
Windows
Pros

Powerful data viewer and editor
Great and customisable UI
A lot of powerful features to develop on your PostgreSQL database, such as context and schema based code completion, and real-time bug detection in your code (and fix suggestions!).
Cons

DataGrip can be resource intensive
Because it's much more than a Postgres client, DataGrip can be a bit overwhelming for beginners
DataGrip pricing: $8,9 per month, $199 per user per year for organisations.

Navicat

Navicat is a GUI focused on database development. As it is multi database, on top of acting as your PostgreSQL GUI, it can connect MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite.

Navicat supported platforms

Linux
macOS
iOS
Windows
Pros

Easy and powerful SQL development tools, such as a visual SQL builder, code completion and customisable Code Snippets.
Good database structure visualisation and edition capabilities.
Collaboration feature
Cons

Not Open Source

Navicat pricing: $349.99 per year for non commercial usage, $699.99 per year for commercial usage, with different commitment options

Postico

Postico is macOS PostgreSQL client for reading data, doing basic manual data entry and editing your database structure.

Postico supported platforms

macOS
Pros

Postico is extremely straight forward to execute basic tasks over your PostgreSQL database
Postico easy to install and to securely connect to your Postgres database
Cons

Postico's strenghts are also its weaknesses: it doesn't offer advanced administration, monitoring or querying capabilities
Postico is only available on macOS
Postico pricing: $5.99 to $299 per month for 1 user, free trial with feature limitations but no time limit.

TablePlus

TablePlus is a database management GUI supporting various databases including MySQL, Redshift, Redis, MongoDB and of course PostgreSQL.

TablePlus supported platforms

Linux
macOS
iOS
iPadOS
Windows
Pros

High performance and speed.

Clean and intuitive data browsing, querying and editing UI
Various and easy to use security features
Good query editor including autocomplete, highlight syntax, query reformatter and history.
Cons

Not very stable, has a lot of bugs.
Very limited free trial version.
TablePlus pricing: from $49 to $99

AQuirreL SQL

SquirreL SQL is a Java tool to view the structure of databases, browse their data, issue SQL commands and more. It supports many databases including SQL Server, MySQL, Oracle Database and of course PostgreSQL.

Squirrel SQL Supported platforms

Linux
Mac OS
Windows
Pros

SquirreL SQL supports Java plugins to extend its capabilities
Cons

Configuration is hard for first time users
The interface isn't the most intuitive
SquirreL SQL pricing: free and open source

HeidiSQL

HeidiSQL is a client supporting various databases including MariaDB, MySQL and PostgreSQL. It's been built with the goal of being easy to learn.

HeidiSQL supported platforms

Windows
Pros

HeidiSQL is particularly good at managing several databases/servers simultaneously. Not only it can connect to multiple servers, but allows direct exports from one server or database to another and search across all the connected databases from the same server.
HeidiSQL is easy to install as a Windows app.
Cons

Limited to Windows
Not very stable, has a lot of bugs.

HeidiSQL pricing: free and open source

INFORMATICS

The Best

Przełącznik języka

Tools

This Site

Mining

Security

CMS

Hardware

Backup

Windows Server

Databases

Emulators

Powershell

Storage Array

Active Directory

SEO

MSSQL

Antivirus program

Linux

Licznik

Visitor Info

Who Is Online