[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Connection refused (0x0000274D/10061).
From:       Ashish Karalkar <ashishka () synechron ! com>
Date:       2009-02-27 5:23:21
Message-ID: 49A775F9.6090105 () synechron ! com
[Download RAW message or body]

najmuddin hassan wrote:
> 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
>  
>  
>  
>  
Do you have listen_adress in postgresql.conf set properly i.e. to the 
listen to the adress from where connection is comming or just *  to 
listen to all adresses.
this postgresql.conf file is in PG_DDIR


With Regards
--Ashish

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]