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:

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