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

Thank you all very much. This one did the trick. su - postgres A little dash in between :) Skickat fr?n min ? iPhone 5 aug. 2016 kl. 21:13 skrev Landon Stewart >: eg: # su postgres $ pg_dump rtdb -> /tmp/rtdb-backup OOPS # su postgres $

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

--- Begin Message --- > On Aug 5, 2016, at 7:05 AM, Martin Petersson wrote: > > 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@rt:~# pg_dump rtdb > rtdb-backup > pg_dump: [archove (db)] connection

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

eg: # su postgres $ pg_dump rtdb -> /tmp/rtdb-backup OOPS # su postgres $ pg_dump rtdb > /tmp/rtdb-backup -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ®  lstew...@internap.com  www.internap.com - RT 4.4

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

On Aug 5, 2016, at 4:05 AM, Martin Petersson > wrote: 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@rt:~# pg_dump rtdb > rtdb-backup pg_dump: [archove (db)] connection against database

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

On Fri, Aug 5, 2016 at 7:05 AM, Martin Petersson wrote: > Then i tried: > root@rt:~# su postgres > postgres@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? > Not be in roots home directory when

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

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@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@rt:~# su postgres