Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-12-04 Thread Andrew Dunstan
Bruce Momjian wrote: Andrew Dunstan wrote: Tom Lane wrote: While Win32 supports 64-bit files, the MinGW API does not, meaning we have to build an fseeko replacement on top of the Win32 API, and we have to make sure MinGW handles it. Wouldn't it

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-12-04 Thread Bruce Momjian
Andrew Dunstan wrote: > > > Tom Lane wrote: > > >> While Win32 supports 64-bit files, the MinGW API does not, > >> meaning we have to build an fseeko replacement on top of the > >> Win32 API, and we have to make sure MinGW handles it. > >> > >> > > > >Wouldn't it b

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-12-04 Thread Andrew Dunstan
Tom Lane wrote: While Win32 supports 64-bit files, the MinGW API does not, meaning we have to build an fseeko replacement on top of the Win32 API, and we have to make sure MinGW handles it. Wouldn't it be better to lobby the MinGW folk to fix their problem? Or

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-12-03 Thread Tom Lane
Bruce Momjian writes: > Added to TODO: > o Add long file support for binary pg_dump output > While Win32 supports 64-bit files, the MinGW API does not, > meaning we have to build an fseeko replacement on top of the > Win32 API, and we have to make sure MinGW

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-12-03 Thread Bruce Momjian
Added to TODO: o Add long file support for binary pg_dump output While Win32 supports 64-bit files, the MinGW API does not, meaning we have to build an fseeko replacement on top of the Win32 API, and we have to make sure MinGW handles it. -

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-11-02 Thread Andrew Dunstan
Bruce Momjian wrote: Andrew Dunstan wrote: There is no fseeko in the Windows libraries, nor any provision in the mingw headers that I can see for a 64 bit off_t. So we would need to roll our own to some extent - I think we need more than just a bit of configure cleverness. However, the

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-11-02 Thread Bruce Momjian
Andrew Dunstan wrote: > There is no fseeko in the Windows libraries, nor any provision in the > mingw headers that I can see for a 64 bit off_t. So we would need to > roll our own to some extent - I think we need more than just a bit of > configure cleverness. > > However, there is a Windows li

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-11-02 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: There is no fseeko in the Windows libraries, nor any provision in the mingw headers that I can see for a 64 bit off_t. So we would need to roll our own to some extent - I think we need more than just a bit of configure cleverness

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-11-02 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > There is no fseeko in the Windows libraries, nor any provision in the > mingw headers that I can see for a 64 bit off_t. So we would need to > roll our own to some extent - I think we need more than just a bit of > configure cleverness. > However, th

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-11-02 Thread Andrew Dunstan
Magnus Hagander wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: Hmm. Windows reports an offset size of 4 bytes on a dump I just made ... is that relevant? What governs it? [ looks again... ] Hm, that is a 40Gb dump Kevin is complaining of, is

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-11-02 Thread Magnus Hagander
> > Andrew Dunstan <[EMAIL PROTECTED]> writes: > >> Hmm. Windows reports an offset size of 4 bytes on a dump I > just made > >> ... is that relevant? What governs it? > > > > [ looks again... ] Hm, that is a 40Gb dump Kevin is > complaining of, > > isn't it. Do our Windows builds have LARGEF

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-11-02 Thread Andrew Dunstan
Tom Lane said: > Andrew Dunstan <[EMAIL PROTECTED]> writes: >> Hmm. Windows reports an offset size of 4 bytes on a dump I just made >> ... is that relevant? What governs it? > > [ looks again... ] Hm, that is a 40Gb dump Kevin is complaining of, > isn't it. Do our Windows builds have LARGEFILE s

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-11-01 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Hmm. Windows reports an offset size of 4 bytes on a dump I just made ... > is that relevant? What governs it? [ looks again... ] Hm, that is a 40Gb dump Kevin is complaining of, isn't it. Do our Windows builds have LARGEFILE support?

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too

2005-11-01 Thread Andrew Dunstan
Hmm. Windows reports an offset size of 4 bytes on a dump I just made ... is that relevant? What governs it? cheers andrew Kevin Grittner wrote: Posting here because it may be a 8.1 pre-release problem. I'll take it to the admin list if it looks like it's not. File dumped from 8.1beta3 us

Re: [HACKERS] pg_restore [archiver] file offset in dump file is too large

2005-11-01 Thread Tom Lane
"Kevin Grittner" <[EMAIL PROTECTED]> writes: > File dumped from 8.1beta3 using pg_dump -Fc on Linux box. > This dump restored successfully onto 8.1RC1 on Linux box. > File FTP'd to Windows box; attempt to restore onto 8.1RC1 fails with: > pg_restore [archiver] file offset in dump file is too large

[HACKERS] pg_restore [archiver] file offset in dump file is too large

2005-11-01 Thread Kevin Grittner
Posting here because it may be a 8.1 pre-release problem. I'll take it to the admin list if it looks like it's not. File dumped from 8.1beta3 using pg_dump -Fc on Linux box. This dump restored successfully onto 8.1RC1 on Linux box. File FTP'd to Windows box; attempt to restore onto 8.1RC1 fails w