Re: 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: Re: Postgresql Data directory Issue
Date: 2011-10-06 09:04:02
Message-ID: 4E8D6F02.8060605@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

Any update on the issue.

Thanks

Adarsh Sharma wrote:
> 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
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adarsh Sharma 2011-10-06 09:36:01 Re: Restoring 2 Tables From All Databases Backup
Previous Message Robert Buckley 2011-10-06 09:02:28 Re: problem with round() in php script