Обсуждение: suggestion/question pgpass alias?

Поиск
Список
Период
Сортировка

suggestion/question pgpass alias?

От
Caleb Cushing
Дата:
is it possible to support an alias for a pgpassfile? what I'm looking to do is

psql --alias company -h localhost

and not type anything else and get a shell.  if this is not possible could this be added?


--

Re: suggestion/question pgpass alias?

От
Alvaro Herrera
Дата:
On 2020-Jun-11, Caleb Cushing wrote:

> is it possible to support an alias for a pgpassfile? what I'm looking to do
> is
> 
> psql --alias company -h localhost
> 
> and not type anything else and get a shell.  if this is not possible could
> this be added?

I think what you want is a "service" file. See
https://www.postgresql.org/docs/current/libpq-pgservice.html

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



Re: suggestion/question pgpass alias?

От
Caleb Cushing
Дата:
Thanks!

On Thu, Jun 11, 2020 at 3:27 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
On 2020-Jun-11, Caleb Cushing wrote:

> is it possible to support an alias for a pgpassfile? what I'm looking to do
> is
>
> psql --alias company -h localhost
>
> and not type anything else and get a shell.  if this is not possible could
> this be added?

I think what you want is a "service" file. See
https://www.postgresql.org/docs/current/libpq-pgservice.html

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


--