to Backup
pg_dump -hYourDBServer -u IBSng > IBSng.20070212.pg_dump
To Restore
psql IBSng < IBSng.20070212.pg_dump
Or This one :
To Backup
pg_dump -U YourDBServer -W IBSng -U ibs > /tmp/IBSngbackup.sql
enter password
the command will generate a file called /tmp/IBSngbackup.sql
Restore :
recreate the IBSng (or use another name) database following the standard procedure:
su - postgres
psql template1 YourDBServer
create database IBSng with encoding='UNICODE';
\c IBSng YourDBServer
\i /tmp/IBSngbackup.sql
you may see too many errors called the 'already exist' msgs ... all the existing values will be ignore and your values will create on the specified places ...
this is backup/restore outputs on localhost :
[morteza@localhost ~]$ su -
Password:
[root@localhost ~]# pg_dump -W IBSng -U ibs > /tmp/IBSngbackup.sql
Password:
You have new mail in /var/spool/mail/root
[root@localhost ~]# su - postgres
-bash-3.00$ psql template1
Welcome to psql 8.0.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
template1=# \c IBSng
You are now connected to database "IBSng".
IBSng=# /i /tmp/IBSngbackup.sql
<here will show too many errors> be patient
all things are okay !
IBSng-# \q
-bash-3.00$ exit
logout
You have new mail in /var/spool/mail/root
[root@localhost ~]#
Have fun
پاسخ : چطور از IBSng بک آپ بگیریم؟
