Search this site
    Home page‎ > ‎NAS4Free‎ > ‎

    Install PostgreSQL on Nas4Free (Freenas7.x)

    Important!  Must strictly comply with the procedure specified in the manual. Step-by-Step.
    1. Create holding folder for PostgreSQL. I want put it into non-system disk, mount point called data

    # mkdir -p /mnt/data/db/pgsql

    # chmod 777 /mnt/data/db

    # ln -s /mnt/data/db/pgsql /usr/local/pgsql

    2. Create the group and user 'pgsql' using the FreeNAS WebGUI, it is important
    pgsql   Group   like    GID 70

    pgsql   User     like    UID 70

    Important! Home directory for user pgsql must be created in step1 - /mnt/data/db/pgsql


             # chown pgsql:pgsql /mnt/data/db/pgsql

    3. Type the following command to install PostgreSQL server:

    # pkg_add -r postgresql84-server

    It is useful to read what to write computer programs after the installation,but I was still satisfied with the default settings.

    4.   To run PostgreSQL at startup, add 'postgresql_enable="YES"' to /etc/rc.conf

    echo 'postgresql_enable="YES"' >> /etc/rc.conf

    5. Create initial database

    # /usr/local/etc/rc.d/postgresql initdb

    The files belonging to this database system will be owned by user "pgsql". This user must also own the server process.

    6. Create database user and test installed software. PostgreSQL must be start from user pgsql, then

      # su pgsql
    $ /usr/local/bin/postgres -D /usr/local/pgsql/data

    Check in  Freenas webgui Status|Processes  pgsql - daemon

    Create user for postgresql

    $ createuser -sdrP

    Enter name of role to add: username (may be name as admin freenas )

    Enter password for new role: *****

    Enter it again: ****

    $ exit
    7. If all goes well then

    # reboot