Thread: Re: Issues about postgresql file names

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

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