Search Postgresql Archives

Re: Restore problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





-----Original Message----- From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:33 PM
To: Bob Pawley
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  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@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.

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.klaver@xxxxxxxxx

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux