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. Open the CentOS-Base.repo file with a text editor.To set up a PostgreSQL Media Server database on LinuxĮdit the. The procedure describes how to set up a PostgreSQL database on a CentOS 6 distribution. To use Media Server with a PostgreSQL database, you must install a PostgreSQL server and ODBC driver, and configure Media Server to connect to the database through the driver. Open topic with navigation Set Up a PostgreSQL Database on Linux
0 kommentar(er)
