Experience the PostgreSQL database at the beginning of OpenWrt

2. Requirements

   Make sure that you have the following commands in your router shell

   AddUser, Deluser, AddGroup, Delgroup, Su.

   also need to be familiar with Su,chown, opkg, mkdir, service operation and other commands

4. Install the required packages

   #opkg Update

   #opkg Install Pgsql-server PGSQL-CLI

6. #uci set Postgresql.config.pgdata=/srv/postgresql/data

   #uci set Postgresql.config.pglog=/srv/postgresql/data/postgresql.log

   #uci commit

8. Initializing the database

   #mkdir-P/srv/postgresql/data

   #chown Postgres/srv/postgresql/data

   #su Postgres

   $LC _collate= "C" Initdb--pwprompt-d/srv/postgresql/data

   The size of the space is a bit high when initializing the database

10. Run the database service and boot up

    #/etc/init.d/postgresql start

    #/etc/init.d/postgresql Enable

12. < Span style= "font-family: the song Body;" > Note: When installing the second step package, the postgres user, this user is PostgreSQL Admin user