I'm currently backing up my db to be transfered from
one server to another. I backed up the db using the
% pg_dump dbname > dbname.pgdump
but when restoring the database on the new server
using the following command
cat dbname.pgdump | psql dbname
It generates the some of the tables and then somewhere
in the middle of the process of restoreing the db I
get the following error message:
\? -- help
\a -- toggle field-alignment (currently on)
\C [<captn>] -- set html3 caption (currently '')
Broken pipe
This is what my database looks like on the old server
+------------------+------------------+----------+
| Owner | Relation | Type |
+------------------+------------------+----------+
| pgsql | bannerads | table |
| pgsql | bannerads_pkey | index |
| pgsql | company | table |
| pgsql | company_pkey | index |
| pgsql | marketplace | table |
| pgsql | marketplace_pkey | index |
| pgsql | news | table |
| pgsql | news_pkey | index |
| peter | productcategory | table |
| peter | productcategory_pkey | index |
| pgsql | ref | table |
| pgsql | ref_pkey | index |
| pgsql | registry | table |
| pgsql | registry_pkey | index |
| pgsql | shows | table |
| pgsql | shows_pkey | index |
| pgsql | testdate | table |
+------------------+------------------+----------+
On the new server it looks like this
+------------------+-----------------+----------+
| Owner | Relation | Type |
+------------------+-----------------+----------+
| pgsql | bannerads | table |
| pgsql | company | table |
| pgsql | marketplace | table |
| pgsql | news | table |
| peter | productcategory | table |
| pgsql | ref | table |
| pgsql | registry | table |
| pgsql | shows | table |
| pgsql | testdate | table |
+------------------+-----------------+----------+
As you can see the broken pipe happened before the
restoring of the index tables.
If anyone has encountered a similiar problem or knows
what may have caused this error, I'd be greatly
appreciated if you could point me in the right
direction.
thanks,
Mr. Newbie
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
