On 12/28/2010 07:16 PM, Bob Pawley wrote:
-----Original Message----- From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-----Original Message----- From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:51 PM
To: Bob Pawley
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Restore problem
On Tuesday 28 December 2010 6:41:51 pm Bob Pawley wrote:
> > Bob
>
> --
> Adrian Klaver
> adrian.klaver@xxxxxxxxx
>
> This is the plain text dump file through pg_admin dump. But the plain
> text dump fie through psql restored in the same way.
I am not following. psql cannot create a dump file. It can however be
used
to
restore a plain text dump file created by pg_restore. I think you are
going
to
need show the steps you took.
I used PGAdmin to dump the June version and pg_dump mydb > db.sql to
dump
the May version.
Both came out with the same problems.
Bob
What program are you using to look at the plain text file?
Notepad
Bob
Open the file in Wordpad and see if it looks better.
It looks the same.
Bob
Well there goes that theory. Notepad is almost useless as a text editor
and is known for not wrapping lines correctly.
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general