Re: [GENERAL] pgdump error Could not open file pg_clog/0B8E: No such file or directory

2013-04-25 Thread jesse . waters
Sorry for the delay. No it does not exist. ls -l /var/lib/pgsql/data/pg_clog/0B8E ls: /var/lib/pgsql/data/pg_clog/0B8E: No such file or directory Have 92 files in directory which are all 262144 in size. On Wed, Apr 24, 2013 at 9:23 AM, Adrian Klaver adrian.kla...@gmail.com wrote: On

Re: [GENERAL] pgdump error Could not open file pg_clog/0B8E: No such file or directory

2013-04-25 Thread Merlin Moncure
On Thu, Apr 25, 2013 at 5:13 AM, jesse.wat...@gmail.com wrote: Sorry for the delay. No it does not exist. ls -l /var/lib/pgsql/data/pg_clog/0B8E ls: /var/lib/pgsql/data/pg_clog/0B8E: No such file or directory Have 92 files in directory which are all 262144 in size. This file records if

[GENERAL] pgdump error Could not open file pg_clog/0B8E: No such file or directory

2013-04-24 Thread jesse . waters
I am receiving an error when running a pg_dump. These are older legacy systems and upgrading them is not in plan. Any help will be appreciated. CentOS 5.3 (64bit) psql (PostgreSQL) 8.3.11 full error message: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: could not

Re: [GENERAL] pgdump error Could not open file pg_clog/0B8E: No such file or directory

2013-04-24 Thread Adrian Klaver
On 04/24/2013 03:35 AM, jesse.wat...@gmail.com wrote: I am receiving an error when running a pg_dump. These are older legacy systems and upgrading them is not in plan. Any help will be appreciated. CentOS 5.3 (64bit) psql (PostgreSQL) 8.3.11 full error message: pg_dump: SQL command failed