Thread: Mac Address

Hi list,<br /><br />It is possible to retrieve the MAC Address of a computer using a Postgresql function like
others:<br/><br /><a
href="http://www.postgresql.org/docs/8.1/static/functions-info.html">http://www.postgresql.org/docs/8.1/static/functions-info.html
</a><br/><br />I can retrieve a ip of some statement connection but I didn't find how to get the MAC Address. Is it
possible?<br /><br /><br />Regards<br />Ezequias<br clear="all" /><br />-- <br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br
/>                                  Atenciosamente(Sincerely)<br />                        Ezequias Rodrigues da
Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é
melhordo que a melhor das ditaduras <br />The worst of democracies is still better than the better of dictatorships<br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a> 

Ezequias Rodrigues da Rocha написа:
> Hi list,
> 
> It is possible to retrieve the MAC Address of a computer using a Postgresql
> function like others:
> 
> http://www.postgresql.org/docs/8.1/static/functions-info.html
> 
> I can retrieve a ip of some statement connection but I didn't find how to
> get the MAC Address. Is it possible ?

No - the client and the server communicate using TCP/IP as
transport/internet layer but that does not mean they use Ethernet as
network access layer.


-- 
Milen A. Radev

On Sat, Sep 02, 2006 at 17:42:29 -0300, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> Hi list,
> 
> It is possible to retrieve the MAC Address of a computer using a Postgresql
> function like others:

MAC Addresses are generally only transferred within a subnet and you aren't
going to be able to get them in the general case.

> http://www.postgresql.org/docs/8.1/static/functions-info.html
> 
> I can retrieve a ip of some statement connection but I didn't find how to
> get the MAC Address. Is it possible ?

What is it that you are really trying to accomplish? There might be some
other solution than having to get the mac address of a remote computer.

Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> schrieb:

> Hi list,
> 
> It is possible to retrieve the MAC Address of a computer using a Postgresql
> function like others:

In the same subnet? Then you can use untrusted languages such as plperlu
or plsh to retrieve the MAC for a IP. (arp -a ip)

Btw.: please no HTML in eMails.


HTH, Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

I've install postgres in linux.
but pg_dump its not working at all.
if i execute the pg_dump to the file like this

pg_dump -Upostgres -dpostgres > file.dmp

the file file.dmp is empty

and if i execute the psql with list database option, the result is error 

-bash-3.00$ psql -l
ERROR:  relation "pg_catalog.pg_user" does not exist


can any one help me


Thanx


tosa

===================================================
PT. BANK ARTHA GRAHA INTERNASIONAL TBK. DISCLAIMER:
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager. This message contains confidential information
and is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake and delete this e-mail from your
system. If you are not the intended recipient you are notified that
disclosing, copying, distributing or taking any action in reliance on
the contents of this information is strictly prohibited.

On Tue, Sep 05, 2006 at 02:22:29PM +0700, M. Santosa wrote:
> and if i execute the psql with list database option, the result is error 
> 
> -bash-3.00$ psql -l
> ERROR:  relation "pg_catalog.pg_user" does not exist

This looks to me like you have more than one postmaster installed,
and you've got a mismatch in versions.  Be my first guess, anyway.  

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Users never remark, "Wow, this software may be buggy and hard 
to use, but at least there is a lot of code underneath."    --Damien Katz

"M. Santosa" <muhamad_santosa@ag.co.id> writes:
> I've install postgres in linux.
> but pg_dump its not working at all.
> -bash-3.00$ psql -l
> ERROR:  relation "pg_catalog.pg_user" does not exist

IIRC, this is a symptom of selinux having interfered with initdb.
Get a newer copy of the selinux policy package (or turn it off
temporarily) and redo initdb.  You can find more info if you search
our archives for "selinux".
        regards, tom lane