Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

when if I try to look at pgAdmin->Tools->Server Status, i have pop up Error: " invalid ...UTF8:0xe9204a

Posted on 2013-06-05
6
Medium Priority
?
1,100 Views
Last Modified: 2013-06-13
Hello experts,

My working box:
- MS.seven machine
- postgresql 9.1 - x64

i'm stuck with an issue on my pgAdmin.
If i go to the Server status in pgAdmin menu i have pop ups that fullfill my screen....they come up very often.

I need to diagnostic my problem but i dont know where to start with.
basically we have two postgresql servers. server A is exposed and will write to server B.

i would like some explanations on how to point out the error.

B:
- has client_encoding by default.
- here's a part in config of B that has todo with encodings.

# These settings are initialized by initdb, but they can be changed.
lc_messages = 'us_US'                  # locale for system error message
                              # strings
lc_monetary = 'French_Switzerland.1252'                  # locale for monetary formatting
lc_numeric = 'French_Switzerland.1252'                  # locale for number formatting
lc_time = 'French_Switzerland.1252'                        # locale for time formatting

# default configuration for text search
default_text_search_config = 'pg_catalog.french'


thank you in advance for your help,
one of my problèms with date is that i have triggers that are not triggering all the time as i expected, so i'm trying to solve this encoding problem first.
I suppose that this problem can be the source for the triggers that are not triggering all the time.


toshiro
0
Comment
Question by:toshi_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 22

Expert Comment

by:earth man2
ID: 39224060
If you need trigger to call every row as opposed once per statement then make sure you use
FOR EACH ROW
clause when you create a trigger.

You don't have to use pgAdmin to manage a database ...
0
 

Author Comment

by:toshi_
ID: 39224801
Hello earthman2,

thank you for your answer,

i have a "FOR EACH ROW" ...
i know now that the problèm with the trigger was a psql code problem, i corrected it's ok , it works.


Of course it's possible to manage postgresql server without pgAdmin, btw i love CLI.
but how can you replace, or what do you use to replace,  the "server status" view ?  
it's on that view that i have my encoding pop up that shows up with the error.

Could you help me on understand the problem, i'm looking for informations(commands, tools)  that would help me to diagnose the problem.
As already said, this is a postgresql server that receives queries from two other windows machines, the .net code on those machines, uses Npgsql to connect to postgresql server and pass infos.

What is important concerning encoding ?
what is "client_encoding" in "postgresql.conf" ?
does this has to match the Npgsql connection string which has the encoding info for the connection object ?
what to has to match with what ? in our case, we have utf8 and sql_ascii databases on the same postgresql server.
Do this configuration has to take in count the collation or character type ?

thank you in advance for your help,
toshiro,
0
 

Author Comment

by:toshi_
ID: 39225064
this is a sample of my logs, this are the errors that  i can read in c:\pro_files\PotgreSQL\9.1\data\ pg_log. As you can see on timestamp, they come very often.

how can i know what 's doing this ?

      
2013-06-06 00:34:20 CEST LOG:  unexpected EOF on client connection
2013-06-06 00:34:20 CEST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

      
2013-06-06 00:34:20 CEST LOG:  unexpected EOF on client connection
2013-06-06 00:34:20 CEST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

      
2013-06-06 00:34:20 CEST LOG:  unexpected EOF on client connection
2013-06-06 00:34:20 CEST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

      
2013-06-06 00:34:20 CEST LOG:  unexpected EOF on client connection
2013-06-06 00:34:20 CEST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

      
2013-06-06 00:34:20 CEST LOG:  unexpected EOF on client connection
2013-06-06 00:34:20 CEST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

      
2013-06-06 00:34:20 CEST LOG:  unexpected EOF on client connection
2013-06-06 00:34:20 CEST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

      
2013-06-06 00:34:20 CEST LOG:  unexpected EOF on client connection
2013-06-06 00:34:20 CEST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

      
2013-06-06 00:34:20 CEST LOG:  unexpected EOF on client connection
2013-06-06 00:34:20 CEST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

      
2013-06-06 00:34:20 CEST LOG:  unexpected EOF on client connection
2013-06-06 00:34:20 CEST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

      
2013-06-06 00:34:20 CEST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

      
2013-06-06 00:34:20 CEST LOG:  u
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 22

Accepted Solution

by:
earth man2 earned 1500 total points
ID: 39226068
looks like you need to set up the client authentication permissions in pg_hba.conf file.
0
 

Author Comment

by:toshi_
ID: 39239332
hello earthman.

thank you for your answer...
i've changed the logs...i expect to catch who's trying to write to the server and is refused.

i'll be back,
toshi
0
 

Author Closing Comment

by:toshi_
ID: 39243924
my question was more about to check and configure the encoding of postgresql which receives communications from npgsql.
I probably was not enough clear with my goal.  Anyway, the targeted problem is now corrected.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question