Hi, I am using Postgres 8.1.0. I have a requirement. I will create a
function accepting few parameters. This will check into various tables and
give back an array of values. I want to use the pgpsql block. I know that we
can create using language sql. Is it possible to return an ar
On Fri, 2007-03-30 at 12:40 -0400, Tom Lane wrote:
> "Simon Riggs" <[EMAIL PROTECTED]> writes:
> > I think there is a problem here. If we stop before the end of logs we
> > should be incrementing the timeline id.
>
> There is no good reason here to think that we have stopped before the
> end of lo
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> I think there is a problem here. If we stop before the end of logs we
> should be incrementing the timeline id.
There is no good reason here to think that we have stopped before the
end of logs, and I don't think I want the code bumping the timeline ID
o
Rickard =?iso-8859-1?b?U2r2c3Ry9m0=?= <[EMAIL PROTECTED]> writes:
> I have a view that is really slow and I ca easily work around the slowness by
> bypassing the view and query the real table directly.
Let's see the exact definition of the view and EXPLAIN ANALYZE results
for doing it both ways.
On Sun, 2007-03-25 at 20:57 -0400, Tom Lane wrote:
> Warren Little <[EMAIL PROTECTED]> writes:
> > I'm testing my PITR recovery procedures and something doesn't look
> > right.
> > The following is from the logs upon starting postgres with
> > recovery.conf file in place
>
> > @ 2007-03-23 05:
On Fri, 2007-03-30 at 08:23 -0600, Warren Little wrote:
> On slightly different topic, is there some way to determine the
> timeline of the corrupted segment, ie what was the original time of
> the last restored transaction.
You need to examine the WAL files using xlogdump available from
pgfoundr
Carol Walter wrote:
> I ran the command "show autovacuum" and postgres responds with "ON."
> My colleague says that I should be able to see it running if I run ps
> -aef. He said that he doesn't trust postgres reporting on itself.
I wouldn't trust your colleague then ...
> When I run the
Hi,
On Friday 30 March 2007 16:43, Carol Walter wrote:
| I ran the command "show autovacuum" and postgres responds with "ON."
| My colleague says that I should be able to see it running if I run ps
| -aef. He said that he doesn't trust postgres reporting on itself.
| When I run the Unix ps comman
I ran the command "show autovacuum" and postgres responds with "ON."
My colleague says that I should be able to see it running if I run ps
-aef. He said that he doesn't trust postgres reporting on itself.
When I run the Unix ps command as above I don't see autovacuum. Does
anyone know if
Simon,
I have no issues with how the error was handled, just the
notification that an error was encountered.
@ 2007-03-23 05:57:33 MDTLOG: restored log file
"0001011A00FD" from archive
@ 2007-03-23 05:57:35 MDTLOG: incorrect resource manager data
checksum in record at 11A/FD492B
On Thu, 2007-03-29 at 18:18 +0300, Sabin Coanda wrote:
> The problem still persist, and I'm not able to fix it alone.
> Is anyone which is using WAL on Windows to tell me some tips to make it
> workable, or to confirm there is a problem, please ?
>From your earlier problem description you seem t
Hi!
I've probably missed somthing but here is my problem.
I have a view that is really slow and I ca easily work around the slowness by
bypassing the view and query the real table directly.
Example:
>From view, the slow one:
SELECT * from my_view WHER
On Fri, 2007-03-23 at 17:16 -0600, Warren Little wrote:
> My concern is that there were many more logfiles to be played
> following "001011A00FD"
> (ie 0001011E005C) yet it appears the recovery stop at that
> point and called it good.
> I would assume all WAL logs would be
On Mon, 2007-02-26 at 13:15 -0600, Jason Minion wrote:
> This is currently unsupported in mainstream PostgreSQL, as the WAL only
> works on the cluster basis. The only options you currently have for
> performing this is to use the last full backup and copies of WAL files
> to restore the cluster on
14 matches
Mail list logo
