Re: Postgresql database does not start and just hangs

Dear Tom,
Thanks a lot for your help because the suggestion of yours was a success and
we have succeeded in bringing the db back on.
We had to install cygwin and postgresql both again. Just reinstall of
postgresql does not work.
Then finally did a copy and paste the previous /usr/local/pgsql/data
directory in the new install of postgresql.
And when the db was started with
./postmaster -i -D /usr/local/pgsql/data

It worked finally!

Thanks for your support.

This was a hard and long way to do this thing but finally what mattered is
that the work paid off. While working on this was thinking about what
exactly made cygwin to go whacko like that?

Thanks

Mandar Salunkhe
460 Alexandra Road, PSA Building
Singapore 119963
Phone: 65-63617413 HP Telnet Number: 831-7413
Email: mandar(dot)salunkhe(at)hp(dot)com

-----Original Message-----
From: SALUNKHE,MANDAR (HP-Singapore,ex1) [mailto:mandar(dot)salunkhe(at)hp(dot)com]
Sent: Monday, April 21, 2003 10:43 AM
To: 'Tom Lane'
Cc: 'pgsql-novice(at)postgresql(dot)org'; FRANKLIN,JOHNSON (HP-Singapore,ex5)
Subject: Re: [NOVICE] Postgresql database does not start and just hangs

Dear Tom,
Well there's no harm in trying this our on our test database. If it works we
are through, otherwise back to Square 1. Few pointers needed: Do I just copy
and paste the previous /usr/local/pgsql/data directory in the new install of
postgresql? Thanks

Mandar Salunkhe
HP CDI Team
460 Alexandra Road, PSA Building
Singapore 119963
Phone: 65-63617413 HP Telnet Number: 831-7413
Email: mandar(dot)salunkhe(at)hp(dot)com

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, April 21, 2003 10:38 AM
To: SALUNKHE,MANDAR (HP-Singapore,ex1)
Cc: 'pgsql-novice(at)postgresql(dot)org'
Subject: Re: [NOVICE] Postgresql database does not start and just hangs

"SALUNKHE,MANDAR (HP-Singapore,ex1)" <mandar(dot)salunkhe(at)hp(dot)com> writes:
> Do you mean to say that if we reinstall postgresql but keep the same
> data directory as in the previous install, the database will start
> again?

I'm not promising that, at all ;-). But it seems worth trying.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster