Hi,
From: Magnus Hagander <[EMAIL PROTECTED]>
Subject: Re: [HACKERS] pg_restore fails with a custom backup file
Date: Thu, 15 Feb 2007 17:38:59 +0100
> On Fri, Dec 29, 2006 at 05:30:48PM +0100, Magnus Hagander wrote:
> > On Tue, Dec 19, 2006 at 04:58:22PM +0100, Zeugswetter Andreas ADI SD wrote:
Joshua,
I revised. Now Sigres can be activated by setting "sigres = on" in
postgresql.conf.
You can download the version (0.1.2) from
http://sourceforge.jp/projects/sigres .
And, I attach the diff between PostgreSQL-8.2.1 and Sigres-0.1.2 to this
mail.
Thanks for your comments.
-- Hideyuki
Jo
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> yikes!
> If you guys go through with forcing functions to attach to objects
> when they are created, it will break almost every project I've ever
> worked on :(. The schema/function combo fits into all kinds of de
> facto partitioning strategies and
On Thu, Feb 08, 2007 at 01:54:13PM -0500, Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > I'm honestly looking for some practical use of this. We have debated
> > other NOTICE messages over the years, but they at least tell you
> > something you can use after the command.
>
>
Tom Lane wrote:
Come to think of it, we really do need some refactoring in
parse_coerce.c.
[snip]
I'm not very sure what a good refactoring would look like,
but I am sure that I don't want all their call sites having to
individually account for ANYfoo types. Any thoughts?
I was
Come to think of it, we really do need some refactoring in
parse_coerce.c. I just realized what CVS HEAD's RI code
does with array types:
regression=# create table aa (f1 int[] primary key);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "aa_pkey" for
table "aa"
CREATE TABLE
regr
Tom Dunstan <[EMAIL PROTECTED]> writes:
> I do have b-tree (and hash) support for enums, so it sounds like I'll
> have to hit the same spot. I've got what I thought was a reasonably
> comprehensive test of all the enum features which passes make check, so
> if there's a likely failure in that co
Tom Lane wrote:
Actually ... now that I re-read that remark, I think you may have done
the wrong things with ANYENUM. I think that ANYENUM may in fact be
closer to ANYARRAY than it is to ANYELEMENT, because ANYELEMENT pretty
nearly means "anything at all" whereas ANYARRAY identifies a subset of
On 2/13/07, Tom Lane <[EMAIL PROTECTED]> wrote:
I would suggest that the search path be added as an explicit parameter
to CREATE FUNCTION, with a default of the current setting. The main
reason for this is that it's going to be a real PITA for pg_dump if we
don't allow an explicit specification.
[EMAIL PROTECTED] wrote:
> Digging into this, I find that the fcinfo struct being passed
> to me as an address of 0x02 - that looks a little non-sensical to
> me.
Perhaps you forgot PG_FUNCTION_INFO_V1().
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
-
Firstly, this is the wrong list; this one is to discuss the development
OF postgres, NOT with. You need novice or general.
Secondly: look for pgpass in the documentation
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
oliver rombaoa wrote:
> i want to add database backup to my program i developed in visual
> basic 6, of course i can save the syntax for pg_dump in a batch file
> and call it inside vb6 via "shell", but my problem is that the batch
> file executes but stops to prompt for a password. how can i suppl
oliver rombaoa wrote:
i want to add database backup to my program i developed in visual basic 6, of course i
can save the syntax for pg_dump in a batch file and call it inside vb6 via
"shell", but my problem is that the batch file executes but stops to prompt for
a password. how can i supply a
On Feb 14, 11:26 am, [EMAIL PROTECTED] ("Florian G. Pflug") wrote:
> Neil Conway wrote:
> > On Wed, 2007-02-14 at 13:19 -0300, Alvaro Herrera wrote:
> >> Probably stack allocation doesn't matter much, as I think that would be
> >> unwinded by the longjmp call. I don't know a lot about C++, but if
Tom Dunstan wrote:
Tom Lane wrote:
As for actually adding it, grep for all references to ANYELEMENT and add
code accordingly; shouldn't be that hard. Note you'd need to add an
anyarray2 at the same time for things to keep working sanely.
The enum patch [1] does exactly this with an ANYENUM ps
Hi,
I'm trying to implement the add_one sample in the PG docs using VC++
(for purposes of debugging). After some pain (had to add the
dllexport declspec below), I am able to get the CREATE FUNCTION
command to recognize the library and function. However, the function
blows up. I am able to attac
i want to add database backup to my program i developed in visual basic 6, of
course i can save the syntax for pg_dump in a batch file and call it inside vb6
via "shell", but my problem is that the batch file executes but stops to prompt
for a password. how can i supply a password to it automati
On Thu, Feb 15, 2007 at 10:42:49AM -0500, Tom Lane wrote:
> > #define VARDATA_4B(PTR) ((PTR)->va_4byte.va_data)
> > #define VARDATA_2B(PTR) ((PTR)->va_2byte.va_data)
> > #define VARDATA_1B(PTR) ((PTR)->va_1byte.va_data)
> I thought we had abandoned the 2-byte-hea
"Tom Lane" <[EMAIL PROTECTED]> writes:
>> #define VARDATA_4B(PTR) ((PTR)->va_4byte.va_data)
>> #define VARDATA_2B(PTR) ((PTR)->va_2byte.va_data)
>> #define VARDATA_1B(PTR) ((PTR)->va_1byte.va_data)
>
> I thought we had abandoned the 2-byte-header variant?
Hi Magnus-san.
Great!!
Although not tested yet, I seem to equip it with the tolerance to 32GB.?
P.S)
In Japan, there is a user who is employing 300GB of database on Windows2003.
I have received some problems other than this. however, this user does not permit
public presentation of the informat
On Fri, Dec 29, 2006 at 05:30:48PM +0100, Magnus Hagander wrote:
> On Tue, Dec 19, 2006 at 04:58:22PM +0100, Zeugswetter Andreas ADI SD wrote:
> >
> > > > > > MinGW has fseeko64 and ftello64 with off64_t.
> > > > > >
> > > > >
> > > > > Maybe we need separate macros for MSVC and MinGW. Given t
Mario Weilguni <[EMAIL PROTECTED]> writes:
> ERROR: failed to build any 8-way joins
Could you provide a self-contained test case for this? You probably
don't need any data, just the table schemas.
I fixed a problem with a similar symptom a couple days ago, but that was
in logic that was new in
Gregory Stark <[EMAIL PROTECTED]> writes:
> There's also VARATT_CDATA which I suppose I should rename to VARCDATA. I
> may not even need it once I hit tuptoaster.c since that file works directly
> with the structure members anyways.
> I supposed we also rename VARATT_IS_{COMPRESSED,EXTERNAL,EXTEND
Thanks for the info. Is there a fix for 8.1 branch, the production system is
still 8.1.
Regards
Mario Weilguni
Am Donnerstag, 15. Februar 2007 16:25 schrieb Alvaro Herrera:
> Mario Weilguni wrote:
> > Interesting: remove any of the above where conditions solves the problem
> > go away,
Mario Weilguni wrote:
> Interesting: remove any of the above where conditions solves the problem go
> away, e.g. removing "and bei.id=10157309".
>
> Testet with 8.2.1 and 8.1.4, same effect on both systems. Because of the
> large number of tables involved it's difficult to find a self containe
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Gregory Stark <[EMAIL PROTECTED]> writes:
>> 1) Replace the VARATT_SIZEP macro with SET_VARLENA_LEN.
>
> If we're going to do this then it's time to play the name game;
Least...fun...game...evar...
> A first-cut proposal:
>
> VARHDRSZ
Interesting problem, seems to be planer related:
select 1
from beitraege bei,
b_zuordnungen bz,
(select bei_id
from b_zuordnungen bz,
ben_zuordnungen z,
strukturelemente se
where se.id = z.str_i
Tom,
In my experience, in last April, a BBWC solution did not accelerate
PostgreSQL well.
The device which I tried was i-ram by gigabyte
(http://techreport.com/reviews/2006q1/gigabyte-iram/index.x?pg=1 ).
The i-ram showed only a little performance improvement compared to
PostgreSQL with fsync to d
Bruce,
Let me answer to your question.
Question 1: How much faster is it ?
To answer to your question, I measured execution times of INSERT
operations on concurrent accesses on dual-core x 2 CPU (each 2.80GHz),
In the experiment, each client issues 5000 INSERT operations concurrently.
The fo
On 2/15/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
Do we actually ever want to remove dead tuples from the middle of the
chain? If a tuple in the middle of the chain is dead, surely every tuple
before it in the chain is dead as well, and we want to remove them as
well. I'm thinking, remo
Zeugswetter Andreas ADI SD wrote:
I am still wondering about the "easily" here. Basically this
needs some kind of wal entry to be crash safe.
Else some later tx might reuse the slot:
- some update on page produces page image in wal
- slot removed
- slot reused and comit
Bruce Momjian wrote:
> Just to summarize:
>
> o Every tuple gets a heap ctid
> o Only the root tuple gets an index entry
> o We can easily remove dead tuples that aren't the root because
> by definition, nothing points to them, including backends and
> ind
32 matches
Mail list logo
