LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General > LinuxQuestions.org Member Success Stories
User Name
Password
LinuxQuestions.org Member Success Stories Just spent four hours configuring your favorite program? Just figured out a Linux problem that has been stumping you for months?
Post your Linux Success Stories here.

Notices

Reply
 
Search this Thread
Old 04-24-2003, 06:08 PM   #1
TexasDex
Member
 
Registered: Feb 2003
Location: The Attic. Nowhere near Texas.
Distribution: Gentoo, Kubuntu, formerly LFS, SuSE, and RedHat
Posts: 133

Rep: Reputation: 15
Smile PostgreSQL horror finally over


Well I'd been working on trying to get an SQL database server running on my RedHat 8.0 machine. I started off knowing absolutely nothing about SQL except that it wasa database and it was needed for dynamic web pages, which I wanted. I installed it from the distro CD and made sure it would start up properly on boot. Then I tried to get into it. First of all the program wasn't started. Then I used the redhat services program to start it and tried the pgsql command. Invalid User. Damn. I tried to add an SQL user while logged in as root but it still wouldn't let me (still Invalid User). I then attempted to start it on my own because I knew that postgres makes a user based on the user who started it. But I couldn't start postmaster because it kept either saying:
1. Can't start pgsql as root
When I tried as my normal username:
2. Invalid database directory
3. Need RW permission for database directory, or
4. Database directory has world access
I checked several times to make sure that postgres was the owner of the right dir and the path passed to the postmaster command was correct but either it complained that it couldn't read or write to the directory or that too many people could. I tried to "su postgresql" but the user postgresql didn't exist. I also tried using the user options for the pgsql command, trying to log on to postgres as the right user, but I didn't know the password and I couldn't find it out from the RedHat user manager, even though the user postgres existed. I had just about given up when I realized that the name of the user wasn't postgresql, it was postgres. I used the su postgres command, made more users for my normal accounts, and Postgres is running just fine. Now if I only knew what to do with it...
 
Old 04-27-2003, 02:46 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,978
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
No offense meant, but how is this a success story? :)

Postgres documentation is quite clear on all the steps
to take, creation of the user postgres, permissions on
related folders ...

Cheers,
Tink
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
This is right out of a horror movie... rusty_slacker General 13 12-31-2005 04:26 AM
Horror GirlFirend Checking on my PC. novkhan Linux - Security 18 09-23-2005 01:06 AM
Power Outage horror Hampster Mandriva 5 01-13-2005 08:38 PM
synaptics touchpad horror beatupbilly Fedora 2 11-28-2004 04:51 AM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 02:50 AM


All times are GMT -5. The time now is 11:43 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration