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
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
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
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
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
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
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...
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.
Since which version PostgreSQL is able to do Vacuum Analyze
even in the middle of a transaction, namely, insert, delete,
update?
Thanks
Wei
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.
10 matches
Mail list logo