| From: | mjoseph(at)inautix(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Database access problem : SOS |
| Date: | 2003-02-03 15:09:46 |
| Message-ID: | OFA43748BF.2FFB94C3-ON65256CC2.0052A944@LocalDomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mjoseph | 2003-02-03 15:18:41 | Database access problem : SOS |
| Previous Message | Tom Lane | 2003-02-03 14:32:27 | Re: Vacuum full hang => strace |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mjoseph | 2003-02-03 15:18:41 | Database access problem : SOS |
| Previous Message | Picrate | 2003-02-03 15:05:29 | Problem with files size in /var/lib/postgres/data/global on Debian Woody |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mjoseph | 2003-02-03 15:18:41 | Database access problem : SOS |
| Previous Message | Simon Mitchell | 2003-02-03 14:31:42 | Re: Creation of VIEWS not working.... |