As authentication method, only trust/reject/md5 are supported.
UNIX domain socket for postmaster is not supported.
UNIX domain socket for createdb, dropdb, createuser, dropuser, createlang, droplang is not supported.
In PostgreSQL, createdb, dropdb, createuser, dropuser, createlang, droplang are shell scripts that calls psql, but in PowerGres on Windows, they are rewritten in libpq.
Since createdb, dropdb, createuser, dropuser, createlang, droplang uses getopt_long to analyze command arguments, you may not use -?. Also, when unsupported option was specified, the error message is slightly different from PostgreSQL.
When multibyte character (for example, JIS X 0208) is included in the path for installing directory or database name, there is a possibility of database not working properly.
statistics collecter is not supported.
statement timeout is not supported.
authentication timeout is not supported.
You may not use Japanese filename for COPY command (when used, the filename will be in EUC-JP).
postmaster
You must use exclusive pg_ctl in order to shutdown and/or reload postmaster.
There is a possibily that the database server would not shutdown immediately even when database was shutdown using pg_ctl's fast shutdown.
If postmaster does not respond by any chance, there is a possibility that you could not shutdown postmaster using pg_ctl even if it is immediate shutdown.
In this case, please stop the postmaster from Windows's task manager.
Superuser name is always 'postgres'.
Windows's security functions are not supported. Anyone may shutdown and/or reload postmaster using pg_ctl.
Also, even if NTFS is being used, access control will not be set for database files.
Syslog and Windows's event log are not supported. For logging, only to the specified file is supported.
SSL is not supported.
initdb
Generated postgresql.conf is customized to run postmaster with tcpip_socket option on by default for PowerGres on Windows.
The following options for locale are not supported.
--locale
--lc-collate
--lc-ctype
--lc-messages
--lc-monetary
--lc-numeric
--lc-time
-n, --noclean options are not supported.
pg_dump / pg_dumpall / pg_restore
Default IP of connecting host is 127.0.0.1.
Password counter measure is done for DOS prompt operations.
createlang
Since -l (--list) option, the option that lists the registered language, uses libpq, there are some difference between PostgreSQL and PowerGres.
droplang
droplang does not function properly.
Since -l (--list) option, the option that lists the registered language, uses libpq, there are some difference between PostgreSQL and PowerGres.
pg_ctl
Specifing log file using -l option is not supported.
psql
Since readline is not implemented, "commandline history" is not supported.
Since temporary files uses system library, environmental variable TMPDIR is not used.
As for home directory, when environmental variable HOME is not set, it is set together with HOMEDRIVE and HOMEPATH.
About power resources hindrance
There is a possibility of data inconsistency when there is power resources hindrance immediately after CHECKPOINT (about for 1 minute).
(Notice)
In preparation for power resources hindrance, PowerGres keeps all data updates to disk in journal format aside from database. This process is done with confirmation that they are written to disk. From this, the possibility of data inconsistency is greatly reduced. However, since journal log keeps on increasing, removal of old log (this is called CHECKPOINT) must be done sooner or later. Nevertheless for about 1 minute after this process, the possibility of data inconsistency is comparatively high. Therefore, we insist you to backup data regularly, and/or have UPS for the system.