postgres – cottee.org

>Postgres – Converting Encodings

18 June 2008 ian Comments 0 Comment

>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…

>pg_top on Ubuntu Hardy – Postgres top utility

30 May 2008 ian Comments 3 Comments

>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…

>Cloning/copying postgres databases

15 May 2008 ian Comments 0 Comment

>Do createdb newdatabase -T olddatabase always forget this and end up dumping the old database and loading it into the new one. It takes a lot of time that way. This way is quicker.