File: pmacct-create-db.pgsql

package info (click to toggle)
pmacct 0.14.0-1.1
  • links: PTS
  • area: main
  • in suites: wheezy
  • size: 3,996 kB
  • sloc: ansic: 60,798; sh: 636; makefile: 286
file content (14 lines) | stat: -rwxr-xr-x 407 bytes parent folder | download | duplicates (13) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
--
-- # su - postgres  (or whatever your database runs as ... usually postgres)
-- $ psql -d template1 -f pmacct-create-db.pgsql 
--
-- NOTE: you should have a line like "local  all password" in your pg_hba.conf
--       to authenticate local users against Postgres userbase passwords.
--

DROP DATABASE pmacct;
CREATE DATABASE pmacct;

CREATE USER pmacct;
ALTER USER pmacct WITH PASSWORD 'arealsmartpwd';