Hi Jason,
I tried the following just after I sent my last email and it worked:
$rm /data/postmaster.pid
I followed with:
$ pg_ctl start
postmaster successfully started
Along with the following:
Administrator@COBA-MAGRAWAL
$ LOG: database system was interrupted at 2003-02-07 08:57:21 EST
LOG: checkpoint record is at 0/83B1A8
...
LOG: database system was not properly shut down; automatic recovery in
progress
...
LOG: REDO IS NOT REQUIRED
LOG: database system is ready.
I hope I am all set
Thanks
Manish
-----Original Message-----
From: Jason Tishler [mailto:jason@tishler.net]
Sent: Friday, February 07, 2003 3:45 PM
To: Agrawal, Manish
Cc: Pgsql-Cygwin
Subject: Re: [CYGWIN] Installing PostgreSQL 7.3.1 on windows 2000
Manish,
On Fri, Feb 07, 2003 at 03:03:44PM -0500, Agrawal, Manish wrote:
> I accidentally closed the pgsql command window (without stopping
> pgsql) to download and install pgadmin. As a result:
> (a) My computer shut down
Hmm...
> (b) I cannot restart pgsql.
Try the following:
$ net stop ipc-daemon
$ rm -fr /tmp/cygipc_* /tmp/MultiFile*
$ net start ipc-daemon
$ pg_ctl start
> The error message is attached as an image to this email.
Next time please cut and paste your error messages as text. Remember,
the goal is to make it as easy as possible for someone to help.
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6