Re: [GENERAL] Recover database from binary files

2011-04-26 Thread Diogo Melo
You were right. It was just a matter of set chown -R postgres.postgres /var/lib/postgresql/8.3 :D :D :D Case solved :D Thanks a lot dude :D Diogo Oliveira de Melo Ciência da Computação ICMC - USP São Carlos On Tue, Apr 26, 2011 at 12:52 PM, Scott Marlowe wrote: > On Tue, Apr 26, 2011 at 9:5

Re: [GENERAL] Recover database from binary files

2011-04-26 Thread Scott Marlowe
On Tue, Apr 26, 2011 at 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 i try to s

Re: [GENERAL] Recover database from binary files

2011-04-26 Thread Diogo Melo
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 i try to sh /etc/init.d/postgresql-8.3 start it runs the command ins

Re: [GENERAL] Recover database from binary files

2011-04-26 Thread Scott Marlowe
On Tue, Apr 26, 2011 at 9:43 AM, Diogo Melo wrote: > 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

[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.