Thread: 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
comunicationprotocol among PostgreSQL database server and an application server like Apache. I have to know that
becauseI'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

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

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

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
thesame 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

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

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