Alexey Bobkov <[EMAIL PROTECTED]> writes:
I have been dumping my database with next options: pg_dump -f /path_to_database/backup/db_backup.file -Z 9 database_name and get db_backup.file file.
This is giving you a plain SQL-script dump file. To restore, feed it into psql.
No :) this is giving me gzip compressed file I found solution for my problem. This is step by step instruction for me :)
mv db_backup.file db_backup.file.gz gzip -g db_backup.file.gz
:)
thanks
-- Alexey Bobkov e-Style ISP tel/fax +7 095 7969797
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html