Thread: Database access problem : SOS

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

mjoseph@inautix.com writes:
> ipc-daemon &
> initdb -D /usr/local/pgsql/data -U 1730 -W
> psql -U 1730 template1

If this is PG 7.3.*, there are some recently-identified problems with
using all-numeric usernames.  Use a name instead of a number.

            regards, tom lane

Thanks Tom!
There seems to be something wrong with the cygipc package! I keep getting
this shmget() failure. I am pretty sure that there is enough memory on my
system. The best part is sometimes after reinstalling everything, it
sometimes works.

This is the failure message I get.
-----------------------------------------------------------------
$ postmaster -D /usr/local/pgsql/data -N 4 -B 16
IpcMemoryCreate: shmget(key=5432001, size=589824, 03600) failed: Not enough
core


This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space.
To reduce the request size (currently 589824 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 16) and/or
its max_connections parameter (currently 4).

The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.
-----------------------------------------------------------------

The versions I use:
cygipc-1.13-2
postgresql-7.3.1-1
cygwin-1.3.19-1

Can someone help?

I have been having a hard time installing PostgreSQL on Windows NT. I tried
a Native port, the official Windows version (on top of cygwin) and the one
that comes with cygwin. Something or the other is broken in each release. I
am yet to do a successful query till now.

I guess it works better on Unix, considering its popularity.

Regards,
Manoj




                    Tom Lane
                    <tgl@sss.pgh.p       To:     mjoseph@inautix.com
                    a.us>                cc:     pgsql-general@postgresql.org, pgsql-novice@postgresql.org,
                                          pgsql-admin@postgresql.org
                    02/03/03 09:15       Subject:     Re: [ADMIN] Database access problem : SOS
                    PM






mjoseph@inautix.com writes:
> ipc-daemon &
> initdb -D /usr/local/pgsql/data -U 1730 -W
> psql -U 1730 template1

If this is PG 7.3.*, there are some recently-identified problems with
using all-numeric usernames.  Use a name instead of a number.

                               regards, tom lane

mjoseph@inautix.com writes:
> There seems to be something wrong with the cygipc package! I keep getting
> this shmget() failure. I am pretty sure that there is enough memory on my
> system. The best part is sometimes after reinstalling everything, it
> sometimes works.

Did you remember to start the cygipc daemon?

I dunno much about using the cygwin-based port, but I do know that
that's a common gotcha...

            regards, tom lane