Subversion Repositories oidplus

Compare Revisions

Regard whitespace Rev 861 → Rev 862

/trunk/doc/developer_notes/database/postgresql_notes.txt
1,9 → 1,11
 
apt-get install php-pgsql
 
PDO ConnectionString
pgsql:host=192.168.69.89;port=5432;dbname=oidplus
 
==================================================
Windows Notes
==================================================
 
Add or edit the following line in your C:\Program Files\PostgreSQL\12\data\postgresql.conf :
listen_addresses = '*'
 
12,3 → 14,27
host all all 0.0.0.0/0 md5
Restart Postgresql after adding this with service postgresql restart or the equivalent command for your setup.
 
==================================================
Ubuntu Linux
==================================================
 
apt-get update && apt-get install postgresql
 
Run script at https://www.pgadmin.org/download/pgadmin-4-apt/
 
su - postgre
psql
ALTER USER postgres PASSWORD 'test'
exit
exit
 
Go to http://127.0.0.1/pgadmin4/browser/ and log in
Create new server:
Host localhost
User postgres
Passwort 'test'
 
apt-get install curl php-pgsql
 
During OIDplus setup, you need to switch to postgres Linux user (su – postgres) before you can execute the "curl" command to install the database.
(The authentication is the Linux user calling the "psql" command)