Re: Starting Postgre
"Timo Lehtinen" <timo@suorakanava.fi> wrote in message news:<9kljoc$2is7$1@news.tht.net>...
I'am very new to linux and postgresql. I just intalled Redhat7.1. and
downloaded rpms and installed rpms. Now I'am stuck with startin the server
itself. What do I have to do after I have installed rpms? I found doc that
said I need to simply enter ../configure to configure server. What is
this command 'configure' where do I need to execute it?
"configure" is used when you're compiling the database from source
code, so you don't need to use it if you installed Red Hat binary RPMs
(filenames end with "i386.rpm")
To start the database server, log in as root, then type:
/etc/init.d/postgresql start
That should get it going.
If you want that to happen automatically on startup, do:
chkconfig --add postgresql
chkconfig --level 345 postgresql on
Then you need to create a user account for yourself. Do:
#log in as root
su -
#switch to postgres owner
su - postgres
#this assumes your login account is "timo"
#answer "yes" when asked if you can create databases and other users
createuser timo
log back in as yourself, and do:
createdb timo
psql
psql is a Linux-based PostgreSQl client - it defaults to a database
with the same name as the user who starts it.
That should be enough to get you started, I think.
Calvin
Import Notes
Reference msg id not found: 9kljoc$2is7$1@news.tht.net
On Mon, 6 Aug 2001 11:20:34 +0300, Timo Lehtinen <timo@suorakanava.fi> wrote:
Hello!
I'am very new to linux and postgresql. I just intalled Redhat7.1. and
downloaded rpms and installed rpms. Now I'am stuck with startin the server
itself. What do I have to do after I have installed rpms? I found doc that
said I need to simply enter ../configure to configure server. What is
this command 'configure' where do I need to execute it?
./configure
would only be used if you were building the software from source.
You would then follow up with
make [or gmake...]
make install
With RPM it is a different story...
It is possible the RPM installed a startup script to start the server
automatically when the system boots. On my FreeBSD machine it is in
/usr/local/etc/rc.d/
but I am sure that Red Hat stores those sort of things somewhere else.
If you cannot find the script, I suppose you could try rebooting and
see what happens. But I would recommend finding your postgres
executables and starting the server by hand. See if you have a
/usr/local/pgsql/bin
or try finding an executable file called
postgres
whereever you find that file, you should find one called
initdb
but again, not being familiar with RPM, that may have already happened.
you could try
man initdb
man postgres
man postmaster
Import Notes
Reference msg id not found: 9kljoc$2is7$1@news.tht.net | Resolved by subject fallback
Jep!
Thanks, It worked out for me.
And now how to congfigure database server as speedy as it could come? And
how to connct it with W2K odbc connection?
--
Timo
"Lee Harr" <missive@frontiernet.net> kirjoitti viestiss�
news:9kn67f$3oji$1@node21.cwnet.roc.gblx.net...
On Mon, 6 Aug 2001 11:20:34 +0300, Timo Lehtinen <timo@suorakanava.fi>
wrote:
Hello!
I'am very new to linux and postgresql. I just intalled Redhat7.1. and
downloaded rpms and installed rpms. Now I'am stuck with startin the
server
itself. What do I have to do after I have installed rpms? I found doc
that
Show quoted text
said I need to simply enter ../configure to configure server. What is
this command 'configure' where do I need to execute it?./configure
would only be used if you were building the software from source.
You would then follow up with
make [or gmake...]
make installWith RPM it is a different story...
It is possible the RPM installed a startup script to start the server
automatically when the system boots. On my FreeBSD machine it is in
/usr/local/etc/rc.d/
but I am sure that Red Hat stores those sort of things somewhere else.If you cannot find the script, I suppose you could try rebooting and
see what happens. But I would recommend finding your postgres
executables and starting the server by hand. See if you have a
/usr/local/pgsql/bin
or try finding an executable file called
postgreswhereever you find that file, you should find one called
initdb
but again, not being familiar with RPM, that may have already happened.
you could try
man initdb
man postgres
man postmaster
Import Notes
Reference msg id not found: 9kljoc$2is7$1@news.tht.net