Re: Querying the hostname of the server

Поиск
Список
Период
Сортировка
От Julio Leyva
Тема Re: Querying the hostname of the server
Дата
Msg-id BLU102-W2529897925D1499BB8B0CEA1F00@phx.gbl
обсуждение исходный текст
Ответ на Re: Querying the hostname of the server  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Список pgsql-admin
I think you can do something like that as a postgresql user

su - postgres
 
psql -c "\! uname -n"

or actually you can do that inside of any sql statement

psql
\!uname -n




> Date: Fri, 30 Apr 2010 09:14:04 -0500
> From: reedstrm@rice.edu
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Querying the hostname of the server
>
> On Fri, Apr 30, 2010 at 03:33:13PM +0200, Péter Kovács wrote:
> > Hi,
> >
> > I have a number of PostgreSQL servers which I often access through ssh
> > tunnel with Pgadmin3. I would like to double check which one I have landed
> > on (if the tunnel is really configured the way I want). Is there a way to
> > query the hostname from the catalogs?
>
> Hmm, that's a bit tricky, since I assume you're using a local db
> connection inside the tunnel, so inet_server_addr() probably returns
> null. If you're talking unix/linux machines, then /etc/hostname _should_
> have the current hostname in it, so:
>
> create temp table foo (t text);
> copy foo from '/etc/hostname';
> select * from foo;
> drop table foo;
>
> Should work.
>
> Ross
> --
> Ross Reedstrom, Ph.D. reedstrm@rice.edu
> Systems Engineer & Admin, Research Scientist phone: 713-348-6166
> The Connexions Project http://cnx.org fax: 713-348-3665
> Rice University MS-375, Houston, TX 77005
> GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Autovacuum stopped running
Следующее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Re: Autovacuum stopped running