Very Computer

I started... but had to install and configure AOLServer, which took more
time than I had allotted to thie experiment.  I never was able to get a
diff to run.  I think a good pratical and working example is needed for
that utility.  I'd like to see how it works.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Quote:> Justin Clift writes:
> > Just found out that the "pgdiff" utility (the one for comparing two
> > different PostgreSQL database's) was released and uploaded to
> > SourceForge in November:
> A diff utility with a mandatory GUI frontend through a webserver is
> positively the most bizarre thing I have ever heard of.

No, AOLserver is just that good at database connectivity.... :-)  And it makes
a great development environment for various db utilities.  Although the
pgdiff people might should mention the need on their summary page....

I've heard of more bizarre things, though.....
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

I'm busy trying to set up AOLserver to access PostgreSQL. Can you offer any
advice on what driver to use (docs aren't entirely clear on the virtues of
the internal PostgreSQL driver vs. the ARSdigita driver and it looks like the
ARSdigita is being merged into the AOLserver code but that's in a beta state
- a bit of a headache for an AOLserver newbie).

Cheers,
Steve

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Quote:> > A diff utility with a mandatory GUI frontend through a webserver is
> > positively the most bizarre thing I have ever heard of.

This may be true of a file diff utility but for a dbms diff utility there is
sometimes ambiguity and pgdiff attempts to be more than just a diff utility.

pgdiff allows you to select your database source and target from existing
dbs,
schema files or merely text box input for schemas. It then displays summary
of
the schemas by table, index, seq, etc. You can then examine / modify /
insert
the diff script for each subdb entity type. You can test your diff scripts
and
likewise examine in detail the results. If the results were not what
expected
you can go back and modify the scripts or delete portions. Basically pgdiff
attempts to be a schema comparison utility in adddition to diff script
creator.
This is one of the main reasons for the GUI aspect of it. By having this
comparsion functionality you get a much better idea of what your scripts
will
do before really applying them. pgdiff does all aterations on a test db
which is
a clone of the orignal schemas so no harm is done using/testing with pgdiff.

Quote:>No, AOLserver is just that good at database connectivity.... :-)  And it
>makes
>a great development environment for various db utilities.

Hopefully the above are some reasons why to have a gui and the quote above
is
the summary for why to make it webserver frontended. It saved a lot of work
by using the functionality available within AOLserver. Also it allows a demo
of the utility to be offered online so people can get a feel for what/how it
does it work at www.23pools.com:8000

At some point in the future  I plan to take the code and create
a striped down version that is command line only but I don't have the time
currently but the source is at sf so have at it.

Best Regards,
Carl Garland

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Quote:> I'm busy trying to set up AOLserver to access PostgreSQL. Can you offer any
> advice on what driver to use (docs aren't entirely clear on the virtues of
> the internal PostgreSQL driver vs. the ARSdigita driver and it looks like
> the ARSdigita is being merged into the AOLserver code but that's in a beta
> state - a bit of a headache for an AOLserver newbie).

The officially sanctioned latest driver version in 3.5, found on the
SourceForge AOLserver file download page.

OpenACS is built on top of AOLserver, it's true; they are still separate
projects, even though the driver has hooks in it for OpenACS use.  The
OpenACS sample tcl config shows how to load the nspostgres driver (even
though it may call it 'postgres' instead).
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org