Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-10 Thread Tony Caduto
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) i

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-10 Thread Joshua D. Drake
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

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-10 Thread Tony Caduto
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

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-10 Thread Tom Lane
"Michael Schmidt" <[EMAIL PROTECTED]> 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

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-10 Thread 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 wh

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Tony Caduto
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 s

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread 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

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Tony Caduto
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

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Michael Schmidt
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 wi

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Joshua D. Drake
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 theKom

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Gavin M. Roy
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'vesearchedforand

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Alvaro Herrera
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 > >per

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Tony Caduto
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.

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Joshua D. Drake
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

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Wolfgang Keller
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 ---(end of bro

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Axel Straschil
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!