I have installed PostgreSQL v 9.6.6 - by unzipping into e:\pgsql
I have two issues:
1) initDB apparently doesn't like the OS/2 code page IBM-850
The error message is below
[E:\]initdb -D E:\PGDATA
LOG: 00000: invalid binary "E:/"E:/pgsql/bin/postgres.exe"
LOCATION: find_my_exec, exec.c:146
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.IBM-850".
could not determine encoding for locale "en_US.IBM-850": codeset is "IBM-850"
initdb: could not find suitable encoding for locale "en_US.IBM-850"
Rerun initdb with the -E option.
Try "initdb --help" for more information.
----------------------------
2) I think the encoding of LATIN1 (ISO-8859-1) is the closest encoding to IBM-850 that PostgreSQL recognize, so I specified -E LATIN1.
But now I get a strange issue of Postgres not being able to find its own binaries. Notice the error message below says invalid executable: "E:/"E:/pgsql/bin/postgres.exe"
For some reason Postgres is prefixing the current directory to the front of the path containing the executable and then using that as the path for the executable.
Anyone had success in getting version 9.6.6 to install and run?
[E:\]initdb -E LATIN1 -D E:\PGDATA
LOG: 00000: invalid binary "E:/"E:/pgsql/bin/postgres.exe"
LOCATION: find_my_exec, exec.c:146
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.IBM-850".
could not determine encoding for locale "en_US.IBM-850": codeset is "IBM-850"
could not determine encoding for locale "en_US.IBM-850": codeset is "IBM-850"
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory E:/PGDATA ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... sysv
creating configuration files ... ok
running bootstrap script ... LOG: 00000: invalid binary "E:/"E:/pgsql/bin/postg
res.exe"
LOCATION: find_my_exec, exec.c:146
LOG: 00000: invalid binary "E:/"E:/pgsql/bin/postgres.exe"
LOCATION: find_my_exec, exec.c:146
FATAL: XX000: "E:/pgsql/bin/postgres.exe": could not locate my own executable p
ath
LOCATION: InitStandaloneProcess, miscinit.c:236
child process exited with exit code 1
initdb: removing data directory "E:/PGDATA"