Browsed by
Tag: postgres

>Postgres – Converting Encodings

>Postgres – Converting Encodings

>I’ve run into a number of problems recently with dealing with old databases of ours which are encoded with LATIN1. Now, with postgres 8.3 (maybe before) you’ll get a message if you try to create LATIN1 saying something like createdb: database creation failed: ERROR: encoding LATIN1 does not match server’s locale en_US.UTF-8DETAIL: The server’s LC_CTYPE setting requires encoding UTF8. I got bored trying to work out why – it seems to be that postgres now prevents what it shouldn’t have…

Read More Read More

>pg_top on Ubuntu Hardy – Postgres top utility

>pg_top on Ubuntu Hardy – Postgres top utility

>This morning I got pgtop working but had some questions which I forwarded to the author Cosimo Streppone. In his very polite reply he pointed out I should really be using pg_top (note the hyphen) so I then set to getting that to work on Ubuntu Hardy Heron. Download the latest release from the site above (I downloaded pg_top-3.6.2.tar.gz) and then tar -zxpvf pg_top-3.6.2.tar.gz cd pg_top-3.6.2./configure make It’s very possible you might get some errors during this. The three I…

Read More Read More