Hi,
Tom Lane tgl at sss.pgh.pa.us writes:
dushy dushyanth at gmail.com writes:
On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver aklaver at 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
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
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 discussion
on
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 german
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
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
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
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
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:
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 with
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
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 database
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...
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
Hey,
Tom Lane tgl at sss.pgh.pa.us writes:
Dushyanth dushyanth at 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
prevent
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
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
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 eachother.
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
150945753
Dushyanth [EMAIL PROTECTED] writes:
Tom Lane tgl at 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) values
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.
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
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
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
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, i
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, now,
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
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.
In
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?
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 few applications to
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
31 matches
Mail list logo