Обсуждение: pg_dump error

On 07/27/2015 10:48 AM, AI Rumman wrote:
> Hi,
>
> I am getting the following error during pg_dump:
>
> pg_dump dbname -v -t tablename -s -Fc -f dbname_tablename,sqlc
                                                            ^
Is that really a ','(comma)?

>
> pg_dump: [custom archiver] WARNING: ftell mismatch with expected
> position -- ftell used
>
> I am using Postgresql 9.1 and I have enough disk space on it. The backup
> drive is on ISOLON CIFS file system.
>
> What may be the errors?
>
> Please advice.
>
>
> Thanks.
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 07/27/2015 10:55 AM, AI Rumman wrote:
> No it is "-s" for schema only backup.

My ^ got misplaced in sending. I was talking about the ',' in the file
name at the end of the command.

>
> Thanks.
>
> On Mon, Jul 27, 2015 at 10:53 AM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 07/27/2015 10:48 AM, AI Rumman wrote:
>
>         Hi,
>
>         I am getting the following error during pg_dump:
>
>         pg_dump dbname -v -t tablename -s -Fc -f dbname_tablename,sqlc
>
>                                                                 ^
>     Is that really a ','(comma)?
>
>
>
>         pg_dump: [custom archiver] WARNING: ftell mismatch with expected
>         position -- ftell used
>
>         I am using Postgresql 9.1 and I have enough disk space on it.
>         The backup
>         drive is on ISOLON CIFS file system.
>
>         What may be the errors?
>
>         Please advice.
>
>
>         Thanks.
>
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 07/27/2015 10:58 AM, AI Rumman wrote:
> I am not using any comma here. With the same command I am able to take
> dump on other disks.

I beg to differ, From your original post:

-f dbname_tablename,sqlc
                  ^^^^^^^
 >

> But with ISOLON CIFS, I am getting the error.


> Thanks.
>
> On Mon, Jul 27, 2015 at 10:56 AM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 07/27/2015 10:55 AM, AI Rumman wrote:
>
>         No it is "-s" for schema only backup.
>
>
>     My ^ got misplaced in sending. I was talking about the ',' in the
>     file name at the end of the command.
>
>
>         Thanks.
>
>         On Mon, Jul 27, 2015 at 10:53 AM, Adrian Klaver
>         <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>         <mailto:adrian.klaver@aklaver.com
>         <mailto:adrian.klaver@aklaver.com>>> wrote:
>
>              On 07/27/2015 10:48 AM, AI Rumman wrote:
>
>                  Hi,
>
>                  I am getting the following error during pg_dump:
>
>                  pg_dump dbname -v -t tablename -s -Fc -f
>         dbname_tablename,sqlc
>
>                                                                          ^
>              Is that really a ','(comma)?
>
>
>
>                  pg_dump: [custom archiver] WARNING: ftell mismatch with
>         expected
>                  position -- ftell used
>
>                  I am using Postgresql 9.1 and I have enough disk space
>         on it.
>                  The backup
>                  drive is on ISOLON CIFS file system.
>
>                  What may be the errors?
>
>                  Please advice.
>
>
>                  Thanks.
>
>
>
>              --
>              Adrian Klaver
>         adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>         <mailto:adrian.klaver@aklaver.com
>         <mailto:adrian.klaver@aklaver.com>>
>
>
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com