I am following a tutorial and I am trying to add postresql tools to the terminal, i am having trouble doing that, I have postgreSQL already installed in my laptop
this is the tutorial that I am following https://www.youtube.com/watch?v=I6ypD7qv3Z8 go to minute 12:20 to understadn what I am talking about. I want to have 1_mikroORM-setup in the CMD
thank you
To set up a PostgreSQL Media Server database on Windows
Download and install a PostgreSQL server. For instructions, refer to the PostgreSQL documentation on www.postgresql.org.
Ensure that the installation includes the PostgreSQL Unicode ODBC driver.
During installation, set up a user account with superuser privileges.
Add the PostgreSQL bin directory path to the PATH environmental variable.
Open the psql command-line tool:
In the Windows Command Prompt, run the command:
psql -U userName
Enter your password when prompted.
Run a CREATE DATABASE command to create a new database. Specify the following database settings.
Database name Any name.
Encoding Must be Unicode–either UTF8 or UCS2.
Collation Any that is compatible with the encoding.
Locale Any that is compatible with the encoding.
For example:
CREATE DATABASE myDatabase WITH ENCODING 'UTF8' LC_COLLATE='English_United Kingdom' LC_CTYPE='English_United Kingdom';
Connect to the new database using the command:
\c databaseName
Run the postgres.sql script provided in the Media Server installation directory. This script sets up the database schema that Media Server requires. The schema is inserted inside the public schema.
Micro Focus recommends running the following command to ensure that the script stops running if it encounters an error:
\set ON_ERROR_STOP on
Run the script using the command:
\i 'path/postgres.sql'
where path is the script file path.
Grant privileges to the user that Media Server will connect as. If security is not a consideration you could grant all privileges
Open the Data Sources (ODBC) program:
In the Windows Control Panel, click System and Security.
The System and Security window opens.
Click Administrative Tools.
The Administrative Tools window opens.
Double-click Data Sources (ODBC).
The ODBC Data Source Administrator dialog box opens.
In the User DSN tab, click Add... .
The Create New Data Source dialog box opens.
Select the PostgreSQL Unicode driver from the list and click Finish.
The PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box opens.
After these steps, I guess it will be easy for you to proceed.
To set up a PostgreSQL Media Server database on Windows
Download and install a PostgreSQL server. For instructions, refer to the PostgreSQL documentation on www.postgresql.org.
Ensure that the installation includes the PostgreSQL Unicode ODBC driver.
During installation, set up a user account with superuser privileges.
Add the PostgreSQL bin directory path to the PATH environmental variable.
Open the psql command-line tool:
In the Windows Command Prompt, run the command:
psql -U userName
Enter your password when prompted.
Run a CREATE DATABASE command to create a new database. Specify the following database settings.
Database name Any name.
Encoding Must be Unicode–either UTF8 or UCS2.
Collation Any that is compatible with the encoding.
Locale Any that is compatible with the encoding.
For example:
CREATE DATABASE myDatabase WITH ENCODING 'UTF8' LC_COLLATE='English_United Kingdom' LC_CTYPE='English_United Kingdom';
Connect to the new database using the command:
\c databaseName
Run the postgres.sql script provided in the Media Server installation directory. This script sets up the database schema that Media Server requires. The schema is inserted inside the public schema.
Micro Focus recommends running the following command to ensure that the script stops running if it encounters an error:
\set ON_ERROR_STOP on
Run the script using the command:
\i 'path/postgres.sql'
where path is the script file path.
Grant privileges to the user that Media Server will connect as. If security is not a consideration you could grant all privileges
Open the Data Sources (ODBC) program:
In the Windows Control Panel, click System and Security.
The System and Security window opens.
Click Administrative Tools.
The Administrative Tools window opens.
Double-click Data Sources (ODBC).
The ODBC Data Source Administrator dialog box opens.
In the User DSN tab, click Add... .
The Create New Data Source dialog box opens.
Select the PostgreSQL Unicode driver from the list and click Finish.
The PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box opens.
After these steps, I guess it will be easy for you to proceed.
