Comunication protocol

Karel Riveron Escobar <kescobar@estudiantes.uci.cu> writes:

I have a question. I think it's so simple to answer but I don't know anything about that. I want to know what is the comunication protocol among PostgreSQL database server and an application server like Apache. I have to know that because I'm designing a simple deployment diagram and I just need it for finish.

The protocol the PG server understands is specified here:

http://www.postgresql.org/docs/9.2/static/protocol.html

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

That would be postgresql:5432/TCP

On Παρ 17 Μαΐ 2013 10:54:02 Karel Riveron Escobar wrote:

Hi everyone:

I have a question. I think it's so simple to answer but I don't know anything about that. I want to know what is the comunication protocol among PostgreSQL database server and an application server like Apache. I have to know that because I'm designing a simple deployment diagram and I just need it for finish.

Thanks in advance.

Regards, Karel Riverón
Student Scientific Council
Informatics Science University

-
Achilleas Mantzios
IT DEV
IT DEPT

That would be postgresql:5432/TCP

On Παρ 17 Μαΐ 2013 10:54:02 Karel Riveron Escobar wrote:

Hi everyone:

I have a question. I think it's so simple to answer but I don't know anything about that. I want to know what is the comunication protocol among PostgreSQL database server and an application server like Apache. I have to know that because I'm designing a simple deployment diagram and I just need it for finish.

Thanks in advance.

Regards, Karel Riverón
Student Scientific Council
Informatics Science University

-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt

Thanks Tom for your response so fast. I'm reading r ight now and I found something but I didn't understood very well. In the documentation says that the protocol we're talking about is supported over TCP/IP family protocols, but doesn't says what exactly protocol is it? I want to know something more specific.

Thanks again.

Regards, Karel Riverón
Student Scientific Council
Informatics Science University
----- Original Message -----

| From: "Tom Lane" <tgl@sss.pgh.pa.us>
| To: "Karel Riveron Escobar" <kescobar@estudiantes.uci.cu>
| Cc: pgsql-general@postgresql.org
| Sent: Friday, May 17, 2013 10:56:35 AM
| Subject: Re: [GENERAL] Comunication protocol

| Karel Riveron Escobar <kescobar@estudiantes.uci.cu> writes:
| > I have a question. I think it's so simple to answer but I don't
| > know anything about that. I want to know what is the comunication
| > protocol among PostgreSQL database server and an application
| > server like Apache. I have to know that because I'm designing a
| > simple deployment diagram and I just need it for finish.

| The protocol the PG server understands is specified here:

| http://www.postgresql.org/docs/9.2/static/protocol.html

| regards, tom lane
| http://www.uci.cu

http://www.uci.cu

Thanks Achilleas, I think the same, but I'm not sure.

Saludos, Karel Riverón
Consejo Científico Estudiantil
Universidad de las Ciencias Informáticas

----- Original Message -----

| From: "Achilleas Mantzios" <achill@matrix.gatewaynet.com>
| To: pgsql-general@postgresql.org
| Cc: "Karel Riveron Escobar" <kescobar@estudiantes.uci.cu>
| Sent: Friday, May 17, 2013 11:01:16 AM
| Subject: Re: [GENERAL] Comunication protocol

| That would be postgresql:5432/TCP

| On Παρ 17 Μαΐ 2013 10:54:02 Karel Riveron Escobar wrote:

| Hi everyone:

| I have a question. I think it's so simple to answer but I don't know
| anything about that. I want to know what is the comunication
| protocol among PostgreSQL database server and an application server
| like Apache. I have to know that because I'm designing a simple
| deployment diagram and I just need it for finish.

| Thanks in advance.

| Regards, Karel Riverón
| Student Scientific Council
| Informatics Science University

| -
| Achilleas Mantzios
| IT DEV
| IT DEPT
| Dynacom Tankers Mgmt

http://www.uci.cu

Maybe you can use a software like Wireshark in your network and provoke a
connection between your PostgreSQL server and Apache server, and when you
see the results of traffic monitoring on Wireshark you can see more
specific details about the protocol.

Regards.

***************************
Oscar Calderon
Analista de Sistemas
Soluciones Aplicativas S.A. de C.V.
www.solucionesaplicativas.com
Cel. (503) 7741 7850

2013/5/17 Karel Riveron Escobar <kescobar@estudiantes.uci.cu>

Thanks Oscar. I'm going to try your suggestion but I get a problem. I get the database server and apache server in the same PC because the system what I'm building is in development phase. Do you think that is a problem for wireshark?

Regards, Karel Riverón
Student Scientific Council
Informatics Science University
----- Original Message -----

| From: "Oscar Calderon" <ocalderon@solucionesaplicativas.com>
| To: "Karel Riveron Escobar" <kescobar@estudiantes.uci.cu>
| Sent: Friday, May 17, 2013 11:23:01 AM
| Subject: Re: [GENERAL] Comunication protocol

| Maybe you can use a software like Wireshark in your network and
| provoke a connection between your PostgreSQL server and Apache
| server, and when you see the results of traffic monitoring on
| Wireshark you can see more specific details about the protocol.

| Regards.

| ***************************
| Oscar Calderon
| Analista de Sistemas
| Soluciones Aplicativas S.A. de C.V.
| www.solucionesaplicativas.com
| Cel. (503) 7741 7850

| 2013/5/17 Karel Riveron Escobar < kescobar@estudiantes.uci.cu >

| | Thanks Achilleas, I think the same, but I'm not sure.
|

| | Saludos, Karel Riverón
|
| | Consejo Científico Estudiantil
|
| | Universidad de las Ciencias Informáticas
|

| | | From: "Achilleas Mantzios" < achill@matrix.gatewaynet.com >
| |
|
| | | To: pgsql-general@postgresql.org
| |
|
| | | Cc: "Karel Riveron Escobar" < kescobar@estudiantes.uci.cu >
| |
|
| | | Sent: Friday, May 17, 2013 11:01:16 AM
| |
|

| | | Subject: Re: [GENERAL] Comunication protocol
| |
|

| | | That would be postgresql:5432/TCP
| |
|

| | | On Παρ 17 Μαΐ 2013 10:54:02 Karel Riveron Escobar wrote:
| |
|

| | | Hi everyone:
| |
|

| | | I have a question. I think it's so simple to answer but I don't
| | | know
| | | anything about that. I want to know what is the comunication
| | | protocol among PostgreSQL database server and an application
| | | server
| | | like Apache. I have to know that because I'm designing a simple
| | | deployment diagram and I just need it for finish.
| |
|

| | | Thanks in advance.
| |
|

| | | Regards, Karel Riverón
| |
|
| | | Student Scientific Council
| |
|
| | | Informatics Science University
| |
|

| | | -
| |
|
| | | Achilleas Mantzios
| |
|
| | | IT DEV
| |
|
| | | IT DEPT
| |
|
| | | Dynacom Tankers Mgmt
| |
|

http://www.uci.cu

On Sat, May 18, 2013 at 1:03 AM, Karel Riveron Escobar
<kescobar@estudiantes.uci.cu> wrote:

Thanks Oscar. I'm going to try your suggestion but I get a problem. I get the database server and apache server in the same PC because the system what I'm building is in development phase. Do you think that is a problem for wireshark?

From the documentation link that Tom provided you might have read that
the frontend/backend protocol which the database server and clients
connecting to it use - is a message based protocol in which the
messages are exchanged over either TCP/IP connection or UNIX doman
sockets. If you configure your client to use loopback interface
(127.0.0.1) to connect to the database you would be looking at a
TCP/IP connection, so probably manageable by Wireshark. Though, I
would suggest reading the protocol description in the documentation so
that you understand distinct phases of connection and subsequent
operation over the established connection.

--
Amit Langote

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 5/17/2013 8:15 AM, Karel Riveron Escobar wrote:

Thanks Tom for your response so fast. I'm reading right now and I
found something but I didn't understood very well. In the
documentation says that the protocol we're talking about is supported
over TCP/IP family protocols, but doesn't says what exactly protocol
is it? I want to know something more specific.

its postgresql protocol, transported over TCP, usually on socket 5432.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general