summaryrefslogtreecommitdiff
path: root/README.postgresql
blob: a3ea3683a0217cb5ab8bd0f5c7bc5187c9064c42 (plain)
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
60
61
62
63
64
65
66
67
/*! \mainpage Muggle: Usage with postgresql

This is a plugin for the Video Disk Recorder (VDR).

Written by:                  Andi Kellner,
                             Lars von Wedel <vonwedel@web.de>,
                             Ralf Klueber <r@lf-klueber.de>, 
                             Wolfgang Rohdewald <wolfgang@rohdewald.de>

Project's homepage:          http://sourceforge.net/projects/vdr-muggle

Latest version available at: http://sourceforge.net/projects/vdr-muggle

See the file COPYING for license information.

\section prereq PREREQUISITES

You will need:

 - postgresql client libraries: Debian package postgresql-client
 - postgresql server, possibly on another machine: Debian package postgresql
 - postgresql-dev for the compilation

Please execute these steps before starting muggle the first time:
(tested on Debian unstable)

1. log in as root
2. su - postgres
3. createuser XXX
4. createdb GiantDisc

where XXX is the user name vdr is running under, normally vdr

Everything else will be done by muggle.

\section install INSTALLING 

Adapt the Makefile or Make.config to your system. Define HAVE_PG

HAVE_PG=1


\section SET UP MUGGLE WITH POSTGRESQL

Muggle and mugglei use a small set of parameters in order to control
the interaction with the Postgresql server. Let's look at an example:

\verbatim
  -P'muggle -s /tmp -t/home/music'
\endverbatim

The -s parameter says to look for a socket in /tmp (this is what I
had to to on Debian unstable). 

On the other hand on my kubuntu 7.10 notebook I don't need any
additional arguments at all:

\verbatim
  -P'muggle -t/home/music'
\endverbatim


Starting mugglei without arguments to see a list and explanation of
all available options. They can vary slightly depending on the
chosen data base software.

*/