Re: [GENERAL] Recover database from binary files

2011-04-26 Thread Diogo Melo
t 9:50 AM, Diogo Melo wrote: > > just tar -zcvf 8.3.tar.gz /mnt/sdf/var/lib/postgresql/8.3/ > > since i found a way to mount the partition on /mnt/sdf. > > first I installed postgres on a virtual machine and then I extracted the > > 8.3.tar.gz at /var/lib/postgresql . when

Re: [GENERAL] Recover database from binary files

2011-04-26 Thread Diogo Melo
instantly but don't launch anything. Is there a procedure to recover postgres databases on this occasions?? Diogo Oliveira de Melo Ciência da Computação ICMC - USP São Carlos On Tue, Apr 26, 2011 at 12:45 PM, Scott Marlowe wrote: > On Tue, Apr 26, 2011 at 9:43 AM, Diogo Melo wrote

[GENERAL] Fwd: Recover database from binary files

2011-04-26 Thread Diogo Melo
Diogo Oliveira de Melo Ciência da Computação ICMC - USP São Carlos -- Forwarded message -- From: Diogo Melo Date: Tue, Apr 26, 2011 at 12:43 PM Subject: Recover database from binary files To: pgsql-general@postgresql.org Hi, I can't boot the postgres server anymore. I

[GENERAL] Recover database from binary files

2011-04-26 Thread Diogo Melo
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.