[Spacewalk-list] Not able to take Postgres Backup

[satheesh murugesan]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140926/6fca4851/attachment.htm>