pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Migration from 7.4.2 to 8.1.4
4+ messages / 3 participants
[nested] [flat]

* Migration from 7.4.2 to 8.1.4
@ 2006-08-21 09:43  Gallai János <gallaij@mediagnost.hu>
  0 siblings, 2 replies; 4+ messages in thread

From: Gallai János @ 2006-08-21 09:43 UTC (permalink / raw)
  To: pgsql-admin

Hi!

I'm an administrator of a big company who has a PgSQL-database version 7.4.2. We would like to upgrade it to 8.1.4 but the dump we made cannot be restored. We got a lot of error messages while restoring database related on something's being restored before other objects would exists. ( ??? ) We have made some changes in the dump reversing creation processes and it seems to be useful but there's a lot of error messages on the same problem and do not have time to do them all by hand.

We need help to convert this dump for us ( I can provide binary data if needed )  to be able use it with the new system. We would pay this conversion.

Thanks in advance,

John Gallai,
System administrator
Mediagnost Ltd,
Budapest,
Hungary

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Migration from 7.4.2 to 8.1.4
@ 2006-08-21 12:40  Michael Fuhr <mike@fuhr.org>
  parent: Gallai János <gallaij@mediagnost.hu>
  1 sibling, 1 reply; 4+ messages in thread

From: Michael Fuhr @ 2006-08-21 12:40 UTC (permalink / raw)
  To: Gallai János <gallaij@mediagnost.hu>; +Cc: pgsql-admin

On Mon, Aug 21, 2006 at 11:43:28AM +0200, Gallai János wrote:
> I'm an administrator of a big company who has a PgSQL-database
> version 7.4.2. We would like to upgrade it to 8.1.4 but the dump
> we made cannot be restored.

Which version of pg_dump/pg_dumpall did you use?  When upgrading
use the newer version (i.e., use 8.1.4's pg_dump against the 7.4.2
database).

-- 
Michael Fuhr



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Migration from 7.4.2 to 8.1.4
@ 2006-08-21 12:47  Peter Eisentraut <peter_e@gmx.net>
  parent: Gallai János <gallaij@mediagnost.hu>
  1 sibling, 0 replies; 4+ messages in thread

From: Peter Eisentraut @ 2006-08-21 12:47 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Gallai János <gallaij@mediagnost.hu>

Am Montag, 21. August 2006 11:43 schrieb Gallai János:
> I'm an administrator of a big company who has a PgSQL-database version
> 7.4.2. We would like to upgrade it to 8.1.4 but the dump we made cannot be
> restored. We got a lot of error messages while restoring database related
> on something's being restored before other objects would exists.

You should have more success if you use the pg_dump(all) program from 8.1.4 to 
create the dump.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Migration from 7.4.2 to 8.1.4
@ 2006-09-09 03:11  Michael Fuhr <mike@fuhr.org>
  parent: Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Michael Fuhr @ 2006-09-09 03:11 UTC (permalink / raw)
  To: Gallai János <gallaij@mediagnost.hu>; +Cc: pgsql-admin

[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]

On Fri, Sep 08, 2006 at 12:42:45PM +0200, Gallai János wrote:
> Thanks for your help, we tried but the same errors occurs. Would you be so
> kind to help us?
> We have tried a lot of things but it seems the only way is to make it by
> hand and it would be a very long work......

Could you show the exact dump and restore commands you ran and a
few of the errors?  Are you sure you ran the new (8.1.4) pg_dump
or pg_dumpall against the old (7.4.2) database?

-- 
Michael Fuhr



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-09-09 03:11 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-21 09:43 Migration from 7.4.2 to 8.1.4 Gallai János <gallaij@mediagnost.hu>
2006-08-21 12:40 ` Michael Fuhr <mike@fuhr.org>
2006-09-09 03:11   ` Michael Fuhr <mike@fuhr.org>
2006-08-21 12:47 ` Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox