1) Go to scm server database
[nitin@nitin-ubuntu:~] # cd
/var/lib/cloudera-scm-server-db/data
2) check file generated_password.txt .
This file is cerated by cloudera manager
[nitin@nitin-ubuntu:~] # cat
generated_password.txt
8UlBunj0MM
The password above was generated by
/usr/share/cmf/bin/initialize_embedded_db.sh (part of the
cloudera-manager-server-db package)
and is the password for the user
'cloudera-scm' for the database in the current directory.
Generated at 20140128-230553.
3) Login to PostgreSQL with password from
above file that is 8UlBunj0MM
[nitin@nitin-ubuntu:~] # psql --user
cloudera-scm --port=7432 –dbname=postgres
Password for user
cloudera-scm:************
postgres=# \q
Note :- Make sure you give exact
username and password
4) Take A dump
[nitin@nitin-ubuntu:~] # pg_dump hive
-U cloudera-scm --port=7432 > hive.sql
Password:********
5) Its Done.
Hi Nitin,
ReplyDeleteMy simple problem is how will u take up the backup of hive database and restore it back in Cloudera ?
Yes i am totally agreed with this article and i just want say that this article is very nice and very informative article.I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!Thanks PostgreSQL NULL value
ReplyDelete