Re: Starting ProgreSQL server

From: "Hari Bhanujan" <hbhanujan(at)sbcglobal(dot)net>
To: <mad_mac(at)madasafish(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Starting ProgreSQL server
Date: 2004-07-22 17:18:05
Message-ID: 002201c4700f$da621d60$0600a8c0@Bhanujan.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

See if you have used the chmod and chown to make sure that it is running
with proper permissions

Chmod 777 (dir where postgresql is loaded)

Regards
Hari

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Richard Watt
Sent: Thursday, July 22, 2004 10:12 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Starting ProgreSQL server

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.

I tried to create a test database with createdb, and this is the message
I get:

createdb: could not connect to database template1: could not connect to
server: Connection refused
Is the server running on host <IP address> and accepting
TCP/IP connections on port 5321?
I've got PGHOSTADDR set to <IP address>, which is the correct address
for my Linux machine, and PGPORT set to 5321, and the PostgreSQL server
is set to start with the -i switch.

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.

I haven't found anything else useful in the documentation other than
setting PGHOSTADDR and PGPORT in the environment, but can anyone else
come up with something I can check?

Thanks in advance,
Richard Watt

_____

MSN Premium gives you PC protection, junk-mail filters, advanced
communication tools and great software like MSN EncartaR Premium. Click
here for a <http://g.msn.com/8HMBENUK/2740??PS=47575> FREE trial!

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-07-22 18:13:52 Re: Starting ProgreSQL server
Previous Message Hari Bhanujan 2004-07-22 17:16:00 trying to run a query