From wenhang.pan@qunar.com Tue Jul 28 16:42:00 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZK7x2-0000l7-HX for pgsql-admin@arkaria.postgresql.org; Tue, 28 Jul 2015 16:42:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZK7x2-0005Vw-3M for pgsql-admin@arkaria.postgresql.org; Tue, 28 Jul 2015 16:42:00 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZJyJB-0007Aq-PC for pgsql-admin@postgresql.org; Tue, 28 Jul 2015 06:24:13 +0000 Received: from [59.151.11.101] (helo=Exchange02.qunarservers.com) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZJyJ7-0000xE-FH for pgsql-admin@postgresql.org; Tue, 28 Jul 2015 06:24:11 +0000 Received: from Exchange11.qunarservers.com (192.168.38.249) by EXCHANGE02.qunarservers.com (192.168.23.12) with Microsoft SMTP Server (TLS) id 14.3.123.3; Tue, 28 Jul 2015 14:24:03 +0800 Received: from [192.168.168.109] (192.168.168.109) by Exchange11.qunarservers.com (192.168.39.94) with Microsoft SMTP Server (TLS) id 14.3.123.3; Tue, 28 Jul 2015 14:24:03 +0800 To: From: wenhang.pan Subject: multiple process of PostgreSQL running on the same port and same directory Message-ID: <55B71FFF.8080601@qunar.com> Date: Tue, 28 Jul 2015 14:23:59 +0800 User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.1.0 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------080806070705010005090105" X-Host-Lookup-Failed: Reverse DNS lookup failed for 59.151.11.101 (failed) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --------------080806070705010005090105 Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit This is the processes I catched: postgres 5260 0.0 0.0 1224332 37232 ? S Jul13 0:13 \ /opt/pg94/bin/postgres -D /export/pg940_data postgres 31193 0.0 0.0 1224332 976 ? Ss 00:20 0:00 \ /opt/pg94/bin/postgres -D /export/pg940_data I found the similar question: ps output shows multiple instances of PostgreSQL running on the same port , but I wanna konw when to fork a postmaster process, and what does it do. PostgreSQL version: postgres=# select version(); version -------------------------------------------------------------------------------------------------------------- PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit (1 row) Thanks. --------------080806070705010005090105 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 8bit This is the processes I catched:

--------------080806070705010005090105-- From avenpan92@gmail.com Tue Jul 28 16:40:28 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZK7vY-0000iF-6o for pgsql-admin@arkaria.postgresql.org; Tue, 28 Jul 2015 16:40:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZK7vX-0001L4-OG for pgsql-admin@arkaria.postgresql.org; Tue, 28 Jul 2015 16:40:27 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZJyMZ-0007Qa-0p for pgsql-admin@postgresql.org; Tue, 28 Jul 2015 06:27:43 +0000 Received: from mail-ob0-x22e.google.com ([2607:f8b0:4003:c01::22e]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZJyMS-00015s-52 for pgsql-admin@postgresql.org; Tue, 28 Jul 2015 06:27:41 +0000 Received: by obre1 with SMTP id e1so77169577obr.1 for ; Mon, 27 Jul 2015 23:27:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=yl3DcsXXFzsqJKNnjCBxgEsGS5aFrPo/lg+ihlOoiB8=; b=ghen/uKKmloucSJ5clOJUXJrBOk7jd2KdXO51vuN2t3NxuxwqS5s50atH0GZr/gJZI NuKMLsvZP26nAeFxOD3L8NN1I71kjgqIIwEhL7JRIp6Te9Io0pRahiXTl+YcX1YKxrm4 xxvKWtvpNNSKfYxHSD289zf/vp5SqPUzBuE0Og/uRM+eHc7cCZ8pTeF4FphUJK30NSq/ amtApwevpGnU2QJLmjJpF1v+9TCwLvDSTTfgGg8/RGSc41BSwGM/AWdyHuPIs0TIadx4 Ug7cjNO+BdEuxnAT3v0aLi3MME74ZOyUwispNaDSX72/cY7bWEgMw76zhyIXvlIW+glK hckw== MIME-Version: 1.0 X-Received: by 10.182.40.165 with SMTP id y5mr31762076obk.21.1438064854893; Mon, 27 Jul 2015 23:27:34 -0700 (PDT) Received: by 10.76.55.164 with HTTP; Mon, 27 Jul 2015 23:27:34 -0700 (PDT) Date: Tue, 28 Jul 2015 14:27:34 +0800 Message-ID: Subject: multiple process of PostgreSQL running on the same port and same directory From: aven pan To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=001a11c32e06d70ad5051be9901d X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --001a11c32e06d70ad5051be9901d Content-Type: text/plain; charset=UTF-8 This is the processes I catched: postgres 5260 0.0 0.0 1224332 37232 ? S Jul13 0:13 \ /opt/pg94/bin/postgres -D /export/pg940_data postgres 31193 0.0 0.0 1224332 976 ? Ss 00:20 0:00 \ /opt/pg94/bin/postgres -D /export/pg940_data I found the similar question: ps output shows multiple instances of PostgreSQL running on the same port , but I wanna konw when to fork a postmaster process, and what does it do. PostgreSQL version: postgres=# select version(); version -------------------------------------------------------------------------------------------------------------- PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit (1 row) Thanks. --001a11c32e06d70ad5051be9901d Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

This is the processes I catched:

postgres 5260 0.0 0.0 1224332 37232 ? S Jul13 0:13 \
/opt/pg94/bin/postgres -D /export/pg940_data

postgres 31193 0.0 0.0 1224332 976 ? Ss 00:20 0:00 \
/opt/pg94/bin/postgres -D /export/pg940_data

I found the similar question: ps output shows multiple instances of PostgreSQL running on the same port , but I wanna konw when to fork a postmaster process, and what does it do.

PostgreSQL version:
postgres=3D# select version();
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 version=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0
---------------------------------------------------------------------------= -----------------------------------
=C2=A0PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit
(1 row)

Thanks.

--001a11c32e06d70ad5051be9901d-- From avenpan92@gmail.com Tue Jul 28 06:43:47 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZJyc6-0007VI-Sy for pgsql-admin@arkaria.postgresql.org; Tue, 28 Jul 2015 06:43:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZJyc5-0003GO-Te for pgsql-admin@arkaria.postgresql.org; Tue, 28 Jul 2015 06:43:45 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZJyc5-0003GH-A2 for pgsql-admin@postgresql.org; Tue, 28 Jul 2015 06:43:45 +0000 Received: from mail-oi0-x234.google.com ([2607:f8b0:4003:c06::234]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZJyby-0001Oc-1Z for pgsql-admin@postgresql.org; Tue, 28 Jul 2015 06:43:43 +0000 Received: by oibn4 with SMTP id n4so63996091oib.3 for ; Mon, 27 Jul 2015 23:43:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=iscsn2jWFzltqksGwqan/W3VYoxYLziMr8Llp9WyxBI=; b=O/ArW/W+UxbfJJhIV6ogyBHShk+YODg2GBau2T2aeiMZL5bTeCzmYdQRBl1UNYEuBk J9yr+YOTsSgnvr3e3UObvtCGmL3ABOxyTtVeTvhcoT+ZSC65X1YCiPWjuDC4G/giKM0t ABcsooFa/R7aUKMMjq8dvBs5w+9o2z4PxrtYvrc+ChAD7wlKzY8GJw9xTn+hLvfNd7xx I9QPb/PRTR6nfD2S0/Jyh/Dn7dMoT+34A6/EYwNKwaMMCi7GydB6GQD1Hqaw5hkW/ERD OFvOZkiqnPJa7xEY+3S5WYIp/6iyG4Nz25g9RlTdIziYcsuIgj4aES+IL9fOv/La3Qa/ Addg== MIME-Version: 1.0 X-Received: by 10.202.182.65 with SMTP id g62mr30681761oif.85.1438065817122; Mon, 27 Jul 2015 23:43:37 -0700 (PDT) Received: by 10.76.55.164 with HTTP; Mon, 27 Jul 2015 23:43:37 -0700 (PDT) In-Reply-To: References: Date: Tue, 28 Jul 2015 14:43:37 +0800 Message-ID: Subject: Fwd: multiple process of PostgreSQL running on the same port and same directory From: aven pan To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=001a113cc552317bc6051be9ca80 X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --001a113cc552317bc6051be9ca80 Content-Type: text/plain; charset=UTF-8 This is the processes I catched: postgres 5260 0.0 0.0 1224332 37232 ? S Jul13 0:13 \ /opt/pg94/bin/postgres -D /export/pg940_data postgres 31193 0.0 0.0 1224332 976 ? Ss 00:20 0:00 \ /opt/pg94/bin/postgres -D /export/pg940_data I found the similar question: ps output shows multiple instances of PostgreSQL running on the same port , but I wanna konw when to fork a postmaster process, and what does it do. PostgreSQL version: postgres=# select version(); version -------------------------------------------------------------------------------------------------------------- PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit (1 row) Thanks. --001a113cc552317bc6051be9ca80 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

This is the processes I catched:

--001a113cc552317bc6051be9ca80--