Обсуждение: Where is the system-wide psqlrc on RHEL4?

I've tried various places, and none seem to work.  I've even done a
"strings `which psql` | grep psqlrc" to no avail.

"Dean Gibson (DB Administrator)" <postgresql@ultimeth.com> writes:
> I've tried various places, and none seem to work.  I've even done a
> "strings `which psql` | grep psqlrc" to no avail.

"pg_config --sysconfdir" would tell you.  I agree the documentation
on this is less than clear.

            regards, tom lane

-bash: pg_config: command not found

It's not installed in the base/server/libs RPMs.  I had to search the
uninstalled PostgreSQL RPMs for it, and then (temporarily) install the
"devel" RPM to run it.  For CentOS 4.4 & RHEL4, the system-wide psqlrc
is in /etc/sysconfig/pgsql/

-- Dean

On 2008-02-09 18:45, Tom Lane wrote:
> "Dean Gibson (DB Administrator)" <postgresql@ultimeth.com> writes:
>
>> I've tried various places, and none seem to work.  I've even done a
>> "strings `which psql` | grep psqlrc" to no avail.
>>
>
> "pg_config --sysconfdir" would tell you.  I agree the documentation
> on this is less than clear.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

On 10/02/2008, Dean Gibson (DB Administrator) <postgresql@ultimeth.com> wrote:
> It's not installed in the base/server/libs RPMs.  I had to search the
> uninstalled PostgreSQL RPMs for it, and then (temporarily) install the
> "devel" RPM to run it.  For CentOS 4.4 & RHEL4, the system-wide psqlrc
> is in /etc/sysconfig/pgsql/
Another alternative (quick & dirty) would have been to
strace -o whereisit psql
and
grep psqlrc whereisit


> -- Dean
Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm