Re: Reg:import issue in PostgresSQL server

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Vipul Kumar Singh02 <Vipul_Singh02(at)infosys(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Reg:import issue in PostgresSQL server
Date: 2011-05-21 23:10:55
Message-ID: 4DD8467F.3040705@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Le 05/19/2011 02:27 PM, Vipul Kumar Singh02 a écrit :
> [...]
> A Data dump from a PostgresSQL server was created using Postgres Version (PostgreSQL 7.4.1 on i386-unknown-freebsd5.3, compiled by GCC gcc (GCC) 3.4.2 [FreeBSD] 20040728).
>
> Now i am trying to import into PostgreSQL Server 4.8(Operating System - Windows 7) with GUI, but gui is not able to recognized the dump file .
>

Which GUI? if it's pgAdmin and you took a plain dump, that's true,
pgAdmin won't be able to restore it. You'll need to use psql.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Craig James 2011-05-22 01:27:47 Re: Who is causing all this i/o?
Previous Message Tom Lane 2011-05-21 15:16:09 Re: ERROR: could not read block