LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 10-15-2003, 01:43 PM   #1
bruce64
LQ Newbie
 
Registered: Jul 2003
Posts: 11

Rep: Reputation: 0
Postgres installation initdb problem


Good afternoon everyone,
I am setting up Postgresql on my redhat 8 system. I have installed the files and have set up the proper directories, however I have run into a problem. I am trying to initialize the database with initdb. The command is

pg$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

I did not have a bin in that first half of the statement so in locating initdb, I found it in the dire /usr/bin. I then used the following line:

pg$ /usr/bin/initdb -D /usr/local/pgsql/data

After running the line above, I got a message saying success! I then started the postmaster and again everything went fine. However I need to create users for this database so I use the following command:

pg$ /usr/local/pgsql/bin/createuser bruce

I get an error stating there is no such directory. The question is, how do I get the postgres bin created? Also I am guessing that the bin should have commands that are specific to postgresql. Is there a way for me to import this bin from /usr/bin ? Any help is greatly appreciated. Thanks!

Bruce
 
Old 10-15-2003, 02:04 PM   #2
jpbarto
Senior Member
 
Registered: Mar 2003
Location: Pittsburgh, PA
Distribution: Gentoo / NetBSD
Posts: 1,251

Rep: Reputation: 45
I'm not sure exactly what the problem may be... however the createuser is just a shell script. You could take a look at its internals to find out what it may be doing that would cause a 'no such directory' error.

If you can provide more information, particularly *exactly* what the returned error is I may be able to help a bit more. Also do you get this error before or after answering the two permission questions of whether the user can add / del tables and add / del users?

jpbarto
 
Old 10-16-2003, 02:52 PM   #3
bruce64
LQ Newbie
 
Registered: Jul 2003
Posts: 11

Original Poster
Rep: Reputation: 0
Talking Answering my own question

Thanks for the reply jb! I was fooling around with the createuser script. Bottom line, there is supposed to be a bin in the following path /usr/local/pgsql/bin In this bin is where are the postgres scripts should be. However during my installation I did not end up with a "bin" in the pgsql directory. Knowing where the postgres scripts reside (/usr/bin/) I can execute everything I need. The trick of course will be to set up the postmaster to start up on log in. That maybe my next post to the group. If anyone is curious as to this problem in detail, I would be happy to explain it in full. Take care!

Bruce
 
Old 10-16-2003, 02:55 PM   #4
jpbarto
Senior Member
 
Registered: Mar 2003
Location: Pittsburgh, PA
Distribution: Gentoo / NetBSD
Posts: 1,251

Rep: Reputation: 45
Good, glad you got it going.
 
  


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
Postgres Login Problem aarajthomas Linux - Security 3 12-08-2005 09:00 AM
Easiest way to Add Postgres to existing fedora core 3 installation? gfallon Linux - Newbie 2 03-20-2005 01:15 AM
postgres initdb questions! doubleone Linux - Software 2 03-07-2005 09:19 PM
POSTGRES Installation on Linux gvsprasad Linux - Enterprise 2 09-01-2004 02:06 PM
PostGres Installation.... gvsprasad Linux - Enterprise 1 09-01-2004 06:29 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:14 PM.

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