<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=infos@e-blokos.com href="mailto:infos@e-blokos.com">E-Blokos</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=pacemaker@clusterlabs.org
href="mailto:pacemaker@clusterlabs.org">pacemaker@clusterlabs.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, September 20, 2009 1:22
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> postgresql RA problem
[SOLVED]</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2 face=Arial>For whos are interested to have more password
security with Postgresql</FONT></DIV>
<DIV><FONT size=2 face=Arial>until now the RA didn't work if db user in
pg_hba.conf was set on other than "trust",</FONT></DIV>
<DIV><FONT size=2 face=Arial>otherwise psql command always ask password
prompt, which break the RA script.</FONT></DIV>
<DIV><FONT size=2 face=Arial>So I updated the PGSQL RA to use pgsql with more
security.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>Regards</FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>Franck Chionna</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2> also don't forget to use the var
"logfile" other than /dev/null (as it's set by default on
pacemaker-gui)</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial>with write permission of dba user, if not the RA
will fail too.</FONT></DIV></BLOCKQUOTE><br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.
</BODY></HTML>