Обсуждение: EMS PostgreSQL Manager vs. TheKompany DataArchitect
Hello, I've searched for and tried nearly every database administration/design tool available and it seems my choice has narrowed down to these two. Now a second opinion would be nice to have. Has anyone used one, better both of these? What do you think about them? TIA, Sincerely, Wolfgang Keller -- P.S.: My From-address is correct
Hello! > have. Has anyone used one, better both of these? What do you think > about them? Both have trials - try it ;-) Im using EMS, like it, but for all features you have to use windows. Lg, AXEL. -- Gentoo? Debian? RedHat? SuSE? *BSD? Stop the distri-war, make little user!
Hello, > Both have trials - try it ;-) That's what I've done, as I mentioned. But sometimes others know/see things that I don't see/know, at least not within a restricted trial period. Sincerely, Wolfgang Keller -- P.S.: My From-address is correct
Wolfgang Keller wrote: >Hello, > > > >>Both have trials - try it ;-) >> >> > >That's what I've done, as I mentioned. But sometimes others know/see >things that I don't see/know, at least not within a restricted trial >period. > > It seems to me that EMS PostgreSQL Manager is more actively developed which probably is a good thing. Other than that, I agree with the, "both have trials" statement. SIncerely, Joshua D. Drake >Sincerely, > >Wolfgang Keller > > > -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
Just a FYI, you should also look at PG Lightning Admin (PGLA) it compares well with EMS and has some nifty features they don't have. i.e. EMS cannot cancel a long running query, they don't receive raise notices (last time I checked) and they can't view unicode data. Check it out at: http://www.amsoftwaredesign.com
On Thu, Sep 08, 2005 at 07:52:57AM -0700, Joshua D. Drake wrote: > Wolfgang Keller wrote: > > >Hello, > > > >>Both have trials - try it ;-) > > > >That's what I've done, as I mentioned. But sometimes others know/see > >things that I don't see/know, at least not within a restricted trial > >period. > > It seems to me that EMS PostgreSQL Manager is more actively developed > which probably is a good thing. Note that theKompany departed from the developers of the Rekall product, which they now distribute separately. See http://www.totalrekall.co.uk/ and in particular http://www.totalrekall.co.uk/modules.php?name=FAQ&myfaq=yes&id_cat=6&categories=Rekall+%3A+TheKompany So if you are trying a theKompany product, know that it may be obsolete and no longer in development. -- Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com "Aprender sin pensar es inútil; pensar sin aprender, peligroso" (Confucio)
I have a license of DataArchitect and it was a waste of money. I've used much better applications. I currently use ChiliSoft Database Design Studio. It has direct PgSQL support. Regards, Gavin On Sep 8, 2005, at 2:58 AM, Wolfgang Keller wrote: > Hello, > > I've searched for and tried nearly every database > administration/design tool available and it seems my choice has > narrowed down to these two. Now a second opinion would be nice to > have. Has anyone used one, better both of these? What do you think > about them? > > TIA, > > Sincerely, > > Wolfgang Keller > > -- > P.S.: My From-address is correct > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend > Gavin M. Roy 800 Pound Gorilla gmr@ehpg.net
> > Note that theKompany departed from the developers of the Rekall product, > which they now distribute separately. See http://www.totalrekall.co.uk/ > and in particular > > http://www.totalrekall.co.uk/modules.php?name=FAQ&myfaq=yes&id_cat=6&categories=Rekall+%3A+TheKompany > > So if you are trying a theKompany product, know that it may be obsolete > and no longer in development. I believe the person was asking about DataArchitect not Rekall. Sincerely, Joshua D. Drake > -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
I like both EMS PostgreSQL Manager and pgAdmin III. Both have their strengths and weaknesses, and I go back and forth between them depending on what I'm doing. I had a problem with the trial version of PG Lightning Admin - it seemed to "hang" when I backed up my database. No experience with DataArchitect.
Michael Schmidt
So it seemed to hang or it did hang? Have you tried a newer version? I routinely backup 100mb databases and it never hangs. I think one of the earlier versions did not change the cursor during the backup, is that what you mean by it appeared to hang? i.e. not being able to tell if it was doing anything? Also, I don't think you can even do backups with EMS. Thanks, Tony Michael Schmidt wrote: > I like both EMS PostgreSQL Manager and pgAdmin III. Both have their > strengths and weaknesses, and I go back and forth between them > depending on what I'm doing. I had a problem with the trial version > of PG Lightning Admin - it seemed to "hang" when I backed up my > database. No experience with DataArchitect. > > Michael Schmidt
Mr. Caduto,
I downloaded the version from the website recently, so I think it was the newest version. My database backs up in about 10 seconds with pgAdmin III. When I tried to back it up with PG Lightning Admin, I got a sql wait cursor for a couple of minutes, at which point I closed the program. I don't mean to criticize your product (which has some very nice features), just stating what happened.
I agree - EMS PostgreSQL manager does not offer backups and restores via pg_dump and pg_restore.
Michael Schmidt
I understand. there was a issue with the pg_dump compression level defaulting to 0 which may have had some effect, or it may have been some other non related network issue. PGLA uses pg_dump.exe and pg_restorel.exe in the exact same way PG Admin III does (via createprocesses API command) so speed bewteen the two should be exactly the same. If it takes 10 seconds in PG Admin, it's going to take 10 seconds on PGLA You should download it again and give it another go :-) I believe that PGLA gives a much better user experience on the windows platform than PGAdmin does.(I am biased of course:-) Thanks, Tony Michael Schmidt wrote: > Mr. Caduto, > I downloaded the version from the website recently, so I think it was > the newest version. My database backs up in about 10 seconds with > pgAdmin III. When I tried to back it up with PG Lightning Admin, I > got a sql wait cursor for a couple of minutes, at which point I closed > the program. I don't mean to criticize your product (which has some > very nice features), just stating what happened. > > I agree - EMS PostgreSQL manager does not offer backups and restores > via pg_dump and pg_restore. > > Michael Schmidt
In an earlier post, I mentioned that PG Lightning Admin seemed to hang when I did a dump. Mr. Caduto provided some help with this and the problem was resolved by setting my connection to "trust" in hba.conf.
Regarding Chilli Source Database Design Studio, I downloaded a trial copy and when I tried to "reverse engineer" my PostgreSQL database, got an error that pg_relcheck doesn't exist. Since pg_relcheck isn't used in PostgreSQL 8.0, perhaps the Chilli Source program hasn't been updated?
btw, another program that isn't bad is DBTools Manager.
Michael Schmidt
"Michael Schmidt" <MichaelMSchmidt@msn.com> writes:
> Regarding Chilli Source Database Design Studio, I downloaded a trial =
> copy and when I tried to "reverse engineer" my PostgreSQL database, got =
> an error that pg_relcheck doesn't exist. Since pg_relcheck isn't used =
> in PostgreSQL 8.0, perhaps the Chilli Source program hasn't been =
> updated?
pg_relcheck last existed in PG 7.2 ... if they are still expecting it to
be there, then they aren't maintaining that program at all :-(
regards, tom lane
Just as a FYI, having trust in the pg_hba.conf file on win32 is normally not needed for PGLA to backup a database, I have been unable to reproduce the error Michael experienced while running on XP sp 2, the only thing I can think of was the version of pg_dump.exe I was shipping was corrupted or something (8.0.2). on another note it seems that the only version of pg_restore.exe that will accept a password from the command line is 8.0.0. All later versions prompt for the password, but fail every single time. The only way to restore a file on anything above 8.0.0 (pg_restore) is to have the pg_hba.conf file set to trust. Thanks, Tony Michael Schmidt wrote: > In an earlier post, I mentioned that PG Lightning Admin seemed to hang > when I did a dump. Mr. Caduto provided some help with this and the > problem was resolved by setting my connection to "trust" in hba.conf.
> > on another note it seems that the only version of pg_restore.exe that > will accept a password from the command line is 8.0.0. > All later versions prompt for the password, but fail every single > time. The only way to restore a file on anything above 8.0.0 > (pg_restore) is to have the pg_hba.conf file set to trust. If the above is true could you please build a test case and submit it to hackers? > > Thanks, > > Tony > > Michael Schmidt wrote: > >> In an earlier post, I mentioned that PG Lightning Admin seemed to >> hang when I did a dump. Mr. Caduto provided some help with this and >> the problem was resolved by setting my connection to "trust" in >> hba.conf. > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
Joshua D. Drake wrote: > >> >> on another note it seems that the only version of pg_restore.exe that >> will accept a password from the command line is 8.0.0. >> All later versions prompt for the password, but fail every single >> time. The only way to restore a file on anything above 8.0.0 >> (pg_restore) is to have the pg_hba.conf file set to trust. > > > If the above is true could you please build a test case and submit it > to hackers? > > Joshua, Looks like it's already been reported back in July: http://groups.google.com/group/pgsql.bugs/browse_thread/thread/e47b7e96584c1d3c/8e7e2846222732fe?lnk=st&q=pg_restore+password+authentication+failed&rnum=2&hl=en#8e7e2846222732fe Maybe it fell through the cracks.