LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
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 12-16-2004, 11:56 AM   #1
alejandroye
Member
 
Registered: May 2004
Location: SOUTH FLORIDA USA
Distribution: MANDRIVA / CENTOS
Posts: 146

Rep: Reputation: 15
Postgres Intallation on drake 10.1


Hello all

I just installed drake 10.1 and I tried to install postgres unknowing that came w/the distro, so I downloaded from the website and I folowed the instructions

I run ./configure and showed me:

checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking which template to use... linux
checking whether to build with 64-bit integer date/time support... no
checking whether NLS is wanted... no
checking for default port number... 5432
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking how to turn off strict aliasing in gcc... -fno-strict-aliasing
configure: using CFLAGS=-O2 -fno-strict-aliasing
checking whether the C compiler still works... yes
checking how to run the C preprocessor... gcc -E
checking allow thread-safe client libraries... no
checking whether to build with Tcl... no
checking whether to build with Tk... no
checking whether to build Perl modules... no
checking whether to build Python modules... no
checking whether to build Java/JDBC tools... no
checking whether to build with Kerberos 4 support... no
checking whether to build with Kerberos 5 support... no
checking whether to build with PAM support... no
checking whether to build with Rendezvous support... no
configure: using CPPFLAGS=-D_GNU_SOURCE
configure: using LDFLAGS=
checking for gawk... gawk
checking for flex... no
configure: WARNING:
*** Without Flex you will not be able to build PostgreSQL from CVS or
*** change any of the scanner definition files. You can obtain Flex from
*** a GNU mirror site. (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this because the Flex
*** output is pre-generated.)
checking whether ln -s works... yes
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for ranlib... ranlib
checking for lorder... no
checking for tar... /bin/tar
checking for strip... strip
checking whether it is possible to strip libraries... yes
checking for bison... no
configure: WARNING:
*** Without Bison you will not be able to build PostgreSQL from CVS or
*** change any of the parser definition files. You can obtain Bison from
*** a GNU mirror site. (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this because the Bison
*** output is pre-generated.) To use a different yacc program (possible,
*** but not recommended), set the environment variable YACC before running
*** 'configure'.
checking for perl... /usr/bin/perl
checking for main in -lbsd... yes
checking for setproctitle in -lutil... no
checking for main in -lm... yes
checking for main in -ldl... yes
checking for main in -lnsl... yes
checking for main in -lsocket... no
checking for main in -lipc... no
checking for main in -lIPC... no
checking for main in -llc... no
checking for main in -ldld... no
checking for main in -lld... no
checking for main in -lcompat... no
checking for main in -lBSD... no
checking for main in -lgen... no
checking for main in -lPW... no
checking for main in -lresolv... yes
checking for library containing getopt_long... none required
checking for main in -lunix... no
checking for library containing crypt... -lcrypt
checking for library containing fdatasync... none required
checking for shmget in -lcygipc... no
checking for readline... no
configure: error: readline library not found
If you have readline already installed, see config.log for details on the
failure. It is possible the compiler isn't looking in the proper directory.
Use --without-readline to disable readline support.

what I suppose to do now, because after this I tried to do gmake and I got

You need to run the 'configure' program first. See the file
'INSTALL' for installation instructions.
gmake: *** [all] Error 1
[root@localhost postgresql-


what I have to do if postgres is already installed, how can start using postmaster and createdb?
somebody can help me

Also I test the following comands

createdb music
createdb: could not connect to database template1: FATAL: user "root" does not exist

postmaster
"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.

initdb -D
initdb: cannot be run as root
Please log in (using, e.g., "su") as the (unprivileged) user that will
own the server process.





thanks you

Last edited by alejandroye; 12-16-2004 at 12:05 PM.
 
Old 12-16-2004, 12:18 PM   #2
michaelk
Moderator
 
Registered: Aug 2002
Posts: 16,031

Rep: Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853
If postgresql is already installed then use Mandrake Control Center to start the service.

Use su to log on as the postgresql user. Login as root and then
su postgres

You can then initialize the database i.e. using initdb.
Add your regular user to postgresql
createuser username

Replace usernname with your real user name

Exit back and login as your regular user.
You can then create databases and use the psql frontend.

Documentation:
http://www.postgresql.org/docs/7.4/i...ive/index.html
 
Old 12-16-2004, 04:13 PM   #3
alejandroye
Member
 
Registered: May 2004
Location: SOUTH FLORIDA USA
Distribution: MANDRIVA / CENTOS
Posts: 146

Original Poster
Rep: Reputation: 15
that is the problem that I have, How can I be sure that postgres is in the system? and why I am having those error above

I tried run "service --status-all" and I check that postmaster is running
postmaster (pid 3334 3333 3329) is running...

that mean taht I have postgres in the system, how can I check whether it is

thanks
 
Old 12-16-2004, 04:40 PM   #4
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Well ... if configure failed you can't have run a
make && make install ... if postmaster is running
postgres MUST be installed by other means ...

do a
ps -ef | grep postmaster
to see where it lives


Cheers,
Tink
 
Old 12-17-2004, 08:46 AM   #5
alejandroye
Member
 
Registered: May 2004
Location: SOUTH FLORIDA USA
Distribution: MANDRIVA / CENTOS
Posts: 146

Original Poster
Rep: Reputation: 15
Yes, I did ps -ef | grep postmaster and I got

postgres 3329 1 0 Dec08 ? 00:00:01 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
root 26653 26194 0 09:32 pts/4 00:00:00 grep postmaster

this mean that posgres is running?


if not, Now what?, somebody help me ?
 
Old 12-17-2004, 10:26 AM   #6
michaelk
Moderator
 
Registered: Aug 2002
Posts: 16,031

Rep: Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853Reputation: 1853
See my previous post
 
Old 12-17-2004, 12:21 PM   #7
alejandroye
Member
 
Registered: May 2004
Location: SOUTH FLORIDA USA
Distribution: MANDRIVA / CENTOS
Posts: 146

Original Poster
Rep: Reputation: 15
sorry and thanks you michaelk, but sometime being NEWBIE need more explanation as answer the simple question

" yes, you have postgres installed and do
=============
Use su to log on as the postgresql user. Login as root and then
su postgres

You can then initialize the database i.e. using initdb.
Add your regular user to postgresql
createuser username

Replace usernname with your real user name

Exit back and login as your regular user.
You can then create databases and use the psql frontend.
================
it will more helpfull

thank you again, this tip help me a lot and I realized where I was stood
 
  


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
Newbie asking for intallation help user27519298 Yoper 4 03-16-2005 10:28 PM
Postgres package Intallation from drake 10.1 alejandroye Mandriva 11 01-31-2005 11:46 AM
kmess intallation nanabaffoe Linux - Software 1 08-10-2003 07:55 PM
Java / RH 9.0 intallation 777SPy Linux - Software 6 07-21-2003 05:46 PM
debian sx6000 intallation bizkit Linux - Hardware 0 05-25-2003 04:42 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 10:53 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