X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0CB2BD1D541 for ; Mon, 12 Jan 2004 14:47:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 76134-02 for ; Mon, 12 Jan 2004 10:46:59 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 1DC75D1D542 for ; Mon, 12 Jan 2004 10:46:55 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id i0CEkw19028376; Mon, 12 Jan 2004 09:46:59 -0500 (EST) To: Alexey Bobkov Cc: pgsql-admin@postgresql.org Subject: Re: pg_dump/pg_restore In-reply-to: <400288CC.4050005@sunet.ru> References: <400288CC.4050005@sunet.ru> Comments: In-reply-to Alexey Bobkov message dated "Mon, 12 Jan 2004 14:45:16 +0300" Date: Mon, 12 Jan 2004 09:46:58 -0500 Message-ID: <28375.1073918818@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/85 X-Sequence-Number: 11948 Alexey Bobkov 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. regards, tom lane