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

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
Erwin PombettAsked:
Who is Participating?
 
earth man2Connect With a Mentor Commented:
looks like you need to set up the client authentication permissions in pg_hba.conf file.
0
 
earth man2Commented:
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
 
Erwin PombettAuthor Commented:
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
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Erwin PombettAuthor Commented:
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
 
Erwin PombettAuthor Commented:
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
 
Erwin PombettAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.