Results 1 to 3 of 3

Thread: pg_restore

  1. #1
    Join Date
    Apr 2004
    Location
    Paris
    Posts
    2

    Unanswered: pg_restore

    Hi,

    I have big problems trying to restore data with pg_restore. With big tables (4G lines) the machine seems to be stucked, doing nothing. Has anybody got the same problem?

    Thanks

    Laurent

  2. #2
    Join Date
    Sep 2002
    Location
    Toronto, Canada
    Posts
    76

    Re: pg_restore

    Originally posted by LaurentPierre
    Hi,

    I have big problems trying to restore data with pg_restore. With big tables (4G lines) the machine seems to be stucked, doing nothing. Has anybody got the same problem?

    Thanks

    Laurent
    Do you have to use pg_restore to restore you data? If so, could you use it to move data into a text file and do the following:

    cat TEXT-FILE | psql data

  3. #3
    Join Date
    Apr 2004
    Location
    Paris
    Posts
    2

    Re: pg_restore

    Originally posted by unicef2k
    Do you have to use pg_restore to restore you data? If so, could you use it to move data into a text file and do the following:

    cat TEXT-FILE | psql data

    I can do it (I just have to unzip the files) ... but you really think it will be better not using pg_restore ?

Posting Permissions

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