back up from IBSng database

[m_amini]

با سلام خدمت دوستان عزیز
من یه مشکل در back up گرفتن از دیتابیس IBSng دارم
این دستور رو برا backup گرفتن میزنم
pg_dump -U ibs -F t IBSng > /home/IBSback
برا restore هم :
pg_restore -F t -U ibs -d IBSng -c /home/IBSback
اما بعد از انجام این کار همه چیز تو IBSng به هم میریزه و دیگه user ها رو نمیتونم تو بخش admin ببینم و connect هم نمیتونن بشن!

---

موضوعات مشابه:

• Allowing Inbound L2TP/IPSec NAT Traversal Connections through a Back to Back ISA Server Firewall DMZ
• Configuring Domain Members in a Back to Back ISA Firewall DMZ
• Back up گیری از Database

---

[offers2you]

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

[Alux]

آقای نکویی اینو خودتون تست کردین؟

من قدیم با
To Restore

psql IBSng < IBSng.20070212.pg_dump
جواب نگرفتم
حالا این دومی که نوشتین رو باید تست کنم