Re: Issues about postgresql file names

Started by Bruce Momjianover 25 years ago2 messagesgeneral
Jump to latest
#1Bruce Momjian
bruce@momjian.us

Is this of interest to anyone? He makes some good points.

With all the good features and interest in postgresql
as an alternative to Oracle, etc., why shoot yourself
in the foot with problems like this:

Trying to find info by search engine is hard
because the program is now called postgresql,
formerly postgres95,
formerly postgres.

The autoload script in
/etc/rc.d/init.d is called postgresql, but it
uses a pid called postmaster.pid.
It loads a binary called postgres,
but tells you that "postmaster" looks good.

The database is stored in PGDATA. (caps)

Okay, we are running, and we found our files:

It's pg_ctrl, and pg_dump,
pg_dump_all, pg_id,
pg_passwd, pg_upgrade
and pg_version.

So if you want to log on,
do you type pg_sql or pgsql?
Of course not! You type psql

What are the odbc files called? libpsqlodbc
And the tcl files are called? libpgtcl

And in case you don't have anything else to do, install
rpm binaries, because they will put the files in
different directories, so you won't find anything that
matches the official documentation.

Please put naming all the files consistently
on your todo list.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
#2Lamar Owen
lamar.owen@wgcr.org
In reply to: Bruce Momjian (#1)
Re: Re: Issues about postgresql file names

Bruce Momjian wrote:

Is this of interest to anyone? He makes some good points.

Trying to find info by search engine is hard
because the program is now called postgresql,
formerly postgres95,
formerly postgres.

Not much can be done about that at this juncture.

The autoload script in
/etc/rc.d/init.d is called postgresql, but it
uses a pid called postmaster.pid.
It loads a binary called postgres,
but tells you that "postmaster" looks good.

It uses pg_ctl, it doesn't directly load any binary, much less
'postgres'.

However, I _can_ make those other points more consistent.

So if you want to log on,
do you type pg_sql or pgsql?
Of course not! You type psql

pg_sql or pg_isql might work there. Although I personally have no
complaints with psql.

And in case you don't have anything else to do, install
rpm binaries, because they will put the files in
different directories, so you won't find anything that
matches the official documentation.

I guess I need to submit RPM patches to the official documentation in
addition to the README.rpm in the RPM documentation (which you have to
see in order to find the installed documentation).

Please put naming all the files consistently
on your todo list.

Laudable goal; is it practical?
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11