11/10/2023 0 Comments Install postgresql ubuntu![]() ![]() The password for the user account that connects to the database server. The user name to connect to the database server with. The port to use to communicate with the database server. The IP address or hostname of the server that the database server is installed on. Under the data source name, set the following parameters. This file is usually stored in the /etc directory.Īdd the data source name in square brackets. Open the odbc.ini file with a text editor. ![]() If using the Yum package manager, run the command: sudo yum install unixODBC Install unixODBC driver manager version 2.2.14 or later. Is the user name that Media Server will connect as. Is the name of the database that you created. GRANT USAGE ON ALL SEQUENCES IN SCHEMA public TO userName GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO userName ![]() GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO userName If security is not a consideration you could grant all privileges, but the required privileges are: Databaseįor example: GRANT TEMP ON DATABASE databaseName TO userName Grant privileges to the user that Media Server will connect as. Run the script using the command: \i 'path/postgres.sql' Micro Focus recommends running the following command to ensure that the script stops running if it encounters an error: \set ON_ERROR_STOP on The schema is inserted inside the public schema. This script sets up the database schema that Media Server requires. Run the postgres.sql script provided in the Media Server installation directory. Database nameĪny that is compatible with the encoding.įor example: CREATE DATABASE myDatabase WITH ENCODING 'UTF8' LC_COLLATE='en_US.UTF-8' LC_CTYPE='en_US.UTF-8' Ĭonnect to the new database using the command: \c databaseName ![]() Run a CREATE DATABASE command to create a new database. Log on to the psql command-line tool by running the command: sudo -u postgres psql Start the server by running the command: sudo service postgresql-9.3 start Initialize the server by running the command: sudo service postgresql-9.3 initdb If the directory path is not added to the PATH variable, you must specify the psql.exe file path in the terminal to start psql. This step enables you to use the command psql to start the PostgreSQL command-line tool (psql) from the terminal. For example: sudo yum install postgresql93 postgresql93-odbcĪdd the PostgreSQL bin directory path to the PATH environmental variable by running the command: export PATH=$PATH: binDirectoryPath Ensure that these include the ODBC driver. Install the required packages from the RPM file. Where RPM is the name of the downloaded RPM file. Install the PostgreSQL RPM file by running the command: sudo rpm -i RPM x RPM file for your Linux distribution from the PostgreSQL Yum repository on For example: curl -O The file is usually located in /etc/.Īdd the following line to the and sections: exclude=postgresql*ĭownload the PostgreSQL 9.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |