Starting the database server: As root.This task if it has not already been performed. Red Hat start command ( service)/script (rc script) will perform The postgres configuration in the user directory /var/lib/pgsql/. This creates a bunch of directories, a template directory and sets up Initialize PostgreSQL database server: initdb -pgdata=/var/lib/pgsql/data.This will execute the profile: /var/lib/pgsql/.bash_profile As root issue the command: passwd postgres The user " postgres" should have already been configured by theĪ password will be missing. Once the database initialization has occurred, one can then start the database (as root): service postgresql restart To initialize the system for the first run (as root): service postgresql initdb Initializing database: Use "service postgresql initdb" to initialize the cluster first. The first time this is run you will get the following error: Starting the database (as root): service postgresql start postgresql-devel - C language connectivity.postgresql-plpython - Python connectivity.postgresql-docs-8.4.11-1.el6_2.x86_64 - tutorials, examples and a monster PDF manual.postgresql-libs-8.4.11-1.el6_2.x86_64 - libraries and locale based messages.postgresql-server-8.4.11-1.el6_2.x86_64 - DB server and locale based messages.postgresql-8.4.11-1.el6_2.x86_64 - commands, HTML docs and man pages.Starting the database: sudo service postgresql start postgresql-client-common - utility programs and man pages.postgresql-client-9.X - utility programs and man pages.postgresql-common - the database program.Ubuntu: (16.04, 14.04) Install: sudo apt-get install postgresql The PostgreSQL Database - Installation and Configuration: Extensive geospatial support (PostgreSQL is a leader in mapping and geospatial applications).Supports a procedural language (PL/pgSQL, PL/Tcl, PL/Perl, PL/Python) to allow for processing within the database architecture.Tables are identified by unique names and hold data in a row and column (record) structure.Ī fixed number of named columns are defined for a table with a variable number of rows.Ĭharacteristics favoring the PostgreSQL Database: The SQL language is also used for the administration of the database for the creation and modification of tables, users and access privileges. The interface language of the PostgreSQL database is the standard SQL (Standard Query Language) which allows for inserts, updates and queries of data stored in relational tables. This tutorial will also cover the generation and use a simple database. This tutorial covers the installation and use of the PostgreSQL database on Linux YoLinux Tutorial: The PostgreSQL Database and Linux
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |