As a newbie, I write this tips, as I did earlier. It work on my postgtre sql.
DUMP DATA
============================
| DUMP DATA |
============================
pg_dump -U userName -d db_bonus > db_bonus.sql
—1—–2—3——4—-5——–6–
1. pg_dump= function from postgresql
2. -U = Option for Username in data base
3. userName= username, use your active user on postgresql
4. -d = Option for dump database
5. db_bonus= here my database name is db_bonus
6. db_bonus.sql = filename, as result from dump
============================
| RESTORE DATA |
============================
psql -U bonususr -d db_bonus -f backup_3.sql
1—2—3——4—5——6—-7—-
1. psql= function from postgreSql
2. -U = Option for Username in data base
3. userName= username, use your active user on postgresql
4. -d = option for database
5. db_bonus= here my database name is db_bonus
6. -f = from file
7. backup_3.sql = file name. Ypu may locate your filename fro its path, eg. /home/angus/backup_3.sql
note:
I am using PostgreSQL 8.1.11. Runing on linux Ubuntu
psql only works smoothly with servers of the same version. That does
not mean other combinations will fail outright, but subtle and not-
so-subtle problems might come up. Backslash commands are particularly
likely to fail if the server is of a different version.
regards,
tolahtoleh™
