From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Tauren Mills <tauren(at)servlets(dot)net> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Alternate database locations |
Date: | 2001-06-04 10:11:52 |
Message-ID: | Pine.LNX.4.30.0106041205220.768-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Tauren Mills writes:
> I've sent this to both pgsql-general and pgsql-admin. Please advise which
> is the proper list for this type of question.
-admin probably
> There also appears to be a way to create databases with an absolute path,
> but this is turned off by default for security reasons. I haven't tried
> this yet, but it looks like I'd have to recompile with different settings
> for ALLOW_ABSOLUTE_DBPATHS.
> However, this page indicates that there are security risks in doing this.
> What are those risks? If I prevent users other than the superuser
> "postgres" from being able to create and drop databases, are there any
> security risks?
No. The risks are related to the fact that non-superusers can also be
allowed to create databases.
> Lastly, I've even tried creating a database normally, then moving it to the
> user's area and creating a symlink to it. But this didn't seem to work.
It should, since that is what the "official" mechanisms do as well.
> * Is there an easy way to map database directories in the file system to
> database names? The directories names in /var/lib/pgsql/data/base/ are not
> very helpful.
In 7.1 and later, there is one database per directory and the directories
are named $PGDATA/base/<oid>, where <oid> is the oid of the pg_database
entry.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-06-04 14:15:04 | Re: Alternate database locations |
Previous Message | Tauren Mills | 2001-06-04 09:16:55 | Alternate database locations |
From | Date | Subject | |
---|---|---|---|
Next Message | Martín Marqués | 2001-06-04 10:31:22 | Re: datestyle |
Previous Message | Martín Marqués | 2001-06-04 09:54:56 | Re: datestyle |