Download PostgreSQL from https://www.enterprisedb.com/download-postgresql-binaries
PostgreSQL v9.2.24 port 5101
PostgreSQL v9.3.25 port 5102
PostgreSQL v9.4.26 port 5103
PostgreSQL v9.6.24 port 5104
PostgreSQL v10.23 port 5105
PostgreSQL v11.21 port 5106
PostgreSQL v13.23 port 5107
PostgreSQL v14.23 port 5108
PostgreSQL v15.18 port 5109
PostgreSQL v16.14 port 5110
PostgreSQL v17.10 port 5111
PostgreSQL v18.4 port 5112
Open CMD and run as administrator.
$ winget install Microsoft.VCRedist.2013.x64 (it happens on version 9.4.26)
----- ----- -----
PostgreSQL v9.2.24 port 5101
$ mkdir %USERPROFILE%\programs\postgresql-server\pgsql_p5101_v9.2.24
$ cd %USERPROFILE%\programs\postgresql-server\pgsql_p5101_v9.2.24
$ tar -xf "%USERPROFILE%\Downloads\postgresql-9.2.24-1-windows-x64-binaries.zip" -C "%USERPROFILE%\programs\postgresql-server\pgsql_p5101_v9.2.24" --strip-components=1
$ cd bin
$ pg_ctl initdb -D "..\data"
Edit file pg_hba.conf :
host all postgres 127.0.0.1/32 md5
host all postgres ::1/128 md5
host all postgres 0.0.0.0/0 md5
Edit file postgresql.conf :
listen_addresses = '*'
port = 5101
$ pg_ctl register -N PostgreSQL-p5101-v9.2.24 -D "%USERPROFILE%\programs\postgresql-server\pgsql_p5101_v9.2.24\data"
$ sc config "PostgreSQL-p5101-v9.2.24" start= demand
$ net start PostgreSQL-p5101-v9.2.24
$ echo %USERPROFILE%
$ psql -h 127.0.0.1 -p 5101 -U username -d template1
$ CREATE ROLE postgres WITH LOGIN SUPERUSER CREATEDB CREATEROLE REPLICATION PASSWORD 'type_your_password';
$ \q
$ psql -h 127.0.0.1 -p 5101 -U postgres
Don't forget to stop PostgreSQL after it done or you need make any changes in database configuration
$ net stop PostgreSQL-p5101-v9.2.24
For secure your database change any method of "trust" being "md5" inside file pg_hba.conf and then re-run again your database
$ net start PostgreSQL-p5101-v9.2.24
----- ----- -----
Comments
Post a Comment