Then a try to restore my data: pg_restore /path_to_database/backup/db_backup.file and get next error pg_restore: [archiver] input file does not appear to be a valid archive
Use psql instead with command
psql -U username databasename -f yourdb_file.sql
Yes you will have to edit the file a bit.
Drawbacks are :
triggers will go of on all insert and will be stumbling block in case to dump you may use the following command in future
pg_dump --disable-triggers -U <user_name> -a -d -b -D -Fc -Z 9 -f <filername.tar.gz> <dbname>
and to restore use
pg_restore --disable-triggers -U <user_name> -d <dbname> <backupfilename.tar.gz>
Regards, Vishal Kashyap
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
