Re: BUG #2316: problems when Restore Backup in RHEL4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Teofilo Santos" <teofilo(dot)santos(at)tjap(dot)gov(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2316: problems when Restore Backup in RHEL4
Date: 2006-03-16 01:04:31
Message-ID: 10981.1142471071@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Teofilo Santos" <teofilo(dot)santos(at)tjap(dot)gov(dot)br> writes:
> I made a pg_dumpall in a postgresql server without problems (using Red Hat
> 9. and postgresql 8.0.3), but when i attempt to restore this backup in a
> RHEL4 (kernel 2.6.9-5 64 bits )i receive a lot of erros: invalid command
> \n!

If you're using the RHEL4 version of Postgres (ie, 7.4.something), this
is unlikely to work --- dump files are very often not portable to older
server versions without manual editing, because they'll use new SQL
features that the older server doesn't understand.

Try paying attention to the *first* reported error, not the subsequent
ones, to get a better handle on what's going wrong.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Kirpa 2006-03-16 01:42:11 Re: BUG #2315: Crash engine after modify "active" function
Previous Message Tom Lane 2006-03-16 00:59:49 Re: BUG #2317: Wrong sorting order for (VW)