Diogo Oliveira de Melo
Ciência da Computação
ICMC - USP São Carlos
---------- Forwarded message ----------
From: Diogo Melo <dmelo87@xxxxxxxxx>
Date: Tue, Apr 26, 2011 at 12:43 PM
Subject: Recover database from binary files
To: pgsql-general@xxxxxxxxxxxxxx
Diogo Oliveira de Melo
Ciência da Computação
ICMC - USP São Carlos
From: Diogo Melo <dmelo87@xxxxxxxxx>
Date: Tue, Apr 26, 2011 at 12:43 PM
Subject: Recover database from binary files
To: pgsql-general@xxxxxxxxxxxxxx
Hi,
I can't boot the postgres server anymore. I just have access to the files, like the /var/lib/postgresql/8.3 path, for example. I use debian and postgresql-8.3 .
I don't have any sql dump. How can I recover my databases with just the binary files there?
I tried copy the /var/lib/postgresql/8.3 to another a installation of postgresql-8.3 on another server, but without success.
I can't boot the postgres server anymore. I just have access to the files, like the /var/lib/postgresql/8.3 path, for example. I use debian and postgresql-8.3 .
I don't have any sql dump. How can I recover my databases with just the binary files there?
I tried copy the /var/lib/postgresql/8.3 to another a installation of postgresql-8.3 on another server, but without success.
Diogo Oliveira de Melo
Ciência da Computação
ICMC - USP São Carlos
