Bandwidthd + PostgreSQL database configuration notes

I. Preparations before installation

(1) Before installation, see to learn about the installation and configuration of the Postgresql database.

(2) create a bandwidthd-pgsql account to log on to the Postgresql database

Root @ Ubuntu :~ # Su-postgres
Postgres @ ubuntu :~ $ Psql
Psql (9.1.9)
Type "help" for help.

Postgres = # create user bandwidthdpgsql;
CREATE ROLE
Postgres = # alter user bandwidthdpgsql PASSWORD '123 ';
ALTER ROLE
Postgres = # \ q
Postgres @ ubuntu :~ $ Exit
Logout
Root @ ubuntu :~ #

(3) create a database

Create database bandwidthdpgsql;

Like step (2), log on with su-postgres and execute

Note:

In Ubuntu, you do not need to use the schema. postgresql script to create a table. This is a bit different from the source code installation method. It may be that Ubuntu is fully considered.

 

Ii. Install the Bandwidthd package

Apt-get install bandwidthd-pgsql

 

For more details, please continue to read the highlights on the next page:

PostgreSQL details: click here
PostgreSQL: click here

PostgreSQL cache details

Compiling PostgreSQL on Windows

Configuration and installation of LAPP (Linux + Apache + PostgreSQL + PHP) Environment in Ubuntu

Install and configure phppgAdmin on Ubuntu

1 2 Next Page