Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 24C0264FCD2 for ; Thu, 11 Sep 2008 15:14:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39653-06 for ; Thu, 11 Sep 2008 15:14:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.174]) by postgresql.org (Postfix) with ESMTP id 8582A650094 for ; Thu, 11 Sep 2008 15:14:35 -0300 (ADT) Received: by wf-out-1314.google.com with SMTP id 25so421201wfc.28 for ; Thu, 11 Sep 2008 11:14:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=k3w3zIc/udN55OoOPitWvssO990vrs32cMO0uVRFa54=; b=wfRgVJrAAC1extvNODNwDzzMfY86Pbjy8Do6hkAdzjunqY4WXfCLzuyaVffCZ3uYfq CPIs3SuFfQKmdLTfARfQrdw3x7BfRhLFZXoEh+rptJ4bezTVwqbenXoWTsVM0bTODWtg A488ebmEFfXtHjs3GdqrmC8Zsf9plVxgLO+8U= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=HaM9oGcuKQFjuamEZPkGTXUPLC+nyBkRwDFaowu2xo379YSiEn4FgD4XHca9p3GBzl OegBYZW/g2sSediLnRCsaCJbY0J8JqndKL6eUbSV1v5pqoYQG9npziuxDIVDRKvp6GY2 q91cxWc19muwubej94L76CrD7xAG7ig7qMMUY= Received: by 10.140.148.3 with SMTP id v3mr1996202rvd.57.1221156874544; Thu, 11 Sep 2008 11:14:34 -0700 (PDT) Received: by 10.141.74.11 with HTTP; Thu, 11 Sep 2008 11:14:34 -0700 (PDT) Message-ID: Date: Thu, 11 Sep 2008 12:14:34 -0600 From: "Scott Marlowe" To: John Subject: Re: starting postgres on red hat Cc: "pgsql-admin@postgresql.org" In-Reply-To: <48C95701.400@johndubchak.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <48C95701.400@johndubchak.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/104 X-Sequence-Number: 30197 On Thu, Sep 11, 2008 at 11:36 AM, John wrote: > Scott Marlowe wrote: >> >> Oh yeah, please note that the proper way to start and stop services on >> RH oses is via the service command: >> >> service postgresql start >> service postgresql initdb >> >> etc.. > > Scott, > > How does the above compare with using postmaster to start Postgres? > > I tried in the past to use the "service postgresql start" command, but > couldn't connect from a java application and have gotten in the habit of > using a script that uses postmaster to append a "-i" to the command line to > allow TCP/IP connections. Yeah, you can't stop / stop services as anything but root on centos. so unless you were running the receiving end to the java app as root, it wouldn't be able to restart pgsql. On ubuntu the postgres account can restart with /etc/init.d/postgresql, nice feature. > Can that be configured in postgresql.conf? Yes, it's the line where you tell it what host adapters to use, or on older pgsql's also the tcp_connection parameter (I think I spelt it right, been a while)