This will adds a new role to a PostgreSQL database cluster. Creating New Roles and DatabaseĪ role is an user, group or both that can own database objects and have database privileges. Now, You can exit from psql console by using \q and then exit command to logout from PostgreSQL. Then get into the PostgreSQL console using the command pgsql psql Switch to the PostgreSQL user by following the commands : Also, We can only access the database by switching to that user postgres. Accessing the Databaseīy default, a user and a database named postgres will be created during the installation. Now, We can check accessing the database. Thus we can confirm that the PostgreSQL is properly installed and running. We can also check its status by the following commands : This will provide you an output like the one below : Now we can confirm the installation using some commands. Processing triggers for systemd (215-17+deb8u2). Processing triggers for libc-bin (2.19-18+deb8u1). Update-alternatives: using /usr/share/postgresql/9.4/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode It will be like the one below.Ĭreating config file /etc/postgresql-common/nf with new versionĬreating config file /etc/logrotate.d/postgresql-common with new versionīuilding PostgreSQL dictionaries from installed myspell/hunspell packages. # apt-get install postgresql-9.4 postgresql-client-9.4Īt the end of the installation, you will get the information of configuration files, ports and further details. Now, Install PostgreSQL packages using apt-get : You will see a message like the one below which means all the packages are been updated : So we need to update the system with the latest updates. Here, We are going to install the PostgreSQL version. In this article, We are going to install PostgreSQL and give you some introduction. If you have a freshly installed debian 8 server with root access you are ready to install PostgreSQL 9.4. It supports a large number of data types.It is highly programmable as well as extendible.It is very easy to store and retrieve information using SQL commands in PostgreSQL. It is also used for many content management scripts. These programming languages make is extremely easy to connect to a PostgreSQL database. It is used by several web programming languages including PHP, and Python. Commonly supported objects include views, stored procedures, indexes, triggers and object-defined data types. It supports almost all relational database features and offers a few unusual features that are normally absent in other RDBMS engines. It is developed by a group of companies and some individuals. PostgreSQL pronounced as “post-gress-Q-L” is a free and open source object-relational database management system.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |