To resolve charset conflict error between utf8 and WIN1252, do the following before any further command are issued in PSQL:
Author: Yvonne Lu
Postgresql Related Notes
If you’ve installed postgresql using the installer, it typically sets the service to start automatically when Windows is started. To
PHP with Postgresql
If PHP is installed as part of XAMPP, it will work with MySQL/MariaDB with no additional change. However, to work
Use Psql to test database connection after install
Note: command case sensitive. Issued from shell at <install directory>/bin psql -d mydb -U myuser To change database: \c databasename
Ofbiz 16.11.04 Logs Locations
run time (including errors, access and engine reports) <install directory>\runtime\logs webtools <install directory>\framework\webtools\groovyScripts\logs <install directory>\framework\webtools\template
Running PSQL after first PostgreSQL install on Windows 10
First, make sure Postgresql is running. A way to start the server is by issuing postgres -D ..\data in the
Switching Ofbiz 16.11.04 to Postgresql 9.6 on Windows 10
Follow instruction from Ofbiz technical set up guide. Download 64 bit Postgresql. This download will include a version of pgadmin.
Apache Ofbiz 16.11.04
Start Application ofbizstart.bat load demo data – gradlew loadDefault ofbiz no demo data – gradlew ofbiz debug mode prepare Eclipse –
Ofbiz links
Ofbiz’s default admin login is username: admin password:ofbiz Accounting https://localhost:8443/accounting/ ecommerce https://localhost:8443/ecommerce/control/main webtools https://localhost:8443/webtools/control/main This contains data file and xml
Ofbiz handling external data
https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz%27s+Data+File+Tools