-
Notifications
You must be signed in to change notification settings - Fork 9
/
QUICKSTART.postgres
59 lines (34 loc) · 1.72 KB
/
QUICKSTART.postgres
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
Quickstart instructions for MyDNS (PostgreSQL installation):
...............................................................................
1. Configure and install MyDNS.
$ ./configure
$ make
# make install
...............................................................................
2. Create a database called `mydns' on your PostgreSQL server.
# su - postgres
$ createdb mydns
...............................................................................
3. Create the tables in the `mydns' database.
$ /usr/local/sbin/mydns --create-tables | psql mydns
...............................................................................
4. Create a user the mydns(8) server can use to access the `mydns' database.
$ psql mydns
mydns=# CREATE USER "<user>" PASSWORD '<password>';
mydns=# GRANT SELECT ON soa,soa_id_seq TO "<user>";
mydns=# GRANT SELECT ON rr,rr_id_seq TO "<user>";
...............................................................................
5. Create your configuration file.
# make conf
...............................................................................
6. Edit the configuration file. Change the `db-user' and `db-pass'
values to reflect the user name and password you created in step 3.
...............................................................................
7. Start `mydns'. You may want to add something like this to your startup
scripts.
# mydns --background
...............................................................................
If you currently have a name server running BIND or something else, you can use
the `mydnsimport' program to import the data from that server into your new
MyDNS database. See the user's manual for details.
## vi:set ts=3: