pg_dump error

Started by AI Rummanover 10 years ago6 messagesgeneral

Jump to latest

AI Rumman

rummandba@gmail.com

over 10 years ago

Hi,

I am getting the following error during pg_dump:

pg_dump dbname -v -t tablename -s -Fc -f dbname_tablename,sqlc

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

over 10 years ago

In reply to: AI Rumman (#1)

Re: 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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

AI Rumman

rummandba@gmail.com

over 10 years ago

In reply to: Adrian Klaver (#2)

Re: pg_dump error

No it is "-s" for schema only backup.

Thanks.

On Mon, Jul 27, 2015 at 10:53 AM, Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

Show quoted text

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

Adrian Klaver

adrian.klaver@aklaver.com

over 10 years ago

In reply to: AI Rumman (#3)

Re: pg_dump error

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

AI Rumman

rummandba@gmail.com

over 10 years ago

In reply to: Adrian Klaver (#4)

Re: pg_dump error

I am not using any comma here. With the same command I am able to take dump
on other disks.
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>
wrote:

Show quoted text

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

Adrian Klaver

adrian.klaver@aklaver.com

over 10 years ago

In reply to: AI Rumman (#5)

Re: pg_dump error

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general