Re: [SQL] Which version of PostgreSQL should I use.

2011-05-24 Thread Craig Ringer
On 24/05/11 14:30, jasmin.dizdare...@gmail.com wrote: We had trbls with our drupal site, because some settings are stored in bytea columns. I think lobs are a problem too, but pls see the pg_dump docs for details. Is it possible that you are referring to the `bytea_output' setting in

Re: [SQL] Which version of PostgreSQL should I use.

2011-05-24 Thread Jasmin Dizdarevic
Alright, I've misunderstood this issue. Do you have to escape bytea columns during export or import? And how you would do this? Ty 2011/5/24 Craig Ringer cr...@postnewspapers.com.au On 24/05/11 14:30, jasmin.dizdare...@gmail.com wrote: We had trbls with our drupal site, because some

Re: [SQL] Which version of PostgreSQL should I use.

2011-05-24 Thread Craig Ringer
On 24/05/11 18:58, Jasmin Dizdarevic wrote: Alright, I've misunderstood this issue. Do you have to escape bytea columns during export or import? And how you would do this? Some database drivers and some apps don't understand the new hex output format for bytea columns. IIRC, the format change

Re: [SQL] Which version of PostgreSQL should I use.

2011-05-23 Thread Gavin Baumanis
Just thought I would update this myself. Last night I managed to have a chat with some people about this on IRC. Turns out we're in pretty good shape. We already know about the changes to implicit casting and we have always used UTF-8 for encoding, too. So the changes from 8.4 don't seem to be

Re: [SQL] Which version of PostgreSQL should I use.

2011-05-23 Thread jasmin . dizdarevic
09:10:17 To: Gavin Baumanisgav...@thespidernet.com Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Which version of PostgreSQL should I use. Just thought I would update this myself. Last night I managed to have a chat with some people about this on IRC. Turns out we're in pretty good shape. We

Re: [SQL] Which version of PostgreSQL should I use.

2011-05-23 Thread Craig Ringer
On 23/05/2011 11:19 PM, jasmin.dizdare...@gmail.com wrote: Just be careful with pg_dump, if you have binary data stored in your 8.4 db. In default mode it just export text. Er ... what? Can you elaborate on that? Do you mean large objects? bytea fields? Something else? -- Craig Ringer

[SQL] Which version of PostgreSQL should I use.

2011-05-21 Thread Gavin Baumanis
Hi there, Let me first preface this with, I am not a PostgreSQL admin. I am a web developer who happens to use PSQL as the back-end for my company's app. We did have a dedicated DBA / system admin - but he has recently resigned. I know enough about psql - to be able to create / drop databases...

Re: [SQL] Which version of PostgreSQL should I use.

2011-05-21 Thread Basil Bourque
We're currently using psql 8.1 and are on the way to upgrading to 8.4. The tools pg_dump pg_restore are used to extract and re-create databases. Can be used for chores such as deploying from development to production, backing up, and upgrading.

[SQL] Which version is this?

2003-01-31 Thread Wei Weng
Since which version PostgreSQL is able to do Vacuum Analyze even in the middle of a transaction, namely, insert, delete, update? Thanks Wei

Re: [SQL] Which version is this?

2003-01-31 Thread Rajesh Kumar Mallah.
your question doesnt' seem to be very clear. But the following appeared in release note of version 7.2 hope it helps regds mallah. ` A.5. Release 7.2 Release date: 2002-02-04 A.5.1. Overview This release improves PostgreSQL for use in high-volume applications.