LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-26-2009, 09:24 AM   #1
Girts
Member
 
Registered: Aug 2009
Location: Exeter, UK
Distribution: Ubuntu 11.04
Posts: 32

Rep: Reputation: 0
Unhappy Postgres data display problem


My first post here, and it seems like a weird problem.

I've used Postgres on W****** and it's been fine. Now I've moved over to Ubuntu completely and I have a problem reading the data in the boxes. All the headings, line numbers etc are fine - it's just the data that's illegible. It looks as if it's displaying at 50% of any other text on the screen. I've tried changing the font, the colour scheme, anything that could affect the appearance, but no joy.

Any thoughts anyone?
 
Old 08-27-2009, 09:32 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,916

Rep: Reputation: 7016Reputation: 7016Reputation: 7016Reputation: 7016Reputation: 7016Reputation: 7016Reputation: 7016Reputation: 7016Reputation: 7016Reputation: 7016Reputation: 7016
Quote:
Originally Posted by Girts View Post
My first post here, and it seems like a weird problem.

I've used Postgres on W****** and it's been fine. Now I've moved over to Ubuntu completely and I have a problem reading the data in the boxes. All the headings, line numbers etc are fine - it's just the data that's illegible. It looks as if it's displaying at 50% of any other text on the screen. I've tried changing the font, the colour scheme, anything that could affect the appearance, but no joy.

Any thoughts anyone?
No idea, since you don't say how you're retrieving the data, what you're displaying it with, or give any details about the process/programs you're using.

I'd check the data itself, from the postgres console, and run a query, to make sure you really ARE getting the right data. One thing, if you were using Windows, and migrated the data over...you may be enjoying some lovely Windows control characters in your import/dump file, that are causing your display woes. Check the dump file, and see what you can find...check it on the Linux system, though, not on the Windows box, since they'll not show up. You can use sed to strip out the junk (if you're doing a simple replace), and re-import the 'sanitized' file.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Text file data into Postgres database Sum1 Linux - Software 11 06-23-2009 04:10 PM
How to find out which tables are partitioned and info about data files in Postgres nautilus Linux - Server 0 01-14-2008 06:57 AM
retreived data and display data upon choice from first page? ati Programming 0 05-06-2006 05:43 AM
postgres data jamna17 Linux - Newbie 4 04-07-2004 05:45 AM
php postgres problem Xing Linux - Software 3 03-08-2004 12:22 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:51 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration