[GENERAL] Comunication protocol
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 http://www.uci.cu attachment: Diagrama de despliegue.svg -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Comunication protocol
Karel Riveron Escobar kesco...@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
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
Re: [GENERAL] Comunication protocol
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 t...@sss.pgh.pa.us | To: Karel Riveron Escobar kesco...@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 kesco...@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
Re: [GENERAL] Comunication protocol
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 ach...@matrix.gatewaynet.com | To: pgsql-general@postgresql.org | Cc: Karel Riveron Escobar kesco...@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
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 kesco...@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 ach...@matrix.gatewaynet.com *To: *pgsql-general@postgresql.org *Cc: *Karel Riveron Escobar kesco...@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 http://www.uci.cu/ http://www.uci.cu/ - Achilleas Mantzios IT DEV IT DEPT Dynacom Tankers Mgmt http://www.uci.cu/ http://www.uci.cu/
Re: [GENERAL] Comunication protocol
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 ocalde...@solucionesaplicativas.com | To: Karel Riveron Escobar kesco...@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 kesco...@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 ach...@matrix.gatewaynet.com | | | | | | To: pgsql-general@postgresql.org | | | | | | Cc: Karel Riveron Escobar kesco...@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
Re: [GENERAL] Comunication protocol
On Sat, May 18, 2013 at 1:03 AM, Karel Riveron Escobar kesco...@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
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
Re: [GENERAL] Comunication protocol
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