Re: [GENERAL] Restoring databases from a different installment on Windows

2006-06-01 Thread Bruno Wolff III
On Wed, May 31, 2006 at 00:26:02 -0700, Berislav Lopac <[EMAIL PROTECTED]> wrote: > > Actually, my situation is like this: > > I had a properly running version of Postgres when my Windows crashed. I > Installed a fresh copy on Windows on another disk, and then Postgres on > top of it. Then I st

Re: [GENERAL] Restoring databases from a different installment on Windows

2006-06-01 Thread Berislav Lopac
Bruno Wolff III wrote: > Yes it should work. There should be a recovery if postgres was running when > the boc crashed. > Note, you don't want to copy files out from under a running server to do > backups. That won't work. Actually, my situation is like this: I had a properly running version of P

Re: [GENERAL] Restoring databases from a different installment on Windows

2006-05-30 Thread Bruno Wolff III
On Sun, May 28, 2006 at 07:24:56 -0700, Berislav Lopac <[EMAIL PROTECTED]> wrote: > I have recently reinstalled my Windows mychine, including the > PostgreSQL server, but (due to a system crash, unrelated to Postgres) I > wasn't able to dump my databases to import them now. However, I have a > fu

Re: [GENERAL] Restoring databases from a different installment on Windows

2006-05-30 Thread Berislav Lopac
Well, I did try that, but PostgreSQL service refused to start. :( Berislav ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not ma

[GENERAL] Restoring databases from a different installment on Windows

2006-05-30 Thread Berislav Lopac
I have recently reinstalled my Windows mychine, including the PostgreSQL server, but (due to a system crash, unrelated to Postgres) I wasn't able to dump my databases to import them now. However, I have a full copy of the original system, including all the files of the original Postgres installatio

Re: [GENERAL] Restoring databases from a different installment on Windows

2006-05-29 Thread Qingqing Zhou
"Berislav Lopac" <[EMAIL PROTECTED]> wrote >I have recently reinstalled my Windows mychine, including the > PostgreSQL server, but (due to a system crash, unrelated to Postgres) > I > wasn't able to dump my databases to import them now. However, I have a > full copy of the original system, includ