| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Pierre" <pmathe(at)neuf(dot)fr> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #5619: restore won't work with files transferred with NFS |
| Date: | 2010-08-13 18:53:46 |
| Message-ID: | 5155.1281725626@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Pierre" <pmathe(at)neuf(dot)fr> writes:
> Detailed operations:
> 1. on computer A, using PgAdmin3, backup of database x into file
> saveddb.backup
> 2. tranfer of this file to a directory of computer B, using NFS
> 3. on computer B, Restore of this file from the local directory won't work:
> 3.1. If it is the first attempt, it says the file structure is not
> correct.
I'm not entirely sure what you mean by "transfer using NFS", but what
this sounds like to me is the file got corrupted during the transfer.
If there was any Windows software involved, I'd bet on a LF -> CR/LF
newline conversion being the problem.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-08-13 19:01:54 | Re: Re: BUG #5614: Varchar column (with DEFAULT NULL) stores 'UL' value instead of null |
| Previous Message | mmajer@janmedia.com | 2010-08-13 15:27:04 | Re: BUG #5614: Varchar column (with DEFAULT NULL) stores 'UL' value instead of null |