On Mon, 18 Apr 2005, Bruce Momjian wrote:
Jeff Davis wrote:
I could still use a little clarification. It seems sort of like there is
an extra step, like:
(1) start archiving
(2) pg_start_backup()
(3) copy PGDATA directory with tar
(4) pg_stop_backup()
(5) ??
And the text you have at
http://candle.p
Hello All
Can any one tell me how can I get triggerOid from triggerName
in c code. I first tried to use SearchSysCache Function but it does
not search o the basis of triggername.
---(end of broadcast)---
TIP 3: if posting/reading through Use
Hello,
if i need to add a column in pg_proc ,is any body can
give me overview to do this.
Thanks,
Asif Ali
__
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250
---
I'm using systable_beginscan() with TriggerConstrNameIndex
(Band systable_getnext().
(B
(BBTW, which value are you using as the cacheId
(Bwhen you call SearchSysCache() for pg_trigger?
(B
(BI couldn't find a suitable value in syscache.h.
(B
(Brafaqat ali wrote:
(B> Hello All
(B>
Hello All
Can any one tell me how can I get triggerOid from triggerName
in c code. I first tried to use SearchSysCache Function but it does
not search o the basis of triggername.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comma
Hello All
Can any one tell me how can I get triggerOid from triggerName
in c code. I first tried to use SearchSysCache Function but it does
not search o the basis of triggername.
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
--
Warm Regards,
S.ElayaRaja
Mobile: (+91) 98450 59540
E-Mail: [EMAIL PROTECTED]
[EMAIL PROTECTED]
---
Le Monday 18 April 2005 13:47, ElayaRaja S a écrit :
> Hi,
> I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
> i have to install postgresql 7.4.5. Plz let me know how to uninstall
> completely - postfesql 7.3.2
rpm -e postgresql ?
I am not sure this kind of question should
Greetings,
I don't really know if this is the correct place to ask this question, if not
please
direct me to the correct mailing list.
I'm trying to develop a new operator for PostGreSQL (actually for TelegraphCQ,
which
is an extension of PSQL). Part of the operator's procedure is the @-operato
ElayaRaja S said:
> Hi,
> I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and i
> have to install postgresql 7.4.5. Plz let me know how to uninstall
> completely - postfesql 7.3.2
>
> I am getting as [EMAIL PROTECTED] root]# rpm -e postgresql
> error: package postgresql is not instal
> I'd say it's very not cool :) It's not we all
> expected from PITR.
> I recall now Simon mentioned about that and have it
> in his TODO.
> Other thing I don't understand what's the problem to
> generate WAL file
> by demand ? Probably, TODO should says about this.
This would definetly be a good
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
I am getting as [EMAIL PROTECTED] root]# rpm -e postgresql
error: package postgresql is not installed
if i try to check the v
Jeff Davis wrote:
> On Mon, 2005-04-18 at 00:20 -0400, Bruce Momjian wrote:
> > Jeff Davis wrote:
> > >
> > > Can you sort of run through the failure case again, and how to prevent
> > > it?
> >
> > The failure case in the original docs is that you do your
> > pg_stop_backup(), and then delete al
HI,
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
if i install the postgreSQL 7.4.5 and i used the command,
bash-2.05b$ psql
psql: relocation error: psql: undefined symbol:
On Mon, 18 Apr 2005, Rob Butler wrote:
I'd say it's very not cool :) It's not we all
expected from PITR.
I recall now Simon mentioned about that and have it
in his TODO.
Other thing I don't understand what's the problem to
generate WAL file
by demand ? Probably, TODO should says about this.
This w
On 4/18/05, ElayaRaja S <[EMAIL PROTECTED]> wrote:
> Hi,
> I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
> i have to install postgresql 7.4.5. Plz let me know how to uninstall
> completely - postfesql 7.3.2
Hello,
You really should consider asking your question on some anot
Oleg Bartunov wrote:
> > Is there something in the current wording that needs clarification?
>
> I'd say it's very not cool :) It's not we all expected from PITR.
> I recall now Simon mentioned about that and have it in his TODO.
> Other thing I don't understand what's the problem to generate WAL
Rob Butler <[EMAIL PROTECTED]> wrote on 18.04.2005, 15:05:20:
>
> > I'd say it's very not cool :) It's not we all
> > expected from PITR.
> > I recall now Simon mentioned about that and have it
> > in his TODO.
> > Other thing I don't understand what's the problem to
> > generate WAL file
> > by
Bruce Momjian writes:
> I see your point. New text is:
>
> 4 Again connect to the database as a superuser, and issue the command
>
> SELECT pg_stop_backup();
>
> This should return successfully.
>
> 5 Once the WAL segment files used du
OK, I updated the two current TODO items:
* Allow point-in-time recovery to archive partially filled write-ahead
logs
Currently only full WAL files are archived. This means that the most
recent transactions aren't available for recovery in ca
Oleg Bartunov wrote:
> On Mon, 18 Apr 2005, Rob Butler wrote:
>
> >
> >> I'd say it's very not cool :) It's not we all
> >> expected from PITR.
> >> I recall now Simon mentioned about that and have it
> >> in his TODO.
> >> Other thing I don't understand what's the problem to
> >> generate WAL fil
Greg Stark wrote:
> Bruce Momjian writes:
>
> > I see your point. New text is:
> >
> > 4 Again connect to the database as a superuser, and issue the command
> >
> > SELECT pg_stop_backup();
> >
> > This should return successfully.
> >
> > 5 Once the W
FYI, I did a presentation on the porting of PostgreSQL to Win32 on
Saturday:
http://candle.pha.pa.us/main/writings/pgsql/win32_port.pdf
It has few diagrams because I did the diagrams on a white board.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.ph
Rafaqat Ali <[EMAIL PROTECTED]> writes:
>Can any one tell me how can I get triggerOid from triggerName
> in c code. I first tried to use SearchSysCache Function but it does
> not search o the basis of triggername.
Posting the same question three times on two different lists doesn't
endear
On Mon, Apr 18, 2005 at 02:39:52PM +0200, [EMAIL PROTECTED] wrote:
>
> I'm trying to develop a new operator for PostGreSQL (actually for
> TelegraphCQ, which
> is an extension of PSQL). Part of the operator's procedure is the @-operator.
> So now
> my question is: How do I call the on_pb functio
Ali Baba <[EMAIL PROTECTED]> writes:
> if i need to add a column in pg_proc ,is any body can
> give me overview to do this.
You're in luck:
http://archives.postgresql.org/pgsql-committers/2005-03/msg00433.php
regards, tom lane
---(end of broadcast)
Bruce Momjian writes:
> You mean don't force the archive copy but just have pg_stop_backup()
> hang until the files fill? Yea, we could do that, but there is no way
> to know how long the hang might take.
Actually I meant both.
--
greg
---(end of broadcast)--
[EMAIL PROTECTED] writes:
> I'm trying to develop a new operator for PostGreSQL (actually for
> TelegraphCQ, which
> is an extension of PSQL). Part of the operator's procedure is the @-operator.
> So now
> my question is: How do I call the on_pb function from inside my own function?.
DirectFunct
Bruce Momjian writes:
> Ragnar Hafstað wrote:
>> On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote:
>>> I am not clear on what the "backup dump file" is? I assume it means
>>> 0001123455CD. It is called "WAL segment file" above. I
>>> will rename that phrase to match the above
Bruce Momjian writes:
> OK, I updated the two current TODO items:
> * Automatically force archiving of partially-filled WAL files when
> pg_stop_backup() is called or the server is stopped
> Is this OK?
Archive on stop is right out. The common reason for a stop is that the
system
Tom Lane wrote:
> Bruce Momjian writes:
> > OK, I updated the two current TODO items:
> > * Automatically force archiving of partially-filled WAL files when
> > pg_stop_backup() is called or the server is stopped
>
> > Is this OK?
>
> Archive on stop is right out. The common reason fo
Tom Lane wrote:
> Bruce Momjian writes:
> > Ragnar Hafstað wrote:
> >> On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote:
> >>> I am not clear on what the "backup dump file" is? I assume it means
> >>> 0001123455CD. It is called "WAL segment file" above. I
> >>> will rename tha
[EMAIL PROTECTED] wrote:
> Hi
> in the function ExecChooseHashTableSize()
> (~/src/backend/executor/nodeHash.c)
> are determined the bytes of the hash table. The correspondent code is:
>
> /*
> * Target in-memory hashtablesize in SortMem kilobytes
> */
> hash_table_bytes = SortMem *1024L
>
>
Bruce,
> FYI, I did a presentation on the porting of PostgreSQL to Win32 on
> Saturday:
Good thing, too, you're doing this preso for OSCON.
> http://candle.pha.pa.us/main/writings/pgsql/win32_port.pdf
>
> It has few diagrams because I did the diagrams on a white board.
Well, add some di
Bruce Momjian writes:
> I guess I didn't see the connection between the file system backup and
> the WAL files, when in fact you need the WAL files that go with the file
> system badckup to do the recovery. Do you have new suggested text?
I think it probably needs to mention *both* the tar dump
Tom Lane wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> >> So some changing-oid operations like vacuum full, reindex, etc will not
> >> affect these system catalogs?
>
> > Is it possible to cluster system tables?
>
> No, and yes. CLUSTER, REINDEX, and similar things change the
>
Bruce Momjian writes:
> Tom Lane wrote:
>> Archive on stop is right out. The common reason for a stop is that the
>> system is being shut down, and we don't have time to archive a WAL file
>> before init will kill -9 us.
> Ah, good point. Can we do it for 'smart' shutdown mode, which is the
> d
Tom Lane wrote:
> Bruce Momjian writes:
> > I guess I didn't see the connection between the file system backup and
> > the WAL files, when in fact you need the WAL files that go with the file
> > system badckup to do the recovery. Do you have new suggested text?
>
> I think it probably needs to
Bruce Momjian writes:
> Tom Lane wrote:
>> If you are looking for things that will fundamentally break the system,
>> try renaming one of the indexes of a core system catalog ;-). We could
>> avoid that dependency if we went by OIDs instead.
> Right now you can use a temporary table in place of
Tom Lane wrote:
> Bruce Momjian writes:
> > Tom Lane wrote:
> >> Archive on stop is right out. The common reason for a stop is that the
> >> system is being shut down, and we don't have time to archive a WAL file
> >> before init will kill -9 us.
>
> > Ah, good point. Can we do it for 'smart' s
Hi,
I am using Redhat linux 9. i had configure in pg_hba.conf as
hostpostgres postgres 10.10.0.76 255.255.255.0 password
If i try to connect with postgresql admin i am getting excpetion as
An erro has occured:
Error connecting to the server: could not connect to server:
Connection re
Added to TODO:
* Compress WAL entries [wal]
I have also added this email to TODO.detail.
---
Simon Riggs wrote:
> On Sun, 2005-04-10 at 21:12 -0400, Bruce Momjian wrote:
> > Jim C. Nasby wrote:
> > > Maybe better f
> -Original Message-
> From: ElayaRaja S [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 18, 2005 1:38 PM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] pg_hba.conf
>
>
> Hi,
> I am using Redhat linux 9. i had configure in pg_hba.conf as
> hostpostgres postgres 10.10.0.76
Hi!
For bitmaps, I need to search each value being inserted (for each column of
the index) in the list of already existing values (stored in index's header
area). To do that I need:
1) create Datum from PageItem's value (I store each value in it's own
PageItem);
2) compare newly inserted Datum
Greetings,
I don't really know if this is the correct place to ask this question, if not please direct me to the correct mailing list.
I'm trying to develop a new operator for PostGreSQL (actually for
TelegraphCQ, which is an extension of PSQL). Part of the operator's
procedure is the @-operator.
Clinging to sanity, [EMAIL PROTECTED] (ElayaRaja S) mumbled into her beard:
> Hi,
> I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
> i have to install postgresql 7.4.5. Plz let me know how to uninstall
> completely - postfesql 7.3.2
>
> I am getting as [EMAIL PROTECTED] root]
Can you tell me more about the good ODBC driver being worked on?
I was thinking of working on this myself, but if someone is already
solving the problem, that's great!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake
Sent: Sunday, April 17,
The world rejoiced as [EMAIL PROTECTED] ("Jim C. Nasby") wrote:
> On Sun, Apr 17, 2005 at 06:56:01AM -0700, Joshua D. Drake wrote:
>> >Is it really an important area to improve, or are there other
>> >priorities? I know some people wished we had better support for
>> >inheritance, but how strong
"Victor Y. Yegorov" <[EMAIL PROTECTED]> writes:
> So, I'd like to ask -- what is the "reverse" function for heap_fill_tuple(),
> is it OK to use index_getattr()?
That's probably what you *have* to use, since the normal deconstructors
assume they are working with heap tuples, which are different.
On Mon, 2005-04-18 at 16:44 +0200, [EMAIL PROTECTED] wrote:
> Rob Butler <[EMAIL PROTECTED]> wrote on 18.04.2005, 15:05:20:
> >
> > > I'd say it's very not cool :) It's not we all
> > > expected from PITR.
> > > I recall now Simon mentioned about that and have it
> > > in his TODO.
> > > Other thi
On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian writes:
> > > I guess I didn't see the connection between the file system backup and
> > > the WAL files, when in fact you need the WAL files that go with the file
> > > system badckup to do the recovery.
Alvaro Herrera wrote:
> On Sun, Apr 17, 2005 at 06:56:01AM -0700, Joshua D. Drake wrote:
>
> > From a "people who call me" perspective. I am never asked about
> > inheritance. Most of the people don't even know it is there.
> > The requests I get are:
>
> Just wondering, does anybody asks you abo
Alvaro Herrera wrote:
On Sun, Apr 17, 2005 at 06:56:01AM -0700, Joshua D. Drake wrote:
From a "people who call me" perspective. I am never asked about
inheritance. Most of the people don't even know it is there.
The requests I get are:
Just wondering, does anybody asks you about the excessive loc
Simon Riggs <[EMAIL PROTECTED]> writes:
> The wal file could be truncated after the log switch record, though I'd
> want to make sure that didn't cause other problems.
Which it would: that would break WAL file recycling.
> That would be initiated through a single function pg_walfile_switch()
> wh
I hope I am on good list, else point me where I should ask.
I create a C function like this:
CREATE
-- IFUPDATE or REPLACE
FUNCTION rpmquery(rpmheader, INT) RETURNS SETOF TEXT AS
'MODULE_PATHNAME', 'header_query' LANGUAGE C IMMUTABLE STRICT;
(do not take care, code come from the .sql.in)
On Mon, 2005-04-18 at 19:21 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > The wal file could be truncated after the log switch record, though I'd
> > want to make sure that didn't cause other problems.
>
> Which it would: that would break WAL file recycling.
Yeh, there's ju
Would you modify this so it can go in /contrib or pgfoundry? Is there
general interest for this?
---
Ilya A. Kovalenko wrote:
>Greetings,
>
> I suggest function for "inet" increment w/ int8 (signed).
>
> FUNCTION in
Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > The wal file could be truncated after the log switch record, though I'd
> > want to make sure that didn't cause other problems.
>
> Which it would: that would break WAL file recycling.
Good point. I don't see non-full WAL archiving as
Simon Riggs wrote:
> On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:
> > Tom Lane wrote:
> > > Bruce Momjian writes:
> > > > I guess I didn't see the connection between the file system backup and
> > > > the WAL files, when in fact you need the WAL files that go with the file
> > > > syste
Olivier Thauvin <[EMAIL PROTECTED]> writes:
> Datum
> header_querytxt(PG_FUNCTION_ARGS)
> {
> elog(NOTICE, "querytxt");
> Datum tag;
> /* converting TEXT value to integer one */
> tag = DirectFunctionCall1(rpmtagvalue, PG_GETARG_TEXT_P(1));
> elog(NOTICE, "querytxt %d", tag);
sizeof(Datum) == sizeof(long) - is that compatible with %d formatting (I'm
guessing something like vsprintf takes place in elog)? Wouldn't this need %ld
or %lu?
Sorry if this misses the point, I wasn't clear from original post if the
segfault was on elog or after it.
Regards, Philip.
On Tue
Is that broken?
http://momjian.postgresql.org/main/writings/pgsql/sgml/build.html
Chris
Bruce Momjian wrote:
Patch applied. Thanks. Sorry for the delay in applying.
---
David Fetter wrote:
On Tue, Mar 08, 2005 at 12:27:21PM +
Patch applied. Thanks. Sorry for the delay in applying.
---
David Fetter wrote:
> On Tue, Mar 08, 2005 at 12:27:21PM +0800, Christopher Kings-Lynne wrote:
> > >Luckily, PG 8 is available for this. Do you have a short exa
As others pointed out, DirectFunctionCall2 is your friend. There is a
mailing list for TelegraphCQ. It's a Yahoo group - visit
http://groups.yahoo.com/group/telegraphcq
About accessing data from a table in another database ... we need to
know more about what exactly you're doing. Please post on
Thanks, fixed.
---
Christopher Kings-Lynne wrote:
> Is that broken?
>
> http://momjian.postgresql.org/main/writings/pgsql/sgml/build.html
>
> Chris
>
> Bruce Momjian wrote:
> > Patch applied. Thanks. Sorry for the delay
Use the DirecFunctionCall1, DirecFunctionCall2, etc. functions.
... John
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
> Sent: Monday, April 18, 2005 10:40 PM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] Call to build
On Mon, 18 Apr 2005, Simon Riggs wrote:
On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian writes:
I guess I didn't see the connection between the file system backup and
the WAL files, when in fact you need the WAL files that go with the file
system badckup to do
On Tue, 19 Apr 2005, Simon Riggs wrote:
I'd suggest this as a backpatch for 8.0.x, when completed.
Not a chance --- it's a new feature, not a bug fix, and has substantial
risk of breaking things.
No problem for me personally; I only request it, according to users
wishes.
Users wish deterministic pr
Should that sequence really stick around as an integer, numeric and text
field???
test=# create table test (a serial);
NOTICE: CREATE TABLE will create implicit sequence "test_a_seq" for
serial column "test.a"
NOTICE: CREATE TABLE will create implicit sequence "test_a_seq" for
serial column "
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Should that sequence really stick around as an integer, numeric and text
> field???
What are you unhappy about exactly? We expended a fair amount of sweat
to make it behave just like that ...
regards, tom lane
--
Should that sequence really stick around as an integer, numeric and text
field???
What are you unhappy about exactly? We expended a fair amount of sweat
to make it behave just like that ...
It's confused the odd IRC user (pgsql newbie). Seems like it breaks the
'serial type' illusion...
I pres
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> I presume they have to drop the default, then drop the sequence to get
> rid of it.
Hmm. Right at the moment I don't think you *can* get rid of it, short
of dropping the column altogether.
regression=# create table z(f1 serial);
NOTICE: CRE
72 matches
Mail list logo
