File: pmacct-create-db.pgsql

package info (click to toggle)
pmacct 1.7.8-4
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 11,904 kB
  • sloc: ansic: 110,430; sh: 4,794; cpp: 4,375; python: 3,632; makefile: 525
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';