From gajanan.choudhari@codecindia.com Sat Apr 10 04:34:44 2004 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-- From xzilla@users.sourceforge.net Thu Apr 15 14:32:10 2004 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 98198D1DB87 for ; Thu, 15 Apr 2004 11:32:10 -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 56924-06 for ; Thu, 15 Apr 2004 11:32:12 -0300 (ADT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id E0162D1D903 for ; Thu, 15 Apr 2004 11:32:07 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i3FEYccM030175; Thu, 15 Apr 2004 10:34:38 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i3FEVZl04320; Thu, 15 Apr 2004 10:31:36 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id FVMA9PZG; Thu, 15 Apr 2004 10:31:33 -0400 Subject: Re: Postgresql Backup & Dump From: Robert Treat To: gajanan Cc: pgsql-admin@postgresql.org In-Reply-To: <003d01c41eb6$54575ff0$4f0aa8c0@codecindia.com> References: <003d01c41eb6$54575ff0$4f0aa8c0@codecindia.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 15 Apr 2004 10:31:34 -0400 Message-Id: <1082039495.23008.821.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/230 X-Sequence-Number: 13203 On Sat, 2004-04-10 at 00:42, gajanan wrote: > Hi, > > In my application I need to use old database present on postgersql at > client site. For that I have created dump using > > pg_dump -o db_name | gzip > db_dump > > command at the client site and then downloaded the dump on local > server. But 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 > > Client postgresql ver is 7.1 and I am using 7.4. Also the size of > database is about 600 MB. > > Is it depends on the size or version? more the version than the size (especially given the relatively small size of your dump) > > So what shuold be right procedure to restore the database at my server > from the remote server? > if possible i'd recommend trying to dump the 7.1 database with the 7.4 pg_dump program. > Where I am going wrong? > i guessing that you are getting some type of error when loading your dump into the 7.4 system that your just not seeing. crank up the logging and see where it is. alternatively try dumping using insert commands as this tends to be a little more robust when dealing with problem dumps (though it will be slower) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL