Starting ProgreSQL server

From: "Richard Watt" <warren_tf_mcarthur(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Starting ProgreSQL server
Date: 2004-07-22 15:11:59
Message-ID: BAY15-F36b1iTDSwLHI000029a5@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<html><div style='background-color:'><DIV>
<DIV class=RTE>I've followed the installation instructions for 7.4.3 on Fedora Core 1 Linux on a Pentium II 233 system, and it's installed fine. I've instructed the configure tool to use TCP port 5321 during the installation.</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>I tried to create a test database with createdb, and this is the message I get:</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>createdb: could not connect to database template1: could not connect to server: Connection refused</DIV>
<DIV class=RTE>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Is the server running on host &lt;IP address&gt; and accepting <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP/IP connections on port 5321?<BR></DIV>
<DIV class=RTE>I've got PGHOSTADDR set to &lt;IP address&gt;, which is the correct address&nbsp;for my Linux machine, and PGPORT set to 5321, and the PostgreSQL server is set to start with the -i switch.</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>I can't think of anything else that it could be - I had it working before without specifying a port during the configuration phase, but I need the database running to test a customer's application, which is expecting the server to be listening to a specific port.</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>I haven't found anything else useful in the documentation other than setting PGHOSTADDR&nbsp;and PGPORT in the environment, but can anyone else come up with something I can check?</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>Thanks in advance,</DIV>
<DIV class=RTE>Richard Watt</DIV></DIV></div><br clear=all><hr>MSN Premium gives you PC protection, junk-mail filters, advanced communication tools and great software like MSN Encarta Premium. <a href="http://g.msn.com/8HMBENUK/2740??PS=47575">Click here for a FREE trial!</a> </html>

Attachment Content-Type Size
unknown_filename text/html 1.8 KB

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Hari Bhanujan 2004-07-22 17:16:00 trying to run a query
Previous Message Jean-Guillaume LALANNE 2004-07-22 12:23:46 2 postgresql processes on the same machine ?