TODO 1.27 KB
Newer Older
Oliver Elphick's avatar
Oliver Elphick committed
1 2 3
postgresql TODO
===============

4
Bugs:
Martin Pitt's avatar
Martin Pitt committed
5 6 7
- pg_createcluster with existing cluster: respect symlinks to shared
  postgresql.conf files, never remove symlinks in already existing
  cluster dirs
Martin Pitt's avatar
Martin Pitt committed
8
- Clean up at purging if /etc/ is there without /var, or vice versa
9

Martin Pitt's avatar
Martin Pitt committed
10
Transition bugs:
Martin Pitt's avatar
Martin Pitt committed
11 12

Missing selftest:
13
- --force option for pg_ctlcluster
Martin Pitt's avatar
Martin Pitt committed
14

15 16 17
Important features:

Wishlist:
Martin Pitt's avatar
Martin Pitt committed
18
- Add pg_conf to change startup and possibly other things
19
- add program for web applications, which configure pg_hba.conf:
20

21
  pg_hba add|remove|test [options] yourwebappdb yourwebappuser
22 23 24 25 26 27

  Options:

  --cluster: self-explanatory, defaults to default cluster
  --ip: IP and netmask for host socket; if not given, defaults to Unix
    socket (local)
Martin Pitt's avatar
Martin Pitt committed
28
  --method: defaults to "md5" for TCP connections, and "ident sameuser" for
29 30 31 32
    Unix socket connections
  --force-ssl: If given, create a "hostssl" entry, otherwise a "host"
    entry

33 34
  For remove, only --cluster is allowed; it will remove all hba
  entries that refer to the given db/user pair. test checks whether the
Martin Pitt's avatar
Martin Pitt committed
35 36 37
  given connection is allowed; if so, it exits with 0, otherwise it prints the
  required pg_hba.conf line to stdout and exits with 1. If pg_hba.conf has a
  scrambled format that cannot be parsed by pg_*_hba, the scripts exit with 2.
Martin Pitt's avatar
Martin Pitt committed
38

Martin Pitt's avatar
Martin Pitt committed
39
  Add libnet-cidr-perl dependency!