step 2 and 3 only has to be done once 1. login to postgres user: sudo su - postgres 2. create a password file: echo "*:*:bardb:foouser:mypassword" > .pgpass 3. set the necessary permission to be take: chmod 600 .pgpass 4. backup your db: pg_dump -h 127.0.0.1 -U foouser bardb -f bardb.sql

http://www.thegeekstuff.com/2009/01/how-to-backup-and-restore-postgres-database-using-pg_dump-and-psql/

to restore use: 1. login to the postgres user: sudo su - postgres 2. import : psql -h 127.0.0.1 -U foouser bardb -f bardb.sql 16.03.16

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024