Re: [ADMIN] Database in recovery mode forever

2009-05-19 Thread Scott Marlowe
On Tue, May 19, 2009 at 8:50 AM, Cassiano, Marco wrote: > Hi all, > > this afternoon I had a database crash on a test system (The first Postgres > crash in more than three years). > I wasn't able to identify the reason.the log doesn't say anything > interesting. > Is there way the exactly iden

[ADMIN] Database in recovery mode forever

2009-05-19 Thread Cassiano, Marco
Hi all, this afternoon I had a database crash on a test system (The first Postgres crash in more than three years). I wasn't able to identify the reason.the log doesn't say anything interesting. Is there way the exactly identify the reason of the crash ? After having detected the crash, P

Re: [ADMIN] Problem with .pgpass

2009-05-19 Thread Nicolas Michel
There was indeed a blank after the line (after the password)... ^^ To Scott : yes, I set the file with 0600 permissions ;) Thank you very much for your help. Le lundi 18 mai 2009 à 11:59 -0400, Tom Lane a écrit : > Nicolas Michel writes: > > I tried to put my password in a .pgpass file into th

Re: [ADMIN] migration with additional complications

2009-05-19 Thread Tino Schwarze
Hi pg043g9j2g (or what's your name?), > For various reasons I had to abandon that OS install and > reformat/reinstall WinXP. Time passes... Today I am looking to recover > my work and basically resume where I left off. > > One problem is that I never did an "export" of the old database using