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@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@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@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@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
