Thread: Error Message
-- System Information --
Platform: Windows XP
Version: 5.1
Build: 2600 Service Pack 1
-- Application Information --
Name: pgAdmin II
Version: 1.5.60
Descripton:
Name: pgSchema
Version: 1.5.60
Descripton: PostgreSQL Schema Objects v1.5.60
-- Database Information --
Version: 0.0.0
Descripton:
-- Driver Information --
Name:
Version: 0.0.0
Descripton:
-- Error Information --
Description: Could not connect to the serverB
Could not connect to remote socket.
Number: -2147467259
Routine: pgAdmin II:frmConnect.cmdConnect_Click
************************************************************
Insert your comment:
Platform: Windows XP
Version: 5.1
Build: 2600 Service Pack 1
-- Application Information --
Name: pgAdmin II
Version: 1.5.60
Descripton:
Name: pgSchema
Version: 1.5.60
Descripton: PostgreSQL Schema Objects v1.5.60
-- Database Information --
Version: 0.0.0
Descripton:
-- Driver Information --
Name:
Version: 0.0.0
Descripton:
-- Error Information --
Description: Could not connect to the serverB
Could not connect to remote socket.
Number: -2147467259
Routine: pgAdmin II:frmConnect.cmdConnect_Click
************************************************************
Insert your comment:
Please let me know what is the error.
I am unable to connect to pgsql
I have issued this command to start
bash-2.05$ /usr/bin/pg_ctl -D /var/lib/pgsql/data/ -l logfile start
postmaster successfully started
bash-2.05$ cat logfile
DEBUG: database system was shut down at 2003-05-24 10:52:12 IST
DEBUG: CheckPoint record at (0, 1522080)
DEBUG: Redo record at (0, 1522080); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 615; NextOid: 18720
DEBUG: database system is in production state
postmaster successfully started
bash-2.05$ cat logfile
DEBUG: database system was shut down at 2003-05-24 10:52:12 IST
DEBUG: CheckPoint record at (0, 1522080)
DEBUG: Redo record at (0, 1522080); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 615; NextOid: 18720
DEBUG: database system is in production state
Thanks in advance
vcp
Quoting vcp <mvchalapathi@effone.net>: > -- Error Information -- > > Description: Could not connect to the serverB > Could not connect to remote socket. > Number: -2147467259 > Routine: pgAdmin II:frmConnect.cmdConnect_Click > > ************************************************************ > > Insert your comment: > > Please let me know what is the error. > > I am unable to connect to pgsql > > I have issued this command to start > > bash-2.05$ /usr/bin/pg_ctl -D /var/lib/pgsql/data/ -l logfile start Did you set the tcpip_sockets option in postgresql.conf to true? You must either do this, or include -i in your command line when starting the postmaster. Regards, Dave ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/