![]() ![]() The above command will take some time to initialize PostgreSQL first time. usr/pgsql-11/bin/postgresql-11-setup initdb To initialize the database use the below command. In other words, this will create a data directory and other configuration files on your system. Enter y to confirm and complete the installation process.Īfter that, you need to initialize the PostgreSQL instance. This will also install some additional required packages on your system. Step 2 – Installing PostgreSQL on CentOS 7Īfter enabling PostgreSQL yum repository in your system use following command to install PostgreSQL 11 on your system with yum package manager. ![]() sudo yum install įor more details visit PostgreSQL repositories link page where you can get repository package rpm for various operating systems. Use one of the below commands as per your operating system version. This article has been tested on CentOS Linux release 7.5 Step 1 – Configure Yum Repositoryįirstly you need to configure the PostgreSQL repository in your system. This article will help you to install PostgreSQL 11 on CentOS/RHEL 7/6 system. PostgreSQL is developed at the University of California at Berkeley Computer Science Department. It is an open-source object-relational, highly scalable, SQL-compliant database management system. If you liked this post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. They are available 24×7 and will take care of your request immediately. Of course you don’t have to do any of this if you use one of our Linux VPS hosting services, in which case you can simply ask our expert Linux admins to do this for you. Please note, the default authentication mode is set to ‘ident’, so if you like to log in as newuser, you should register the newuser as a Linux system user on your CentOS 6 VPS. Now, you can log in using the newuser with # su - newuser # GRANT ALL ON ALL TABLES IN SCHEMA newschema TO newuser Īnd finally exit PostgreSQL using the command # \q Grant privileges with # GRANT ALL ON SCHEMA newschema TO newuser Next, create new user and set a password for that user # CREATE USER newuser PASSWORD 'yourpassword' mo GET YOUR VPS # CREATE SCHEMA newschema The easiest way to start using PostgreSQL is to create a schema in the database called postgres, which is default. If you don’t know what to do next, you can always use the help command which will tell you exactly how to use the PostgreSQL command line interface. Once the installation is completed, you can start using the PostgreSQL 9.3 on your CentOS 6 VPS by typing the commands: # su - postgres If you like to enable PostgreSQL on system startup you can type: # chkconfig postgresql-9.3 onĪnd finally, use the following command to start the database service: # service postgresql-9.3 start Once the postgresql93-server package is installed, you need to initialize a database: # service postgresql-9.3 initdb To install a basic PostgreSQL 9.3 server use the following command: # yum install postgresql93-server If you like to list the available packages you can use the command: # yum list postgres* Next, you need to install the PGDG RPM file by using the commands:įor 32bit CentOS systems: # yum localinstall įor 64bit CentOS systems: # yum localinstall In the and sections and save the changes. You need to add the following line exclude=postgresql* Let’s start.įirst thing you need to do is to exclude the PostgreSQL in your /etc//CentOS-Base.repo. The installation of PostgreSQL is very simple and requires only few minutes to be completed. It is open source and it is designed for high volume environments.Ĭurrent stable release of PostgreSQL is 9.3 and it is community supported until. PostgreSQL is a cross-platform object-relational database management system and its primary function is to store data and retrieve it later. ![]() Today we will show you how to install PostgreSQL on a CentOS 6 VPS. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |