On Mon, 18 Sep 2000, Tom Lane wrote regarding "Re: [GENERAL] Cant create new users or
databases":
> pg_shadow certainly should not be owned by root. It should be owned by
> the postgres user (ie, whoever the postmaster is running as, which you
> didn't say).
pg_shadow is now owned by postgres and so are the other
files in /var/lib/pgsql.
This time when I type postgres -D /var/lib/pgsql I get:
>Can't open pid file: /var/lib/pgsql/postmaster.pid
>Please check the permission and try again.
I have also checked the ownership of the folder, which is
also postgres. So I guess if nothing else will work then I
can only assume that PGSQL is pretty much broken and doesnt
go.
Thanks for your help anyway, at least it showed that a
couple of things needed to be put right
--
AlphaByte: PO Box 1941, Auckland, New Zealand
Specialising in:Graphic Design, Education and Training,
Technical Documentation, Consulting.
http://www.alphabyte.co.nz