Re: VERY basic

paul wrote:

> I want to do some psq1 work and am setting it up on RH 7.2. I installed
> Postgres while installing. I also had apache, php, perl and some
> postgres gui interface (can't remember what it was). The problem . . .
> I guess just installing something doesn't mean it is operational. I
> looked at a tutorial and also the documentation and they both contain
> about the same information. They are about downloading the files and
> then doing the configure and make. This doesn't really apply since I
> have already gotten it downloaded, etc.
> Also, the directories mine is in is different than what is listed in the
> documentation. I found a /usr/include/pgsql/lib instead of the
> /usr/local. . . and also found a data library in
> /usr/lib/pgsql/local. There is also /usr/bin/psql. These all seem to
> be different than what the documentation talks about. They didn't
> actually go in to how to get things set up. I tried '/usr/bin/psql' and
> get the msg asking if the postmaster is running locally.
> There was a 'short version' of the setup :
>
> adduser postgres -- postgres is already a
> user
> su - postgres -- I did this
> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data -- this does
> not work, it tries to create the data directory and
>
> -- get a 'Permission denied' message
>
> -- I went back to root and chmod to 777 and still get
>
> -- permission message. Do I need to have 777 permission
>
> -- all the way down to /usr?
>
> -- So this is how far I got. But am hopeful with this.
>
> /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
>
> /usr/local/pgsql/bin/createdb test
> /usr/local/pgsql/bin/psql test
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----

So, I found the answer.

root# mkdir /usr/lib/pgsql/data
root# chown postgres /usr/lib/pgsql/data
root# su postgres
postgres> initdb -D /usr/lib/pgsql/data

Also, in the .bash_profile

PGLIB=/usr/lib/pgsql
PGDATA=/var/lib/pgsql/data
[ -f $PGDATA/../initdb.i18n ] && source $PGDATA/../initdb.i18n
export PGLIB PGDATA
PATH=$PATH:/usr/lib/pgsql/bin

This seems to make everyone happy.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----