Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Posts
    2

    Unanswered: Can't backup/restore 800mg db

    hi
    i have one table db with 216000 records and about 800mg size.
    i want to backup it with pg_dump, but with compress format ,backup stop at 20mg and then nothing happen(at dos prompt)...
    pg_dum done backup with plain data-only switch, but when i want to restore it on other pc ,
    psql gives me error :

    COPY mytbl (id, site, category, title, author, mydate, keywords, body) FROM stdin; 2009-01-20 11:49:29 IRST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.
    so please help me, how to backup and restore this db ?
    i run postgresql 8.3.3 on WinXP sp2.
    thanks

  2. #2
    Join Date
    Jan 2009
    Posts
    2
    --insert works for me

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •