Hi,
Craig Ringer wrote:
Brent Wood wrote:
...
I need to store
an image in postgresql database and after that i need to retrive the
image back.Can you please help me how to do this?
...
- Storing image data in the DB is probably much less efficient in
storage space and for access
Brent Wood wrote:
aravind chandu <[EMAIL PROTECTED]> 07/08/08 10:30 AM >>>
> Hello,
>
> I need to store
> an image in postgresql database and after that i need to retrive the
> image back.Can you please help me how to do this?
>
>
>
> Hi,
>
> I have been involved in building a f
Tom Lane wrote:
spellberg_robert <[EMAIL PROTECTED]> writes:
i was wondering: what was it ?
further, is this, per_chance, described, in excruciating detail,
in a location where i did not tread ?
Did you read the 8.3.3 release notes?
http://www.postgresql.org/docs/8.3/static/release-8-3-3
>>> aravind chandu <[EMAIL PROTECTED]> 07/08/08 10:30 AM >>>
Hello,
I need to store
an image in postgresql database and after that i need to retrive the
image back.Can you please help me how to do this?
Hi,
I have been involved in building a few applications to manage this capability
spellberg_robert <[EMAIL PROTECTED]> writes:
> i was wondering: what was it ?
> further, is this, per_chance, described, in excruciating detail,
>in a location where i did not tread ?
Did you read the 8.3.3 release notes?
http://www.postgresql.org/docs/8.3/static/release-8-3-3.html
I do believe this was discussed in hackers or thereabouts. Not that
familiar with it myself, but that's where I'd start my search
On Mon, Jul 7, 2008 at 1:51 PM, spellberg_robert <[EMAIL PROTECTED]> wrote:
> greetings, all ---
>
> in the announcement for the 8.3.3 bundle,
> about four weeks ago,
greetings, all ---
in the announcement for the 8.3.3 bundle,
about four weeks ago, now,
it was stated that the 8.3.2 bundle had "issues",
but, their nature was not described.
it was stated that
these tarballs were only available for "a few days".
so, the cat in me being curious,
today
PG: PostgreSQL 8.1.4
OS: RHEL 4.x
I have a set of queries on a production server that have been running fine for
the past few months but as of last Friday started performing poorly. I have
isolated the problem down to a particular part that is common to all queries
involved and have provided
On Jul 7, 2008, at 12:22 PM, aravind chandu wrote:
I need to store an image in postgresql database and after
that i need to retrive the image back.Can you please help me how to
do this?
Assuming you mean an image as in a binary visual image (like a JPEG),
the data type you want is
for hot_backup and restore check this
http://www.postgresql.org/docs/8.3/static/continuous-archiving.html
for logic backup (dump) use this
http://www.postgresql.org/docs/8.3/static/app-pgdump.html
--- On Mon, 7/7/08, aravind chandu <[EMAIL PROTECTED]> wrote:
> From: aravind chandu <[EMAIL P
Hello,
I need to store
an image in postgresql database and after that i need to retrive the
image back.Can you please help me how to do this?
Thank You,
Avinash.
Dushyanth <[EMAIL PROTECTED]> writes:
>> Tom Lane sss.pgh.pa.us> writes:
>> Then the only other possibility is that autovacuum is being launched to
>> prevent XID wraparound. Are there any tables in that database with
>> particularly old relfrozenxid?
> Below are the unique age(relfrozenxid) val
Dushyanth escribió:
> Below are the unique age(relfrozenxid) values that i see from the above query
>
> # psql -U postgres -d dbname -c "select relname, age(relfrozenxid) from
> pg_class
> where relkind in ( 'r', 't') order by 2 desc;" | awk '{print $3}' | sort |
> uniq
>
> 140835139
> 1509457
On Mon, Jul 7, 2008 at 11:43 AM, salman Sheikh <[EMAIL PROTECTED]> wrote:
>
>
> Hi Fellows
>
> i have already MS Access databank (version 97) and source has been written
> in C++.Is it possible that i can replace it with postgresql as it is.Becoz i
> have 10 different tables,which are joined eachot
On 07/07/2008 18:43, salman Sheikh wrote:
i have already MS Access databank (version 97) and source has been
written in C++.Is it possible that i can replace it with postgresql as
it is.Becoz i have 10 different tables,which are joined eachother.
It depends. How are you accessing the database
Hi Fellows
i have already MS Access databank (version 97) and source has been written in
C++.Is it possible that i can replace it with postgresql as it is.Becoz i have
10 different tables,which are joined eachother.
any Suggestion?
as u ppl know ,i am new user of postgresql.
thanks in ad
Hey,
> Tom Lane sss.pgh.pa.us> writes:
> > Dushyanth gmail.com> writes:
> >> Does "show autovacuum" confirm that it's off?
>
> > Yes.
>
> > # show autovacuum;
> > autovacuum
> >
> > off
> > (1 row)
>
> Then the only other possibility is that autovacuum is being launched to
> pr
> it's sort of a formal document management system. the assigned gapless numbers
> are frozen at the end of each month. until then, an authorized user will be
> able to delete a document. but ...
Another way of dealing with this is to keep the association between the
number and the document it was
There is a procedure elsewhere that generate a file containing
insert into table1 (colname1, colname2, colname3,...) values();
insert (colname1, colname2, colname3,...) values();
insert (colname1, colname2, colname3,...) values();
update table1 set colname1=value, colname2=col2... wher
Joao Ferreira gmail <[EMAIL PROTECTED]> writes:
> So we are considereing separating these two, in order to use 2 diferent
> pg instances. One of the instances will be reniced down in order to
> prevent user access failure during vacuuming and re-indexing operations
> (currently, when we perform dat
Hello all,
we are using PostgreSQL in a situation where I think we could try and
run two separate instances:
- 1 application can grow up to 10 Giga data; needs 'frequent' vaccuming
and re-indexing (lots of insert, updates and deletes, per minute): we
use it for 'near-real-time' applications logs
Dushyanth <[EMAIL PROTECTED]> writes:
>> Does "show autovacuum" confirm that it's off?
> Yes.
> # show autovacuum;
> autovacuum
>
> off
> (1 row)
Then the only other possibility is that autovacuum is being launched to
prevent XID wraparound. Are there any tables in that database
sound like you have a postmaster.pid in your PGDATA directory. Rename file
postmaster.pid and launch the postgresql again
--- On Sat, 7/5/08, Scott Frankel <[EMAIL PROTECTED]> wrote:
> From: Scott Frankel <[EMAIL PROTECTED]>
> Subject: [GENERAL] roll back to 8.1 for PyQt driver work-around
> To:
Scott Frankel wrote:
> Is there an example postgresql.conf file for pg 8.1 I can review? Mine
> appears to be valid only for pg8.3.
Sure, it comes with the distribution as postgresql.conf.sample and is
installed by initdb.
> Adding quotes to the shared_buffers value allows pg8.3 to start
> s
On Wed, 2 Jul 2008, David Siebert wrote:
What I would like to try just for my own amusment is to build a small
test box. It will not be a server class machine. I am thinking of using
an AMD X2 and to start a SATA hard drive.
What I did when wanting to run similar experiments was get a moderat
On Mon, Jul 7, 2008 at 4:54 AM, Jack Brown <[EMAIL PROTECTED]> wrote:
Richard Broersma escreveu:
in the mean time i did some research for other rdbms and i guess, what i was
looking for was more along the lines of e.g. the row_number() function of mssql
[1]. fwiw this seems like the most effi
On Mon, Jul 07, 2008 at 05:53:58PM +0800, Ow Mun Heng wrote:
> I'm going to alter a bunch a tables columns's data type and I'm being
> forced to drop a view which depends on the the colum.
Why is that a problem? If you keep your object definitions in files
(e.g., in a directory structure that's u
On Mon, Jul 7, 2008 at 4:54 AM, Jack Brown <[EMAIL PROTECTED]> wrote:
> Thank you, i didn't know the term so when I'd searched the archives, i hadn't
> found much.
Here is the result of a discussion that came up a couple of years ago:
http://www.varlena.com/GeneralBits/130.php
I guess that ger
> On Sun, Jul 6, 2008 at 7:33 PM, Berend Tober wrote:
> > This question comes up a lot. A term used in prior
> discussions is "gapless
> > sequence".
> >
>
Thank you, i didn't know the term so when I'd searched the archives, i hadn't
found much.
> > What would be really more interesting for disc
I'm going to alter a bunch a tables columns's data type and I'm being
forced to drop a view which depends on the the colum.
eg: ALTER TABLE xs.d_trh ALTER m_dcm TYPE character varying;
ERROR: cannot alter type of a column used by a view or rule
DETAIL: rule _RETURN on view v_hpp depends on colu
Hi,
Tom Lane sss.pgh.pa.us> writes:
> dushy gmail.com> writes:
> > On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver comcast.net>
wrote:
> >> One question? Did you do pg_ctl reload after changing the config file?
>
> > I did not change any config yet - autovacuum was always disabled since
> > th
31 matches
Mail list logo
