Re: DB Import Error...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Kevin:

Thanks for your quick response.
I will try out this and come back if issue was not resolved still.

Thanks
Senthil

-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@xxxxxxxxxxxx] 
Sent: Friday, April 01, 2011 8:49 PM
To: pgsql-admin@xxxxxxxxxxxxxx; Senthil Kumar G
Subject: Re:  DB Import Error...

"Senthil Kumar G" <senthil@xxxxxxxxxx> wrote:
 
> I am upgrading my staging environment from postgresql 8.2.3 to
> 9.0.3.
> 
> I was able to do successfully.
 
> [errors while applying dump to new database]
 
> What could be the reason? What should i do to resolve this?
 
The recommended upgrade technique is to us pg_dump (or pg_dumpall)
from the newer version (9.0.3 in this case) to access the old
database (running the 8.2.3 server in this case).  If you followed
some other procedure, like using the 8.2.3 software to dump the
database, you should try the recommended approach instead.
 
I generally dump in plain text format (the default) and pipe it to
psql.
 
-Kevin


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux