Re: Dumping database using 8.1 or 7.1

Thanks sir.

Is it safe to use the Postgres 8.1.4 pg_dump utility to dump data from a
postgres 7.1.2 database?

Thanks again :)

Jonathan Valllar

On 8/5/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Jonathan Vallar" <bamvallar(dot)db(at)gmail(dot)com> writes:
> > After dumping the database. I tried to load it on Postgres 8.1. I
> > encountered errors on some database tables. Some lines on the file are
> empty
> > (a blank record or a corrupt record?). Before the said lines, there was
> a
> > "\M". What does "\M" stand for?
>
> Carriage return --- you evidently have some Mac- or Windows-style
> newlines in your data. My recollection is that 7.1 had a different
> convention for representing these in COPY data than the later versions
> do. If you want to preserve them exactly as-is you might try doing
> the pg_dump from 7.1 with the dump-data-as-INSERTs option. If you'd
> rather clean up the data then just manually remove the CRs from the dump
> file ...
>
> regards, tom lane
>