[Spacewalk-list] Not able to take Postgres Backup
Paul Robert Marino
prmarino1 at gmail.com
Fri Sep 26 05:23:06 UTC 2014
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
More information about the Spacewalk-list
mailing list