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
