Postgresql Data directory Issue

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Postgresql Data directory Issue
Date: 2011-10-05 12:05:26
Message-ID: 4E8C4806.7040102@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

I have a database server ( 10 databases near about 110 GB) running
Postgresql-.8.3 )
Today I need to format that system but I an facing the below issues :-

1. I am trying to use the previous data directory
(/opt/PostgresPlus/8.3/data) in new Postgresql-8.4 installation but it
results in below error while installing :-

Data Directory
[/media/a519e535-62a8-43a2-af93-2323690a3177/opt/PostgresPlus/8.3/data]:
Error: The existing data directory (catalog version: 200711281) is not
compatible with this server (catalog version: 200904091).
Press [Enter] to continue :

So i think I need to install Postgresql-8.3 to use that data.

2. I installed Postgresql-8.3 in new server and trying to use the data
directory but it faces the below error :-

Existing data directory is not empty and it cannot able to use it .

Please note that I am not able to take the complete databases backup
because the database server is down and restarts when we start backups.

Any help will be appreciated.

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Ullrich 2011-10-05 12:19:13 Re: Postgresql Data directory Issue
Previous Message Chethan HB 2011-10-05 11:12:26 Fwd: [BUGS] BUG #6240: About - postgreswdinit.sql