Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with dump importing. - Mailing list pgsql-general

From Scott Mead
Subject Re: Problem with dump importing.
Date
Msg-id d3ab2ec80912150900s6b1216c9t590e525041d8d7e1@mail.gmail.com
Whole thread Raw
In response to Problem with dump importing.  (NetLevel Admins <admins@netlevel.ru>)
List pgsql-general
Tree view
On Tue, Dec 15, 2009 at 11:34 AM, NetLevel Admins <admins@netlevel.ru> wrote:
Hello,

I created database dump on server version 8.3.7 and trying to import it to server v. 8.1.18, but i see errors.



What could be a problem and is there a solution?

  Looks like your 8.1.18 doesn't have any users in it.  You would want to run:

  pg_dumpall -g 

  Against your 8.3.7, then apply the resulting SQL to your 8.1.18 before restoring your dump file.

--Scott 

pgsql-general by date:

Previous
From: NetLevel Admins
Date:
Subject: Problem with dump importing.
Next
From: Adrian Klaver
Date:
Subject: Re: Problem with dump importing.