From: | dinesh kumar <dineshkumar02(at)gmail(dot)com> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | PostgreSQL 9.3 pg_dump issue |
Date: | 2013-06-25 13:08:39 |
Message-ID: | CALnrH7q6dag-gC6sFT5-7uZkNTkEb_exici9syvFE7WpeXXeAw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
Greetings for the day.
Recently, I have installed the PostgreSQL 9.3 on my local ubuntu machine
for testing the new features in PG 9.3. I have created few test tables as
well. Now, I am trying to take the dump from the 9.3 binaries and getting
the below error.
postgres(at)test-ubuntu:/opt/PostgreSQL/9.3/bin$ ./pg_dump -f /tmp/pg_9.3.sql
-s -d postgres -p 5434
Password:
*cannot duplicate null pointer (internal error)*
postgres(at)test-ubuntu:/opt/PostgreSQL/9.3/bin$ ./psql -p 5434 -U postgres
postgres
Password for user postgres:
psql.bin (9.3beta1)
Type "help" for help.
postgres=# SELECT VERSION();
version
-----------------------------------------------------------------------------------------------------------
PostgreSQL 9.3beta1 on i686-pc-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-52), 32-bit
(1 row)
Then, I have tried to take the dump with pg_dumpall, and the result as
below.
postgres(at)test-ubuntu:/opt/PostgreSQL/9.3/bin$ ./pg_dumpall -f
/tmp/pg_9.3.sql -p 5434
Password:
Password:
*cannot duplicate null pointer (internal error)*
pg_dumpall: pg_dump failed on database "postgres", exiting
postgres(at)test-ubuntu:/opt/PostgreSQL/9.3/bin$
Below are the log entries.
==================
2013-06-25 18:24:05 IST LOG: duration: 0.017 ms statement: SET
search_path = public, pg_catalog
2013-06-25 18:24:05 IST LOG: duration: 0.305 ms statement: SELECT
sequence_name, start_value, increment_by, CASE WHEN increment_by > 0 AND
max_value = 9223372036854775807 THEN NULL WHEN increment_by < 0 AND
max_value = -1 THEN NULL ELSE max_value END AS max_value, CASE WHEN
increment_by > 0 AND min_value = 1 THEN NULL WHEN increment_by < 0 AND
min_value = -9223372036854775807 THEN NULL ELSE min_value END AS
min_value, cache_value, is_cycled FROM seq
2013-06-25 18:24:05 IST LOG: duration: 0.117 ms statement: SELECT
attname, attacl FROM pg_catalog.pg_attribute WHERE attrelid = '16438' AND
NOT attisdropped AND attacl IS NOT NULL ORDER BY attnum
2013-06-25 18:24:05 IST LOG: duration: 0.018 ms statement: SET
search_path = public, pg_catalog
2013-06-25 18:24:05 IST LOG: duration: 0.075 ms statement: SELECT
last_value, is_called FROM seq
2013-06-25 18:24:05 IST LOG: unexpected EOF on client connection with an
open transaction
2013-06-25 18:24:05 IST DEBUG: unexpected EOF on client connection
2013-06-25 18:24:14 IST DEBUG: autovacuum: processing database "postgres"
I would like to request you to share your inputs on this error. Is this a
BUG in 9.3 pg_dump binary.
Thanks in advance.
Regards,
Dinesh
manojadinesh.blogspot.com
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolau Roca | 2013-06-25 13:13:01 | autovacuum: found orphan temp table |
Previous Message | Ryan Kelly | 2013-06-25 12:39:47 | greatest cannot be used as sfunc for CREATE AGGREGATE |