473,320 Members | 1,950 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Server doesn't listen

hi,

i have postgresql 8.1 and it was running very well but to store another database i copied the data folder of another database to C:\Program Files\PostgreSQL\8.1\ on my system then started service but as soon as i type the password to connect to the postgre,its showes a window named Server not listing, in which following messages is showing

Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?
If you encounter this message, please check if the server you're trying to .......


i m not able to get what is the problem.
Feb 26 '07 #1
5 26702
michaelb
534 Expert 512MB
Did you look whether postgresql.conf you copied needs an update w.r.t. port number and other parameters?
Feb 26 '07 #2
gauravgmbhr
107 100+
ITS because u copied data from a different machine
it has a different settings of pg_hba.conf and possibaly postgre.cong

U need to add ur Own IP machine(given By 127.0.0.1), or may be port number:5432 to the conf files

next time when u want to copy data from another data base
try using the backup option(by ri8 clicking on the database) and creating a compressed backup and then moving the backup file
then creating a DB (with same name as the old one or the one u copied the dfata from )on the machine u wish to shift the data and then rib clicking on that database then use the restore option to get all data
Mar 1 '07 #3
I think my problem is similar to the other persons in this thread.
I also am not fully versed in the ways of the sql.
I am attempting to reinstall from a windows gone bad problem.
XP had "died" and unable bootinto os, so there was no backup or copy database made.

Have installed new hdd. copied most all of the old hdd to a "backup" folder on new hdd. I know of the program files ms sql data subdir.
System state.
XP professional , not sharing on network, so is like standalone pc.
sql is 8.0 ( the downloaded version that was part of the installation of a precreated data base.)
XP is now sp2 I do not think it was prior.
I copied the contents of the old data folder to the new folder, overwriting the install created db files.
error given when running data base is
This program cannot connect to your database file, cuttingedge_xpo.
Please make sure that your database is started and start Program again.

I contacted the “support” people of the db and they said a sql db cannot be moved / recovered except by back up and restore, which is impossible in this case.
I cannot believe a db product is “unrecoverable” from this.
Did I miss any other sql files like configs or is this just not possible.
I do not want to retype a lot.
May 31 '07 #4
michaelb
534 Expert 512MB
First make sure that your database server can be started.
If it is setup as Windows service it should start automatically, if not you can start it with pg_ctl

Bring up the Windows Task Manager and check if postgres.exe is listed among running processes.

You may also need to check on pg_hba.conf and postgresql.conf
Both files are located in the database directory (something like C:\Program Files\PostgreSQL\8.1\data)

Follow these links for more information on authentication and connection parameters
http://www.postgresql.org/docs/8.1/s...ntication.html
http://www.postgresql.org/docs/8.1/s...onnection.html

If server is running but you still cannot connect look at the database log, see if there are any messages there about rejected connections.
Then post all relevant info, including pg_hba.conf, postgresql.conf, the exact error message you are getting, and describe how exactly you trying to connect (psql at the DOS prompt, PGAdmin, some other application, etc)
Jun 5 '07 #5
In case you are using Windows 2000/XP check the properties of the user created when installed Postgres; for example, for the user 'postgres', you must set the option the "password never expires..." Once you have changed that, in Start -->Postgres 8.1-->click on Reload configuration.
Next in Control Panel...go to Services... and restart Postgres.

other thing to change can be the mask for your IP in pg_hba.conf: if there are some changes to the network, check your mask and change it. Example:

Mask 255.255.255.255 mask=32
Mask 255.0.0.0 mask=8
Mask = 255.255.0.0 mask =16

Hope it helps...
Dec 11 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: anuradha.k.r | last post by:
hi, i am writing a socket program in python,both client side and server side.I've written the client side which is working perfectly fine(checked it against server program written in C).but as for...
0
by: SRam | last post by:
I a writing Forking Server for a Small application.. This is code for multiplexing my $listen = IO::Socket::INET->new(Proto => 'tcp',LocalPort => 2323, Listen => 1, Reuse => 1) or die $!; ...
3
by: zeedan | last post by:
Hi, I appologise if I'm not posting this to the correct group, but I'm having problems starting MySQL server. I need it in order to post a websurvey for a research project I'm doing for a college...
2
by: learning_C++ | last post by:
Hi, I found some example code about server and client applications. But I can not run server and client in different computers. Now, I only run them in the different windows in Linux. I hope to...
2
by: Aquila Deus | last post by:
Hi all! I just tried to enable TCP/IP on SQL Server 2000 (trial, SP3a). The Server Network Utility shows it's already turned on, but after restarting the server doesn't listen to any TCP port,...
3
by: ferbar | last post by:
Hello all, This may sound pretty basic stuff.. but I'm working on a socket example whose client seems to work fine, but the server doesn't send to the client the expected result. The problem is...
34
by: antonyliu2002 | last post by:
I've set up the virtual smtp server on my IIS 5.1 like so: 1. Assign IP address to "All Unassigned", and listen to port 25. 2. Access Connection granted to "127.0.0.1". 3. Relay only allow...
4
by: Engineerik | last post by:
I am trying to create a socket server which will listen for connections from multiple clients and call subroutines in a Fortran DLL and pass the results back to the client. The asynchronous socket...
4
by: Patrick | last post by:
Hello, I'm currently trying the OpenSSL Library, but I got some problems. I want to create a server and client application that communicate through the OpenSSL API, but this code doesn't work. I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.