Connection refused (0x0000274D/10061)

From: najmuddin hassan <najios1(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Connection refused (0x0000274D/10061)
Date: 2009-02-23 13:24:04
Message-ID: 12ae278c0902230524u7f5862ecgb4c9345ab4aba1b1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I just installed a program called moteview by crossbow technologies. It uses
postgreSQL 8.0.0-rc1 for its database. There is something wrong as when I
launched the program it automaticly gives me an error that the database is
not available. The postgreSQL database installation is bundled together with
installation disk. I read one of the mail discussion that that version of
sql is no longer supported so I upgrade to version 8.3. The moteview program
has a script called "resetdb.cmd" (script is given below) whereby as I
understand it is to set the database for the program as server : localhost,
database : task, user : tele, and password : tiny. When I run the
resetdb.cmd program. The error below shows up:

psql: could not connect to server: connection refused (0x0000274D/10061). Is
the server running on host "localhost" and accepting TCP/IP connection on
port 5432.

I not a database person. I "googled" the error msg and from my reading it
has something to do with authentication....

Can I have the solution to this matter. Thanks.

set PG_HOST=localhost
set PG_PORT=5432
set PG_USER=tele
set PG_PASS=tiny
set PG_DBASE=task
set PG_CONN=-h %PG_HOST% -p %PG_PORT% -U %PG_USER%

set PG_DDIR="C:\Program Files\PostgreSQL\8.3\data"
set PG_BIN="C:\Program Files\PostgreSQL\8.3\bin"
set PATH=%PG_BIN%; %PATH%

if '%1' == ' ' goto START
set PG_DDIR=%1\PostgreSQL\8.3\data
set PG_BIN=%1\PostgreSQL\8.3\bin
set PATH=%PG_BIN%;%PATH%

: START

echo %PG_BIN%
echo %PG_DDIR%
echo %PATH%

echo "Granting permissions to access database"
copy pg_hba.conf %PG_DDIR%
net start pgsql-8.3
sleep 5
pg_ctl reload -D %PG_DDIR%

echo "Setting up PostgreSQL 8.3 database for Moteview"
psql -e %PG_CONN% template1 < db_user.sql
psql -e %PG_CONN% %PG_DBASE% < db_moteview.sql
psql -e %PG_CONN% %PG_DBASE% < db_xsensor.sql
psql -e %PG_CONN% %PG_DBASE% < db_sample_mts310.sql

echo DATABASE CREATION FINISHED

Appreciate your help...

Regards,
Najios

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2009-02-23 13:33:32 Re: Connection refused (0x0000274D/10061)
Previous Message najmuddin hassan 2009-02-23 13:11:59 Connection refused (0x0000274D/10061).