Thread: FW: FW: FW: Latest cygwin always crashing with Postgres

I thought the naming in /etc/passwd was strange too, so I re-added myself.
The line looked the same, except for the underlined part, which was now
THOUGHT1.  It still did no good.

Here's what's happening when postmaster runs:
- ...basic initialization...
- InitPostgres( "Owner", "Owner" )
-    SetDatabaseName( "Owner" )
-    GetRawDatabaseInfo is called to locate database "Owner" 's OID
-       It fails, because it only finds "template1" and "template0"
databases respectively
-    InitPostgres raises FATAL error and exits

-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of Jason Tishler
Sent: Monday, February 10, 2003 11:26 AM
To: Seth Rubin
Cc: Pgsql-Cygwin
Subject: Re: FW: FW: [CYGWIN] Latest cygwin always crashing with
Postgres


Seth,

On Mon, Feb 10, 2003 at 10:03:03AM -0500, Seth Rubin wrote:
> When I run from gdb, FATAL error occurs when "run", when I run from
> command line, the same error occurs, but not until I access with psql
> or other...

Hmm...

Also, where did the SEGVs go?

> This entry in /etc/passwd file was already there:
>
>
Owner:unused_by_nt/2000/xp:1003:513:U-YOUR-W92P4BHLZG\Owner,S-1-5-21-6707922
                                        ^^^^^^^^^^^^^^^
                                        ***************

> 05-1163395192-3403473811-1003:/home/Owner:/bin/bash

Looks OK, except that I expected to see "Thought1" above.

I'm sorry, but I think that you are having a problem due to XP Home or
some other misconfiguration.  You will have to debug further yourself.

I would start in src/backend/utils/init/postinit.c:

    /*
     * Find oid and path of the database we're about to open. Since
     * we're not yet up and running we have to use the hackish
     * GetRawDatabaseInfo.
     */
**> GetRawDatabaseInfo(dbname, &MyDatabaseId, datpath);

    if (!OidIsValid(MyDatabaseId))
        elog(FATAL,
             "Database \"%s\" does not exist in the system catalog.",
             dbname);

and figure out why GetRawDatabaseInfo() fails and/or returns a bogus
MyDatabaseId value.

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Seth,

On Mon, Feb 10, 2003 at 02:27:52PM -0500, Seth Rubin wrote:
> Here's what's happening when postmaster runs:
> - ...basic initialization...
> - InitPostgres( "Owner", "Owner" )
> -    SetDatabaseName( "Owner" )
> -    GetRawDatabaseInfo is called to locate database "Owner" 's OID
> -       It fails, because it only finds "template1" and "template0"
> databases respectively
> -    InitPostgres raises FATAL error and exits

I will offer one more suggestion before bowing out to other XP (Home)
users who should be able to help better than I can.

One XP Home user noted that the user running postmaster as a service
must be an "administrative" user and not a "guest" user.  Is "Owner" an
"administrative" user?  If not, then make it so and try again.

I'm sorry that I cannot be of more help, but I have no access to XP.

Can a XP (Home) user help out Seth here?

Thanks,
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