LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-21-2010, 05:20 AM   #1
idrissess
LQ Newbie
 
Registered: Jul 2010
Location: Mahdia Tunisia
Distribution: fedora10
Posts: 20

Rep: Reputation: 0
Exclamation user postgres does not exist


HI;
i have installed postgresql to my fedora10-distribution.
when i would to access to this database by using the command #su postgres as is mentioned at http://www.freedom-ecm.org/freedom_3/install/wiff/createcontext
to install freedom , an error message is shown to tell me that user postgres does not exist.
what is the likely problem.
thx.
 
Old 07-21-2010, 05:23 AM   #2
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,672
Blog Entries: 29

Rep: Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917
Quote:
an error message is shown to tell me that user postgres does not exist.
Read & follow this tutorial about user creation etc.
http://www.yolinux.com/TUTORIALS/Lin...ostgreSQL.html
 
Old 07-21-2010, 07:01 AM   #3
idrissess
LQ Newbie
 
Registered: Jul 2010
Location: Mahdia Tunisia
Distribution: fedora10
Posts: 20

Original Poster
Rep: Reputation: 0
the version of the postgres installed is 8.3.8-fc10.i386. i open the directory /var/lib/pgsql but i can't found the file _bash.profile.
 
Old 07-21-2010, 07:14 AM   #4
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,672
Blog Entries: 29

Rep: Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917
I just installed postgresql-8.4.4-0.1.1.x86_64.rpm on my system and did as follows:

Code:
anisha@linux-uitj:~> su
Password:
linux-uitj:/home/anisha # su - postgres
postgres@linux-uitj:~>
I request that you do the same and tell the results here.
 
Old 07-21-2010, 07:20 AM   #5
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,672
Blog Entries: 29

Rep: Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917
Type postgres on your terminal and press enter and post the results here, to check whether you have installed it properly.

e.g.
Code:
anisha@linux-uitj:~> postgres
postgres does not know where to find the server configuration file.
You must specify the --config-file or -D invocation option or set the PGDATA environment variable.
 
Old 07-21-2010, 07:40 AM   #6
idrissess
LQ Newbie
 
Registered: Jul 2010
Location: Mahdia Tunisia
Distribution: fedora10
Posts: 20

Original Poster
Rep: Reputation: 0
yes it is the same result for me when i taped POSTGRES in my terminal. what should i do
 
Old 07-21-2010, 07:45 AM   #7
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,672
Blog Entries: 29

Rep: Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917
Read my Post number 4 and follow this :http://www.linuxquestions.org/questions/lqspy.php
 
Old 07-21-2010, 08:03 AM   #8
idrissess
LQ Newbie
 
Registered: Jul 2010
Location: Mahdia Tunisia
Distribution: fedora10
Posts: 20

Original Poster
Rep: Reputation: 0
this is the result of POSTGRES command :

postgres does not know where to find the server configuration file.
You must specify the --config-file or -D invocation option or set the PGDATA environment variable.

when i logged as root the result is:
"root execution of the postgresql server is not permitted.
the server must be started under an unprivileged user ID to prevent possible system security compromise. See the documentation for more information on how to properly start the server.


really i have not idea what must to do. i'm novice in linux.
 
Old 07-21-2010, 08:06 AM   #9
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,672
Blog Entries: 29

Rep: Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917
Kindly copy paste the exact commands you typed and the resulting error messages from the terminal for me to see !!!

Last edited by TheIndependentAquarius; 07-21-2010 at 08:09 AM.
 
Old 07-21-2010, 08:19 AM   #10
idrissess
LQ Newbie
 
Registered: Jul 2010
Location: Mahdia Tunisia
Distribution: fedora10
Posts: 20

Original Poster
Rep: Reputation: 0
[idriss@localhost data]$
[idriss@localhost data]$ su postgres
su: user postgres does not exist
[idriss@localhost data]$ postgres
postgres does not know where to find the server configuration file.
You must specify the --config-file or -D invocation option or set the PGDATA environment variable.
[idriss@localhost data]$ su
Password:
[root@localhost data]# postgres
"root" execution of the PostgreSQL server is not permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromise. See the documentation for
more information on how to properly start the server.
[root@localhost data]#
 
Old 07-21-2010, 08:21 AM   #11
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,672
Blog Entries: 29

Rep: Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917
Please Please Please, read the following 2 times , execute it and copy post the results here:

Code:
[idriss@localhost data]$
[idriss@localhost data]$ su
[root@localhost data]# su - postgres
 
Old 07-21-2010, 08:26 AM   #12
idrissess
LQ Newbie
 
Registered: Jul 2010
Location: Mahdia Tunisia
Distribution: fedora10
Posts: 20

Original Poster
Rep: Reputation: 0
[root@localhost ~]# su - postgres
su: user postgres does not exist

it is the same problem i mentioned at the beginning
 
Old 07-21-2010, 08:29 AM   #13
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,672
Blog Entries: 29

Rep: Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917
Read the second post of this thread:
http://www.forum.psoft.net/pda/index.php/t-4507.html

How did you install it ? through tar or rpm ?
 
Old 07-21-2010, 08:40 AM   #14
idrissess
LQ Newbie
 
Registered: Jul 2010
Location: Mahdia Tunisia
Distribution: fedora10
Posts: 20

Original Poster
Rep: Reputation: 0
rpm
 
Old 07-21-2010, 08:51 AM   #15
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,672
Blog Entries: 29

Rep: Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917
Alright I suggest that you uninstall current Postgres and install it again.

For knowing the package name:
Code:
rpm -qa | grep postgres
For uninstalling:
Code:
rpm -e package_name
For installing:
http://www.cyberciti.biz/faq/howto-f...gresql-server/

Last edited by TheIndependentAquarius; 07-21-2010 at 08:56 AM.
 
  


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
Unable to create new postgres user..! crash_override_me Linux - Server 2 06-06-2007 05:18 PM
samba - add user script - User account does not exist itzamecwp Linux - Server 2 01-18-2007 11:52 PM
su: user does not exist sdem Linux - Software 3 03-11-2006 07:21 AM
adding new user in postgres tvsskumar Linux - General 1 10-04-2004 10:18 AM
postgres user identification deadlock Linux - Software 1 01-16-2004 02:33 PM


All times are GMT -5. The time now is 10:47 AM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration