Network problem - PostgreSQL Database

I think I'm going insane.

In postgresql.conf I have:

tcpip_socket = true
In pg_hba.conf I have

host all all 0.0.0.0 0.0.0.0 trust
From the command line I run:

psql -h 10.3.4.110 bookreviews

(where 10.3.4.110 is the IP of the machine where pg is running and
obviously "bookreview s" is the name of my database)
I get:

psql: FATAL: no pg_hba.conf entry for host "10.3.4.110 ", user
"<USER>", database "bookreview s", SSL off

(where <USER> is my username)
If I run this:

psql bookreviews

It works fine, so it isn't the username or the database end. WHAT AM
I DOING WRONG??

I'm running from RPMs installed on RH 9. Oh, I also turned on the
logging and maxed debug up to 5 and all I get is the same thing the CL
shows me.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1

Subscribe Reply

1280

OK, everyone who is beating their head against a wall and/or having a
heart attack can stop now. I was editing backup copies I had made of
the conf files. Sorry. It works once I do it right.

---------- Forwarded message ----------
From: DU <de************ *@gmail.com>
Date: Sun, 12 Sep 2004 10:13:46 -0400
Subject: Network problem
To: pg***********@p ostgresql.org

I think I'm going insane.

In postgresql.conf I have:

tcpip_socket = true

In pg_hba.conf I have

host all all 0.0.0.0 0.0.0.0 trust

From the command line I run:

psql -h 10.3.4.110 bookreviews

(where 10.3.4.110 is the IP of the machine where pg is running and
obviously "bookreview s" is the name of my database)

I get:

psql: FATAL: no pg_hba.conf entry for host "10.3.4.110 ", user
"<USER>", database "bookreview s", SSL off

(where <USER> is my username)

If I run this:

psql bookreviews

It works fine, so it isn't the username or the database end. WHAT AM
I DOING WRONG??

I'm running from RPMs installed on RH 9. Oh, I also turned on the
logging and maxed debug up to 5 and all I get is the same thing the CL
shows me.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2

Similar topics

1683

Exception: General Network Error (!)

by: David Sworder | last post by:

Hi there, I am using the SQL managed provider in ADO.NET to fill a dataset with a large number of records. I periodically get an exception with the description "General Network Error" when trying to fill the dataset. The problem occurs rarely. I've searched Google and have seen many posts dealing with this problem. The typical culprits are: Network Problems: A bad cable, NIC, or router can cause this problem. In my case, however, both the...

.NET Framework

2050

Algorithm to identify network differences

by: kevin.hall | last post by:

I've got a problem where I have to identify differences in network. The network may have different types of nodes and may only have a string of ring-like topology: Code: A--B--C--D--E or

C / C++

9755

"Disk or network error"

by: David W. Fenton | last post by:

I'm no stranger to this error message, but I have a client who is experiencing it, but, fortunately, without any actual data corruption, and it's driving them made. Their inability to grasp that the cause is fundamentally a networking problem is also making me pull my hair out. Some history: The network is composed of five computers dating back to 1995, each purchased one at a time, and each having a different OS, etc. Until

Microsoft Access / VBA

2028

General Network Error - MS Stumped

by: Joe Ross | last post by:

I've been working with Microsoft support for over 3 weeks now on an intermittent General Network Error we're seeing in our production environment between our ASP.NET application and SQL Server 2000. They are continuing to work on the issue, but it seems as if our progress is grinding to a halt. I asked this question on the newsgroups before going to MS but figured I'd give it another shot now that I have more information. The problem...

ASP.NET

3033

Need process to detect if network is available

by: BJ | last post by:

Problem: How can I code up a client side process to detect if the network is available? Synopsis: I am writing ASP.NET input forms for a Panasonic Tuff book. The users will be walking around the plant with a wireless connection. There are some pockets of non-connectivity. I've been tasked with disabling the submit button on the form if the network is unavailable. Possible solution: I can instantiate a timed process (VB.NET 2.0

ASP.NET

34467

How to Dis/Enable Network Adapter?

by: rongchaua | last post by:

Hi all, i would like now to disable and enable network adapter programmatically with c#. I have searched but found nothing useful. There's no topic about this problem. Has someone done with this problem? All help will be appreciated. rongchaua.

C# / C Sharp

7093

Remote Desktop Affects Windows Application on network interruption

by: =?Utf-8?B?TVNU?= | last post by:

To demonstrate my problem, I have a very simple VB Windows application. It has a text box that is used to display a counter, a button to reset the counter, and a timer that increments the counter every second. I remote desktop to the computer hosting this application and run the application. It starts up and displays the counter incrementing every second. If I disconnect the network cable between the two computers for 10 seconds and...

.NET Framework

1959

What effect does a network card have with Access?

by: Salad | last post by:

If I work on my app on my standalone, things are always fast. If I have an non-split app on the network it runs fast. If I split the app and have both the front end and backend on the network the app's speed drops to a crawl. If I split the app have and make sure the MDBs use file names 8 chars and have a persistent link to the backend it's almost as fast has having a non-split app on the network...we're talking almost a .1 to .5...

Microsoft Access / VBA

6170

Disk or Network error on Terminal Server

by: gary0gilbert | last post by:

An unusual spin to this recurring disk or network error in a Terminal Server environment. Access 2000, Terminal Server 2000, file server is windows 2000. All users have a separate copy of the front end db, everyone accesses the back-end db via a network share. To preface, non Terminal Server users (4 or 5 in office) never have this problem. There are two Terminal Servers running win 2000, both basically identical. This error affects...

Microsoft Access / VBA

20650

A blocking operation was interrupted by a call to WSACancelBlockingCall -- can async I/O solve this problem? roburst network programming

by: Ryan Liu | last post by:

Hi, I have a 100 clients/ one server application, use ugly one thread pre client approach. And both side user sync I/O. I frequently see the error on server side(client side code is same, but I don't see the error): "System.IO.IOException: Unable to read data from the transport connection:A blocking operation was interrupted by a call to WSACancelBlockingCall"

C# / C Sharp

9734

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10408

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10137

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9211

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7673

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6895

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5561

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5700

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3026

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General