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
1,039 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_
  • 4
  • 2
6 Comments
 
LVL 22

Expert Comment

by:earth man2
Comment Utility
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_
Comment Utility
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_
Comment Utility
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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 22

Accepted Solution

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

Author Comment

by:toshi_
Comment Utility
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_
Comment Utility
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
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…
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.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now