pgAdmin guru hints

On Mon, Oct 03, 2005 at 02:16:37AM +0200, Andreas Pflug wrote:

In-time for PostgreSQL 8.1 gold, The pgAdmin Developer Team will
release pgAdmin III V1.4, which has a new Guru hint feature that
tries to give users helpful hints on typical beginner's pitfalls.

The current set of hints is at
http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/trunk/pgadmin3/docs/en_US/hints/

You're invited to make your comments on the hints: are these
correct, is there something missing or misleading?

Dunno if this is handled yet, but in the previous version, changes
disallowed by a RULE showed up as though they had happened. Is this
fixed in 1.4-to-be?

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

David Fetter wrote:

Dunno if this is handled yet, but in the previous version, changes
disallowed by a RULE showed up as though they had happened. Is this
fixed in 1.4-to-be?

Hm, could you elaborate on this a little? I don't know what you mean.

Regards,
Andreas

I noticed a typo in hints/conn-hba.html

The second internal ip adres missed a '.'

You're invited to make your comments on the hints: are these correct, is
there something missing or misleading?

Cheers,
--
^(B(astia{2}n)?)(\s)?(W(ak{2}ie)?)$

Thanks - fix committed to svn.

Regards, Dave

________________________________

From: pgadmin-hackers-owner@postgresql.org
[mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of Bastiaan
Wakkie
Sent: 03 October 2005 17:04
To: Andreas Pflug
Cc: PostgreSQL-development; pgadmin-hackers;
pgsql-admin@postgresql.org
Subject: Re: [pgadmin-hackers] pgAdmin guru hints

I noticed a typo in hints/conn-hba.html

The second internal ip adres missed a '.'

You're invited to make your comments on the hints: are
these correct, is
there something missing or misleading?

Cheers,

--
^(B(astia{2}n)?)(\s)?(W(ak{2}ie)?)$

Is it at all possible to manually replay archived WAL files after restoring
from a pg_dump dumpfile?

--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

Please don't reply to existing threads to start new ones. That is probably why
your message didn't get any replies.

On Mon, Oct 03, 2005 at 11:25:25 -0700,
Jeff Frost <jeff@frostconsultingllc.com> wrote:

Is it at all possible to manually replay archived WAL files after restoring
from a pg_dump dumpfile?

You probably want to look at:
http://candle.pha.pa.us/main/writings/pgsql/sgml/backup-online.html

That is from the soon to be released 8.1 documentation. PITR is available
in 8.0, but I believe there were enhancements made to the tools for using
it in 8.1.

On Mon, 24 Oct 2005, Bruno Wolff III wrote:

Please don't reply to existing threads to start new ones. That is probably why
your message didn't get any replies.

Point taken, but fortunately, Simon got back to me and essentially indicated
that I was out of luck.

On Mon, Oct 03, 2005 at 11:25:25 -0700,
Jeff Frost <jeff@frostconsultingllc.com> wrote:

Is it at all possible to manually replay archived WAL files after restoring
from a pg_dump dumpfile?

You probably want to look at:
http://candle.pha.pa.us/main/writings/pgsql/sgml/backup-online.html

That is from the soon to be released 8.1 documentation. PITR is available
in 8.0, but I believe there were enhancements made to the tools for using
it in 8.1.

Unfortunately, diffing the 8.0.4 docs against the 8.1 docs shows almost no
useful differences. I was mostly hoping someone with knowledge of the WAL
internal format could tell me how to extract the transactions from some and
manually replay them in the db via psql with lots of copy/paste action.

--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

Jeff Frost wrote:

Unfortunately, diffing the 8.0.4 docs against the 8.1 docs shows almost no
useful differences. I was mostly hoping someone with knowledge of the WAL
internal format could tell me how to extract the transactions from some and
manually replay them in the db via psql with lots of copy/paste action.

Oh, so the data in the log must be very valuable to you. I guess you
could extract the data if you processed the WAL logs. A tool to do this
doesn't exist as far as I know, but you could write your own. There was
a crude hack by Tom Lane, which you can find on the archives:

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Mohan, Ross" <RMohan@arbinet.com>
Cc: pgsql-admin@postgresql.org
Date: Wed, 13 Apr 2005 10:26:09 -0400
Subject: Re: [ADMIN] question about wal and point in time recovery

It would be nice to expand on this tool.

--
Alvaro Herrera http://www.PlanetPostgreSQL.org
"Coge la flor que hoy nace alegre, ufana. �Qui�n sabe si nacera otra ma�ana?"