[rt-users] How to backup/dump Postgre SQL

[Martin Petersson]

Hello,

I need to backup or dump the database to a .bak file, it´s Request Tracker 4.0.7.
Frits i tried this:
root at rt:~# pg_dump rtdb > rtdb-backup
pg_dump: [archove (db)] connection against database "rtdb" failed: FATAL:  role "root" does not exist

Then i tried:
root at rt:~# su postgres
postgres at rt:/root$ pg_dump rtdb > rtdb-backup
bash: rtdb-backup: Access denied

What do i have to do to create a backup of the database?



Martin Petersson
IT-Konsult

+46 (0)522 980 28, martin at uanet.se<mailto:martin at uanet.se>, www.uanet.se<http://www.uanet.se/>
Gustaf Mattssons Väg 2, 451 50 Uddevalla, Orgnr: 556702-4095

[cid:A93F8E95-F3FC-464A-AF04-402618F91147 at uanet.local] <http://www.uanet.se/>
<http://www.uanet.se/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20160805/52cdb21b/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logo-uanet-email.jpg
Type: image/jpeg
Size: 4419 bytes
Desc: logo-uanet-email.jpg
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20160805/52cdb21b/attachment.jpg>