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 all the WAL file before the *.backup
file
On Mon, 18 Apr 2005, ElayaRaja S wrote:
My postgresql was running successfully in my Redhat LInux 9. After
1 day when i try to login to the folder /usr/local/pgsql/data to
update the ip address i am getting
as
[EMAIL PROTECTED] data]# ls
Segmentation fault
I am unable to see the files under
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
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
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
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
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 installed
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
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 all the WAL file
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
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
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 another
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 file
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 demand ?
Bruce Momjian pgman@candle.pha.pa.us 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
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
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 file
by demand ?
Greg Stark wrote:
Bruce Momjian pgman@candle.pha.pa.us 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
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
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 you
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 function
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
Bruce Momjian pgman@candle.pha.pa.us 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
[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?.
Bruce Momjian pgman@candle.pha.pa.us 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
Bruce Momjian pgman@candle.pha.pa.us 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
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us 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
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us 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
[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 diagrams and
Bruce Momjian pgman@candle.pha.pa.us 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
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
relfilenode,
Bruce Momjian pgman@candle.pha.pa.us 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,
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us 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
Bruce Momjian pgman@candle.pha.pa.us 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
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us 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
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
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 for
-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
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
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]# rpm
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
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 is that
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. But I
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 thing I don't
On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us 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
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
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
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()
which
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
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 just too
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
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 a
Simon Riggs wrote:
On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us 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
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
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
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 in
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-in
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 pgman@candle.pha.pa.us 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
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
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 test.a
71 matches
Mail list logo