-----Original Message-----
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:33 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:27 PM, Bob Pawley wrote:
-----Original Message----- From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 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@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 6:41:51 pm Bob Pawley wrote:
> > Bob
>
> --
> Adrian Klaver
> adrian.kla...@gmail.com
>
> 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.
I downloaded an sql editor and it looks the same in it as well.
At least the editor will make it easier to fix the problem. However I
would like to know what happened so I can avoid it in the future.
I am not sure. If the file is not to big and you wish you can send it to
me off list and maybe I can figure out what is going on.
The file is over 9 meg - way to large for me to e-mail.
It seems that this has affected just the triggers - although that is quite
massive I will just plug away at it until it's done
Thanks
Bob
Is the compressed file a better way to dump??
Yes in this case because you can do a restore from within pgAdmin.
Bob
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
