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
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) |