Thread: Gotcha!!! Installing PostgreSQL 7.3.1 on windows 2000

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

Manish,

On Mon, Feb 10, 2003 at 04:15:38PM -0500, Agrawal, Manish wrote:
> 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

I thought of suggesting removing the .pid file, but I thought the error
message for that case was different than what you reported.  In
hindsight, I don't know how I missed the following:

On Mon, Feb 10, 2003 at 04:08:59PM -0500, Agrawal, Manish wrote:
> $ pg_ctl start
> pg_ctl: Another postmaster may be running. Trying to start postmaster
> anyway.  Found a pre-existing shared memory block (Key 5432001, id 0)
> still in use. If you're sure there are no old backends still running,
> remove the shared memory block with ipcrm(1), or
> just delete "/data/postmaster.pid".
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^

I apologize for not suggesting the above earlier.

I'm glad that you are up and running.

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