[Spacewalk-list] Not able to take Postgres Backup

[Paul Robert Marino]

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
<msatheeshsalem at 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 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
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list