Re: [HACKERS] Problem with PITR recovery

2005-04-17 Thread Ragnar Hafsta
On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote: [about backup procedure with PITR documentation I see in the docs: To make use of this backup, you will need to keep around all the WAL segment files generated at or after the starting time of the backup. To aid you

Re: [HACKERS] Problem with PITR recovery

2005-04-17 Thread Bruce Momjian
Ragnar HafstaĆ° wrote: On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote: [about backup procedure with PITR documentation I see in the docs: To make use of this backup, you will need to keep around all the WAL segment files generated at or after the starting time of the

Re: [HACKERS] argtype_inherit() is dead code

2005-04-17 Thread Joshua D. Drake
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 wish? Hello, From a people who call me perspective. I am never asked about inheritance. Most of the people don't even know it is

Re: [HACKERS] argtype_inherit() is dead code

2005-04-17 Thread Alvaro Herrera
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 locking (and

Re: [HACKERS] argtype_inherit() is dead code

2005-04-17 Thread elein
As the voice of someone who has a lot of experience with some of the original inheritance, I would prefer to have the select foo(t.*) from grandkid work for completeness. However, erroring out as ambiguous is not unreasonable since we have to cast the hell out of everything usually. I would

[HACKERS] inet increment w/ int8

2005-04-17 Thread Ilya A. Kovalenko
Greetings, I suggest function for inet increment w/ int8 (signed). FUNCTION inet_inc(int, int8) RETURNS inet Function, useful for making address pools (using also existing inet compare functions to trap boundaries). Notes: This version lets address wrap around 0-*ff boundary. Uses

Re: [HACKERS] argtype_inherit() is dead code

2005-04-17 Thread Jim C. Nasby
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 wish? FWIW, I think people might be more likely to use the OO

Re: [HACKERS] argtype_inherit() is dead code

2005-04-17 Thread Rod Taylor
On Sun, 2005-04-17 at 14:04 -0400, 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,

Re: [HACKERS] argtype_inherit() is dead code

2005-04-17 Thread Rod Taylor
On Sun, 2005-04-17 at 19:54 -0400, Robert Treat wrote: On Sunday 17 April 2005 19:30, Rod Taylor wrote: On Sun, 2005-04-17 at 14:04 -0400, 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

Re: [HACKERS] argtype_inherit() is dead code

2005-04-17 Thread Robert Treat
On Sunday 17 April 2005 19:30, Rod Taylor wrote: On Sun, 2005-04-17 at 14:04 -0400, 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

Re: [HACKERS] argtype_inherit() is dead code

2005-04-17 Thread Christopher Kings-Lynne
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 locking (and deadlocking) on foreign keys? The business about being able to drop users and

Re: [HACKERS] Problem with PITR recovery

2005-04-17 Thread Bruce Momjian
Bruce Momjian wrote: I figured that part of the goal of PITR was that you could recover from just the tar backup and archived WAL files --- using the pg_xlog contents is nice, but not something we can require. I understood the last missing WAL log would cause missing information, but not

Re: [HACKERS] inet increment w/ int8

2005-04-17 Thread Ilya A. Kovalenko
oops - FUNCTION inet_inc(int, int8) RETURNS inet + FUNCTION inet_inc(inet, int8) RETURNS inet ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Problem with PITR recovery

2005-04-17 Thread Bruce Momjian
pgman wrote: I figured that part of the goal of PITR was that you could recover from just the tar backup and archived WAL files --- using the pg_xlog contents is nice, but not something we can require. I understood the last missing WAL log would cause missing information, but not that it

Re: [HACKERS] Problem with PITR recovery

2005-04-17 Thread Jeff Davis
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.pha.pa.us/main/writings/pgsql/sgml/backup-online.html

Re: [HACKERS] Problem with PITR recovery

2005-04-17 Thread Bruce Momjian
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

[HACKERS] Urgent

2005-04-17 Thread ElayaRaja S
Hi, 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 /usr/local/pgsql/data/, I need to