<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div>
<blockquote type="cite" class="">
<div class="">On Aug 5, 2016, at 4:05 AM, Martin Petersson <<a href="mailto:martin@uanet.se" class="">martin@uanet.se</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
Hello,
<div class=""><br class="">
</div>
<div class="">I need to backup or dump the database to a .bak file, it´s Request Tracker 4.0.7.</div>
<div class="">Frits i tried this:</div>
<div class="">
<div class="">root@rt:~# pg_dump rtdb > rtdb-backup</div>
<div class="">pg_dump: [archove (db)] connection against database "rtdb" failed: FATAL: role "root" does not exist</div>
<div class=""><br class="webkit-block-placeholder">
</div>
<div class="">
<div class="">Then i tried:</div>
<div class="">
<div class="">root@rt:~# su postgres </div>
<div class="">postgres@rt:/root$ pg_dump rtdb > rtdb-backup</div>
<div class="">bash: rtdb-backup: Access denied</div>
<div class=""><br class="">
</div>
<div class="">What do i have to do to create a backup of the database?</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<div><br class="">
</div>
</div>
Use 'su - postgres' instead to become postgres instead of just get the permissions of postgres. If that doesn't work because it doesn't have a shell try sudo but ultimately you need to be in a place you can write to while having the permissions of postgres
or specify the location in the redirect.
<div class=""><br class="">
</div>
<div class="">eg:</div>
<div class=""># su postgres</div>
<div class="">$ pg_dump rtdb -> /tmp/rtdb-backup</div>
<div class=""><br class="">
<div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="orphans: auto; text-align: start; text-indent: 0px; widows: auto; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="orphans: auto; text-align: start; text-indent: 0px; widows: auto; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="orphans: auto; text-align: start; text-indent: 0px; widows: auto; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="margin-top: 0px; margin-bottom: 0px;" class="">
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><span style="font-family: Arial;" class="">--</span></div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><span style="font-family: Arial;" class="">Landon Stewart</span></div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><font face="Arial" class="">Lead Analyst - Abuse and Security Management<br class="">
</font><b class=""><i class=""><span style="font-family: 'Arial Black';" class="">INTERNAP</span></i></b><span style="font-family: Arial;" class=""><span class="Apple-converted-space"> </span><sup class="">®</sup></span></div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">📧 <a href="mailto:lstewart@internap.com" class="">lstewart@internap.com</a></div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">🌍 <a href="http://www.internap.com" class="">www.internap.com</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br class="">
</div>
</body>
</html>