<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Is postgres running?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">“</span>pg_dumpall: could not connect to database "template1": could not connect to serv
er: No such file or directory<o:p></o:p></p>
<p class="MsoNormal"> Is the server running locally and accepting<o:p></o:p></p>
<p class="MsoNormal"> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?<o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">“<o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com]
<b>On Behalf Of </b>satheesh murugesan<br>
<b>Sent:</b> Friday, 26 September 2014 6:18 AM<br>
<b>To:</b> spacewalk-list@redhat.com<br>
<b>Subject:</b> [Spacewalk-list] Not able to take Postgres Backup<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Dear All,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Please help me to solve the issue.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I have installed spacewalk in centos 6.5 64 bit version<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Spacewalk version :- 2.2 <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Postrgress database :- postgres (PostgreSQL) 8.4.20<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Installed spacewalk with embedded database.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">While Backing up the database getting the error.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">************************************************************************************************<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">WHILE DOING BACKUP IN OFFLINE MODE OF THE SPACEWALK SERVICE GETTING THIS ERROR <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">[root@spacewalk ~]# spacewalk-service stop<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Shutting down spacewalk services...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping RHN Taskomatic...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopped RHN Taskomatic.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping cobbler daemon: [ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping rhn-search...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopped rhn-search.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping MonitoringScout ...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">[ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping Monitoring ...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">[ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Shutting down osa-dispatcher: [ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping httpd: [ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping tomcat6: [ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Terminating jabberd processes ...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping s2s: [ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping c2s: [ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping sm: [ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping router: [ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stopping postgresql service: [ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Done.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">[root@spacewalk ~]# su - postgres -c 'pg_dumpall > /var/lib/pgsql/backups/full_ postgres_backup-`date +%Y%m%d`.sql'<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">pg_dumpall: could not connect to database "template1": could not connect to serv er: No such file or directory<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Is the server running locally and accepting<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">*********************************************************************************************<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">WHILE DOING BACKUP IN SPACEWALK ONLINE MODE <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">[root@spacewalk ~]# spacewalk-service status<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">postmaster (pid 2625) is running...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">router (pid 2643) is running...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">sm (pid 2650) is running...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">c2s (pid 2657) is running...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">s2s (pid 2664) is running...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">tomcat6 (pid 2734) is running... [ OK ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">httpd (pid 2881) is running...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">osa-dispatcher (pid 2897) is running...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">rhn-search is running (2947).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">cobblerd (pid 2981) is running...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">RHN Taskomatic is running (3005).<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">[root@spacewalk ~]# su - postgres -c 'pg_dumpall > /var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql'<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">pg_dump: [archiver (db)] connection to database "template1" failed: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">pg_dumpall: pg_dump failed on database "template1", exiting<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Regards,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Satheesh Kumar<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <br>
With Regards<br>
Satheesh<o:p></o:p></p>
</div>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Black" size="2">This email (including any attachments) may contain confidential and/or legally privileged information and is intended only to be read or used by the addressee(s). If you have received this email in error, please notify
the sender by return email, delete this email and destroy any copy. Any use, distribution, disclosure or copying of this email by a person who is not the intended recipient is not authorised.<br>
<br>
Views expressed in this email are those of the individual sender, and are not necessarily the views of Transport for NSW, Department of Transport or any other NSW government agency. Transport for NSW and the Department of Transport assume no liability for any
loss, damage or other consequence which may arise from opening or using an email or attachment.<br>
Please visit us at http://www.transport.nsw.gov.au or http://www.transportnsw.info<br>
</font>
</body>
</html>