PostgreSQL - Ubuntu libc error

[fixx]

Hi Guys

I am trying to dump a PostgreSQL database for a client to see if I can restore it on another machine. Unfortunately my dump fails with the following erroer:

Jun 12 10:56:03 vvvsvr kernel: [250150.751413] postgres[13790]: segfault at 9638000 ip b7253c03 sp bfa4c328 error 4 in libc-2.15.so[b7119000+1a4000]

I have tried dumping the database on the local server and from a remote server with the same result.

This is the kernel version of the server:

Linux vvvsvr 3.5.0-44-generic #67~precise1-Ubuntu SMP Wed Nov 13 16:20:03 UTC 2013 i686 i686 i386 GNU/Linux

This is the version of Ubuntu:

No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 12.04.2 LTS
Release: 12.04
Codename: precise

And the version of PostgreSQL:

psql (9.1.15)

This is the command I use to dump the database (I have tried plain text and directory mode):
pg_dump -Fd -f domino_dump -v -h 192.168.1.4 -U MY_USERNAME domino

The dump runs for a while and then echo's this to stdout:

pg_dump: Dumping the contents of table "etl_drconsults_visitrecon" failed: PQgetCopyData() failed.
pg_dump: Error message from server: SSL SYSCALL error: EOF detected

The above libc error is logged on the Ubuntu server's syslog file.

Thanks in advance for the help.

 

[ginggs]

This is the version of Ubuntu:

Description: Ubuntu 12.04.2 LTS

12.04.2 was released in February 2013.
You should at least be on 12.04.5 by now.

And the version of PostgreSQL:

psql (9.1.15)

That is the postgresql version, but what is the version of the postgresql package you have installed?

The following should tell you:

apt-cache policy postgresql

I suggest installing updates for Precise (not upgrading to Trusty) and seeing if the problem you are experiencing is already fixed.

 

[fixx]

Thanks for the reply ginggs. The issue is this server has (obviously) not been maintained for many years and the client is hosting a critical backup on it.

I am too scared to try and upgrade it because if it fails I am going to have to account for it.

 

[Nod]

Before you do anything, remember to back it all up.
You can at least fall back to where you were if you have a backup.

 

[fixx]

See that's the thing I am trying to make a backup of the Postgres databases which fails at this stage.

I would like to move them to a CentOS server but I can't export this specific database without it causing an error.

 

[ginggs]

See that's the thing I am trying to make a backup of the Postgres databases which fails at this stage.

Clone the disk.