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)
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Richard Watt
Sent: Thursday, July 22, 2004 10:12 AM
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
I tried to create a test database with createdb, and this is the message
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,
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
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-07-22 18:13:52|
|Subject: Re: Starting ProgreSQL server |
|Previous:||From: Hari Bhanujan||Date: 2004-07-22 17:16:00|
|Subject: trying to run a query|