X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F05D7D1DCA5 for ; Sat, 10 Apr 2004 01:34:44 -0300 (ADT) 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 62821-06 for ; Sat, 10 Apr 2004 01:34:43 -0300 (ADT) Received: from smtp.net4india.com (unknown [202.71.129.34]) by svr1.postgresql.org (Postfix) with ESMTP id 42A3BD1DD0F for ; Sat, 10 Apr 2004 01:34:41 -0300 (ADT) Received: from [61.11.17.20] (helo=krishna) by smtp.net4india.com with smtp (Exim 3.36 #1) id 1BCAGE-0007pZ-00 for pgsql-admin@postgresql.org; Sat, 10 Apr 2004 10:08:30 +0530 Message-ID: <003d01c41eb6$54575ff0$4f0aa8c0@codecindia.com> From: "gajanan" To: Subject: Postgresql Backup & Dump Date: Sat, 10 Apr 2004 10:12:36 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0032_01C41EE4.58D2C000" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/197 X-Sequence-Number: 13170 This is a multi-part message in MIME format. ------=_NextPart_000_0032_01C41EE4.58D2C000 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, In my application I need to use old database present on postgersql at clie= nt site. For that I have created dump using pg_dump -o db_name | gzip > db_dump=20 command at the client site and then downloaded the dump on local server. B= ut when I am trying to restore, it only restore the empty database tables. = I am using following command to restore the database. /usr/local/pgsql/bin/psql db_name < db_dump=20 Client postgresql ver is 7.1 and I am using 7.4. Also the size of database = is about 600 MB.=20 Is it depends on the size or version? So what shuold be right procedure to restore the database at my server from= the remote server?=20 Where I am going wrong?=20 Thank!=20 Regard,=20 Gajanan C. ------=_NextPart_000_0032_01C41EE4.58D2C000 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,

 In my application I need to use old database present on postg= ersql=20 at client site. For that I have created dump using

     pg_dump -o db_name | gzip &= gt;=20 db_dump

command at the client  site and then downloaded the dump on local= =20 server. But when I am trying to restore, it only restore the empty database= =20 tables. I am using following command to restore the database.

     /usr/local/pgsql/bin/psql= =20 db_name < db_dump

Client postgresql ver is 7.1 and I am using 7.4. Also the size of databa= se is=20 about 600 MB.

Is it depends on the size or version?

So what shuold be right procedure to restore the database at my server f= rom=20 the remote server?

Where I am going wrong?

Thank!

Regard,

Gajanan C.

------=_NextPart_000_0032_01C41EE4.58D2C000--