X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 429C39FA621 for ; Fri, 9 Jun 2006 10:36:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 32105-08 for ; Fri, 9 Jun 2006 10:36:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mailhub1.sghms.ac.uk (mailhub1.sghms.ac.uk [194.82.51.7]) by postgresql.org (Postfix) with ESMTP id 9E1F99FA61D for ; Fri, 9 Jun 2006 10:36:39 -0300 (ADT) Received: from [194.82.51.24] (helo=imail) by mailhub1.sghms.ac.uk with esmtp (Exim 4.60) (envelope-from ) id 1FohA7-0008AU-PJ; Fri, 09 Jun 2006 14:36:31 +0100 Received: from [172.16.20.3] (mrc1-003.sghms.ac.uk [172.16.20.3]) by imail.sghms.ac.uk (iPlanet Messaging Server 5.2 HotFix 2.10 (built Dec 26 2005)) with ESMTPA id <0J0L00773HSVWI@imail.sghms.ac.uk>; Fri, 09 Jun 2006 14:36:31 +0100 (BST) Date: Fri, 09 Jun 2006 14:36:54 +0100 From: Adam Witney Subject: Re: Database port changing issue In-reply-to: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com> To: Mohamed Fazil Cc: pg-admin postgre , magnus Message-id: <44897976.6080506@sgul.ac.uk> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: 7BIT User-Agent: Thunderbird 1.5.0.4 (Macintosh/20060530) X-Enigmail-Version: 0.94.0.0 References: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com> X-MailScanner-Information: Please contact sysadmin at sghms.ac.uk for more information X-MailScanner-MH1: No Virues detected X-MailScanner-SpamCheck: not spam, SpamAssassin (score=-1.34, required 5, autolearn=not spam, ALL_TRUSTED -1.44, POSTMASTER 0.10) X-MailScanner-From: awitney@sgul.ac.uk X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/64 X-Sequence-Number: 22026 > But i am getting an error as mentioned below > > *org.postgresql.util.PSQLException: Connection refused. Check that the > hostname and port are correct and that the postmaster is accepting > TCP/IP connections.* > ** > What are the changes that i have to do for changing port. > > If i am replacing it to *5432*, it is working fine. > > I had a great support and help from this mailing team and i expect the same. > did you reload the postgresql.conf file or stop/start the server after changing the port? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.