the reason is simple "Stopping postgresql service: [ OK ]" PostgreSQL isnt running so you cant connect to it
On Thu, Sep 25, 2014 at 4:17 PM, satheesh murugesan <msatheeshsa...@gmail.com> wrote: > 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@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@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@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@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 > > _______________________________________________ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list