[Spacewalk-list] Not able to take Postgres Backup

[Reed, Steven]

Is postgres running?

“pg_dumpall: could not connect to database "template1": could not connect to serv                                                                                        er: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
“
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of satheesh murugesan
Sent: Friday, 26 September 2014 6:18 AM
To: spacewalk-list at redhat.com
Subject: [Spacewalk-list] Not able to take Postgres Backup

Dear All,

Please help me to solve the issue.

I have installed spacewalk in centos 6.5  64 bit version

Spacewalk version :- 2.2

Postrgress database :- postgres (PostgreSQL) 8.4.20

Installed spacewalk with embedded database.

While Backing up the database getting the error.

************************************************************************************************
WHILE DOING BACKUP IN OFFLINE MODE OF THE SPACEWALK SERVICE GETTING THIS ERROR

[root at spacewalk ~]# spacewalk-service stop
Shutting down spacewalk services...
Stopping RHN Taskomatic...
Stopped RHN Taskomatic.
Stopping cobbler daemon:                                   [  OK  ]
Stopping rhn-search...
Stopped rhn-search.
Stopping MonitoringScout ...
[ OK ]
Stopping Monitoring ...
[ OK ]
Shutting down osa-dispatcher:                              [  OK  ]
Stopping httpd:                                            [  OK  ]
Stopping tomcat6:                                          [  OK  ]
Terminating jabberd processes ...
Stopping s2s:                                              [  OK  ]
Stopping c2s:                                              [  OK  ]
Stopping sm:                                               [  OK  ]
Stopping router:                                           [  OK  ]
Stopping postgresql service:                               [  OK  ]
Done.
[root at spacewalk ~]# su - postgres -c  'pg_dumpall > /var/lib/pgsql/backups/full_                                                                                        postgres_backup-`date +%Y%m%d`.sql'
pg_dumpall: could not connect to database "template1": could not connect to serv                                                                                        er: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


*********************************************************************************************
WHILE DOING BACKUP IN SPACEWALK ONLINE MODE

[root at spacewalk ~]# spacewalk-service status
postmaster (pid  2625) is running...
router (pid 2643) is running...
sm (pid 2650) is running...
c2s (pid 2657) is running...
s2s (pid 2664) is running...
tomcat6 (pid 2734) is running...                           [  OK  ]
httpd (pid  2881) is running...
osa-dispatcher (pid  2897) is running...
rhn-search is running (2947).
cobblerd (pid 2981) is running...
RHN Taskomatic is running (3005).

[root at spacewalk ~]# su - postgres -c  'pg_dumpall > /var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql'
pg_dump: [archiver (db)] connection to database "template1" failed: FATAL:  no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off
pg_dumpall: pg_dump failed on database "template1", exiting


Regards,
Satheesh Kumar


--
With Regards
  Satheesh

________________________________
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.

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.
Please visit us at http://www.transport.nsw.gov.au or http://www.transportnsw.info
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140926/9b5c1757/attachment.htm>