Re: [GENERAL] Postgresql Data directory Issue

2011-10-06 Thread Alban Hertroys
On 6 October 2011 12:18, Adarsh Sharma wrote: > We can upgrade to new version if our previous version is running. But isn't upgrading exactly what you're trying to do? And why do you think you need to have the old database running to be able to upgrade? According to the link I sent you, you don't

Re: [GENERAL] Postgresql Data directory Issue

2011-10-06 Thread Adarsh Sharma
We can upgrade to new version if our previous version is running. But In my Case I have only /opt/postgresql-8.3/data directory ( 110 Gb). My server Crashes down and Postgres is not running. I copied postgresql data directory to a new server and installed Postgresql8.3 but still it is not using

Re: [GENERAL] Postgresql Data directory Issue

2011-10-06 Thread Alban Hertroys
On 6 October 2011 11:04, Adarsh Sharma wrote: > Dear all, > > Any update on the issue. Apparently, pg-migrator (later called pg_upgrade) is available for pg 8.3, see here for instructions: http://www.depesz.com/index.php/2010/05/19/waiting-for-9-0-pg_upgrade/ -- If you can't see the forest for

Re: [GENERAL] Postgresql Data directory Issue

2011-10-06 Thread Adarsh Sharma
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/P

Re: [GENERAL] Postgresql Data directory Issue

2011-10-05 Thread Achilleas Mantzios
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 what happens? Στις Wednesday 05 Oct

Re: [GENERAL] Postgresql Data directory Issue

2011-10-05 Thread Christian Ullrich
* Adarsh Sharma wrote: 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 . First, be very, very careful. initdb already saved your data from destruction once, but

[GENERAL] Postgresql Data directory Issue

2011-10-05 Thread 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 resul