Sorry to be rude, but you are in urgent need of a PostgreSQL DBA, (if you feel you somehow value your data). Anyways, 8.3 catalog is not compatible with 8.4. You need to dump->upgrade->restore if you just start 8.3 server with /usr/local/pgsql/bin/postgres -D <path_to_your_data_dir> what happens? Στις Wednesday 05 October 2011 15:05:26 ο/η Adarsh Sharma έγραψε: > 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 > > > -- Achilleas Mantzios -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
