Обсуждение: Postgre and Redhat 7.0
Hello everyone I am a complete newbie to postgre. I am having a problem logging into the postgre user file in RH 7.0 when I try to do su postgre I get a bash prompt. Also on the postgre website the directories being used are different than the ones RH has set up where the documentation on the website suggests /usr/local/psgl/bin/psql RH has it setup as /var/lib/pgsql is it ok to use the lib directories for this or should I make directories and relocate the executable and othe files psql need. By the way I installed these as rpms from Redhat and they did a lot of things automatically and I have no clue as to what goes where. How do I log into the user postgre that redhat made for me. Are there any docs out there that will show me how to do this I have searched the net far and wide no luck and I cant seem to get the info from any of the man pages and docs that were included with the rpm's or am i looking in the wrong place. Any help[would be greatly appreciated I am using Postgre 7.0.2 and are there any websites out there that anyone can refer a clueless complete newbie to get up and running Postgre on a RH distro. Thanks in Advance SB
The only advice I can give you is the advice given to me when I was having trouble installing postgresql: INSTALL from the tarball and not the RPM. All kinds of little wierd problems went away when I did this. >Delivered-To: workshop@willysworkshop.com >Date: Wed, 07 Mar 2001 14:04:23 -0800 >From: Steve Bradley <skb2@we.mediaone.net> >X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.16-22 i586) >X-Accept-Language: en >To: pgsql-novice@postgresql.org >Subject: [NOVICE] Postgre and Redhat 7.0 >Sender: pgsql-novice-owner@postgresql.org > >Hello everyone I am a complete newbie to postgre. I am having a problem >logging into the postgre user file in RH 7.0 when I try to do su postgre >I get a bash prompt. Also on the postgre website the directories being >used are different than the ones RH has set up where the documentation >on the website suggests /usr/local/psgl/bin/psql RH has it setup as >/var/lib/pgsql is it ok to use the lib directories for this or should I >make directories and relocate the executable and othe files psql need. > >By the way I installed these as rpms from Redhat and they did a lot of >things automatically and I have no clue as to what goes where. How do I >log into the user postgre that redhat made for me. Are there any docs >out there that will show me how to do this I have searched the net far >and wide no luck and I cant seem to get the info from any of the man >pages and docs that were included with the rpm's or am i looking in the >wrong place. > >Any help[would be greatly appreciated I am using Postgre 7.0.2 and are >there any websites out there that anyone can refer a clueless complete >newbie to get up and running Postgre on a RH distro. > >Thanks in Advance > >SB > > >---------------------------(end of broadcast)--------------------------- >TIP 6: Have you searched our list archives? > >http://www.postgresql.org/search.mpl
Steve, I'm using pg at home on RH 7, but not intensively. What I discovered when I first tried to use it, as I recall, as loaded with the system, was that RH had not assigned a home directory to the postgres user. I don't recall the details, but I think there may've been other little problems like that, which I had to overcome before it was operational. As I said, however, I don't use it intensively at home, so I might not have encountered bugs buried a bit deeper. You may've gotten this advice already, but ... your best bet might be to learn how, build and install pg from source. Elsewise, you might want to use RH support to walk you through the solutions to the problems you're encountering with the RPM installation. regards, Eric On Wed, 7 Mar 2001, Steve Bradley wrote: > Hello everyone I am a complete newbie to postgre. I am having a problem > logging into the postgre user file in RH 7.0 when I try to do su postgre > I get a bash prompt. Also on the postgre website the directories being > used are different than the ones RH has set up where the documentation > on the website suggests /usr/local/psgl/bin/psql RH has it setup as > /var/lib/pgsql is it ok to use the lib directories for this or should I > make directories and relocate the executable and othe files psql need. > > By the way I installed these as rpms from Redhat and they did a lot of > things automatically and I have no clue as to what goes where. How do I > log into the user postgre that redhat made for me. Are there any docs > out there that will show me how to do this I have searched the net far > and wide no luck and I cant seem to get the info from any of the man > pages and docs that were included with the rpm's or am i looking in the > wrong place. > > Any help[would be greatly appreciated I am using Postgre 7.0.2 and are > there any websites out there that anyone can refer a clueless complete > newbie to get up and running Postgre on a RH distro. > > Thanks in Advance > > SB > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl > -- James Eric Lawson Research Publications Editor III National Simulation Resource eric@bioeng.washington.edu - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Everyday language is a part of the human organism and is no less complicated than it. - Ludwig Wittgenstein (1889-1951) [Tractatus Logico-Philosophicus, 1921]