On 10/17/06, Leonel Nunez <[EMAIL PROTECTED]> wrote:
Correction to my prior mail
do this as root :
chcon system_u:object_r:postgresql_db_t /opt/home/pgdata/mspace
When you need to know what config has any directory for SELinux
do a:
ls -lZ /your/dir
and if you need /your/otherdir t
On 10/17/06, Tom Lane <[EMAIL PROTECTED]> wrote:
To use a nondefault tablespace, you'd want to tweak the policy to allow
postgres to write that directory tree too. I'm afraid I know too little
about selinux to explain exactly what to do though ... need to learn
that someday ...
Me too...
A
On 10/17/06, Douglas McNaught <[EMAIL PROTECTED]> wrote:
"Andras Simon" <[EMAIL PROTECTED]> writes:
> I'm trying to create a new tablespace in a directory that postgres
> owns, but PG says it cannot set permissions on this directory.
...
> This is on Fedora Core 5 (x86), psql 8.1.4.
SELinu
"Andras Simon" <[EMAIL PROTECTED]> writes:
> I'm trying to create a new tablespace in a directory that postgres
> owns, but PG says it cannot set permissions on this directory.
> ...
> This is on Fedora Core 5 (x86), psql 8.1.4.
Do you have selinux enabled? The default selinux policy disallows t
> I'm trying to create a new tablespace in a directory that postgres
> owns, but PG says it cannot set permissions on this directory.
>
> [EMAIL PROTECTED] ~]# su - postgres
> -bash-3.1$ mkdir /opt/home/pgdata/mspace/
> -bash-3.1$ psql
> Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
"Andras Simon" <[EMAIL PROTECTED]> writes:
> I'm trying to create a new tablespace in a directory that postgres
> owns, but PG says it cannot set permissions on this directory.
...
> This is on Fedora Core 5 (x86), psql 8.1.4.
SELinux, most likely.
-Doug
---(end of br
I'm trying to create a new tablespace in a directory that postgres
owns, but PG says it cannot set permissions on this directory.
[EMAIL PROTECTED] ~]# su - postgres
-bash-3.1$ mkdir /opt/home/pgdata/mspace/
-bash-3.1$ psql
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
Type: \cop
