Thread: Problem regarding starting PostgreSQL 7.3.1 on Windows 2000 Professional

Problem regarding starting PostgreSQL 7.3.1 on Windows 2000 Professional

From
"Dhaval Patel"
Date:
Hello,
   I am new to PostgreSQL. I downloaded binary installation file
PgSQL731wina1.exe for windows and trying to install it on windows 2000
professional. It installed correctly. Now when I start to PostgreSQL server,
it is started well but after that I got messages like :

PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
statistics collector process (pid 1480) exited with exit code 1

   I got these message heavily. My DOS screen was going full of this
messages. Each time, pid is different.

   I have installed the server from same file few days ago and it was
working perfectly. Yesterday suddenly I got messages. I uninstalled it and
reinstalled again. But the same thing.

   Please help me regarding this. I will appreciate greatly.

Regards,
Galu




_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


Granting permission for users to create users...

From
Ben Clewett
Date:
Novice PostgreSQL,

I'm trying to create a user who can create other users and grant
permissions to them.  The manual states this should work:

grant all on {object} to {user} with grant option;

But the reply I get is:

ERROR:  grant options are not implemented

How do I create a user with permissions to user the 'grant' option?

Regards,
Ben


Re: Granting permission for users to create users...

From
Bruno Wolff III
Date:
On Tue, Feb 18, 2003 at 13:18:36 +0000,
  Ben Clewett <B.Clewett@roadrunner.uk.com> wrote:
> Novice PostgreSQL,
>
> I'm trying to create a user who can create other users and grant
> permissions to them.  The manual states this should work:
>
> grant all on {object} to {user} with grant option;
>
> But the reply I get is:
>
> ERROR:  grant options are not implemented
>
> How do I create a user with permissions to user the 'grant' option?

That feature has been added to 7.4 (which isn't even in beta yet), but is
not available in 7.3.