Database access problem : SOS - Mailing list pgsql-admin

From mjoseph@inautix.com
Subject Database access problem : SOS
Date
Msg-id OF8DEA0C43.1622AC4A-ON65256CC2.00541450@LocalDomain
Whole thread Raw
Responses Re: Database access problem : SOS  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi,
I am new to PostgreSQL. I am running PostgreSQL on top of Cygwin on Windows
NT.
I am able to initialize the database cluster and create template1. I log in
and even create a 'test' table.
But querying it results in the error.

ERROR:  pg_class_aclcheck: invalid user id 1730

Someone please help!
This is the sequence of steps I follow.

mkdir /usr/local/pgsql/data
chown 1730 /usr/local/pgsql/data
ipc-daemon &
initdb -D /usr/local/pgsql/data -U 1730 -W
psql -U 1730 template1

My NT user id is 1730 and I have admin privileges. Like I said earlier, I
am able to login. But I am unable to query any tables.
Anyone out there got any clues?
Regards,
Manoj




pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum full hang => strace
Next
From: Gary Stainburn
Date:
Subject: Re: Fwd: Postgresql