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: [email protected]
[mailto:[email protected]] On Behalf Of satheesh murugesan
Sent: Friday, 26 September 2014 6:18 AM
To: [email protected]
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@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
________________________________
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
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
