Re: postgres home directory

Hey,

>I have postgres running under RedHat 7.1 and was looking
>for the postgres file structure.  Its supposed to start
>at
>/usr/local/pgsql  with /bin, /data, /data/base... under
>it.  psql is supposed to be in the prsql directory -
>well
>it is in /usr/local with no pgsql directory.
>
>What commands might I use to find the rest of the
>postgres
>files?

Sounds like you installed them from RPM's.
If you have the RPM's still, you can run:

rpm -qpl <rpmfile>

It'll print out the files in the RPM's.

If it's already installed,

rpm -ql <rpmfile>

Produces this sort of output:

/usr/bin/createdb
/usr/bin/createlang
/usr/bin/createuser
/usr/bin/dropdb
/usr/bin/droplang
/usr/bin/dropuser
/usr/bin/pg_dump
/usr/bin/pg_dumpall
/usr/bin/psql
/usr/bin/vacuumdb
/usr/doc/postgresql-7.1
.............

HTH

-----------------
      Chris Smith
http://www.squiz.net/