Database access problem : SOS

Started by Nonameabout 23 years ago3 messagesgeneral
Jump to latest
#1Noname
mjoseph@inautix.com

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

#2Shridhar Daithankar
shridhar_daithankar@persistent.co.in
In reply to: Noname (#1)
Re: Database access problem : SOS

On Monday 03 February 2003 08:39 pm, you wrote:

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

Total numeric user ids won't work. try an alphabetical one..

Seems to be an FAQ these days..

Shridhar

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Shridhar Daithankar (#2)
Re: Database access problem : SOS

Shridhar Daithankar <shridhar_daithankar@persistent.co.in> writes:

On Monday 03 February 2003 08:39 pm, you wrote:

psql -U 1730 template1

Total numeric user ids won't work. try an alphabetical one..

They work again in 7.3.2 ...

regards, tom lane