Tom thank you for the reply. I believe I turned all that off during the install (no firewall). But I can try again. Is there an action I can take now since it is installed and in theory the RPM's are up2date. Sorry I have a few books on postgres Oreily and Sams, but it seems a bit deep on install.
At the very least I guess I can do a backup of the database, wipe everything /var/lib/pgsql/data and try the initd thing (verify SELinux is off; not sure how I do that, but I will look at the command you mentioned). I am very happy with my progress thus far (have most of my data coming over), but I am frustrated on my lack of knowledge. I have administered Linux before but its been several years and I don't remember much. I am very impressed with the progress with admin tools and such, I just wish I had a clear idea of the path to get a development postgres box up on fedora and am more then a little worried about administering the production (we ordered a 4 processor Dell with Red HAT, I believe I will also need to install it). Again thank you for that piece of advice, I can always re-install Linux and verify the SELinux option is off, maybe I messed up again. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments. -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, January 21, 2005 12:48 AM To: Joel Fradkin Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] still having pg_user error "Joel Fradkin" <[EMAIL PROTECTED]> writes: > Well I re-installed Fedora 3 and updated my postgres and started the = > service > (no command line stuff). > When I connected using pgadmin I still got the sp_user error. Fedora 3? You should've mentioned that before. I'll bet you've got SELinux enabled in enforcement mode. SELinux interferes with initdb and I believe a missing pg_user view is one of the symptoms. This is fixed in the very latest postgresql and selinux-policy-targeted RPMs (u need both), but the path of least resistance is often to dial SELinux down to permissive mode (sudo /usr/sbin/setenforce 0) for long enough to do the initdb. If you're running SELinux in strict rather than targeted policy, good luck ... I honestly haven't tried that one at all ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
