Search Postgresql Archives

Re: Moving pg_xlog to another drive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ben wrote:
> I'm trying to move my WAL to another drive, but am having difficulties 
> with this seemingly simple process. Every time I start up with pg_xlog 
> symlinked to my other drive, I get this:
> 
> FATAL:  could not open file "pg_xlog/00000001.history": Permission denied
> 
> If I move pg_xlog back into its normal place then things work fine. The 
> postgres user can certainly create files when using the symlink, so I 
> really don't think it's a permission issue... but I'm at a loss as to what 
> else it might be.

Maybe the postgres user does not have all permissions in dirs leading to
the new directory?  You must give it at least "x" permissions on all
levels up to the parent.

-- 
Alvaro Herrera                         http://www.flickr.com/photos/alvherre/
Criptografía: Poderosa técnica algorítmica de codificación que es
empleada en la creación de manuales de computadores.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux