Dear Tom,
Thanks for your reply and insight! I much appreciate it. I certainly look
forward to getting off FC6! In the meantime, I did get it to work -
I remembered SELinux protects /home directories especially.
So I moved "postgres" user's home directory from /home/postgres
to /data/postgres
Aleksey Tsalolikhin writes:
> On Tue, Mar 31, 2009 at 6:35 PM, David Wilson
> wrote:
>> Have you tested "ssh node2" as the postgres user with SELinux enabled?
> Yes, I have, it works fine. With SELinux enabled. That's why I've
> been tearing my hair out.
Ah, well, you need to understand one
On Tue, Mar 31, 2009 at 6:35 PM, David Wilson wrote:
> On Tue, Mar 31, 2009 at 9:18 PM, Aleksey Tsalolikhin
> wrote:
>
>> Could not create directory '/home/postgres/.ssh'.
>> Host key verification failed.
>
> Have you tested "ssh node2" as the postgres user with SELinux enabled?
Yes, I have, it
On Tue, Mar 31, 2009 at 9:18 PM, Aleksey Tsalolikhin
wrote:
> Could not create directory '/home/postgres/.ssh'.
> Host key verification failed.
Have you tested "ssh node2" as the postgres user with SELinux enabled?
This looks like ssh failing to access the .ssh directory where it
keeps host keys
Ok, this is not strictly a PostgreSQL issue,
but I am trying to enable WAL log shipping on our PostgreSQL 8.1.10
(upgrade to 8.3.7 is in the works).
My archive_command is 'rsync %p postg...@node2:/file/to/$f http://www.verticalsysadmin.com/
LinkedIn - http://www.linkedin.com/in/atsaloli
--
Sent