Gotcha!!! Installing PostgreSQL 7.3.1 on windows 2000 - Mailing list pgsql-cygwin

From Agrawal, Manish
Subject Gotcha!!! Installing PostgreSQL 7.3.1 on windows 2000
Date
Msg-id 00A42578900AD411BCFD00A0C978DC9304DC01AA@mail.coba.usf.edu
Whole thread Raw
Responses Re: Gotcha!!! Installing PostgreSQL 7.3.1 on windows 2000  (Jason Tishler <jason@tishler.net>)
List pgsql-cygwin
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

pgsql-cygwin by date:

Previous
From: "Agrawal, Manish"
Date:
Subject: Re: Installing PostgreSQL 7.3.1 on windows 2000
Next
From: "Colin Mangiagalli"
Date:
Subject: Write to transaction logs, Permission Denied